Tickets expert on technological issues. Methods for solving technological issues of large implementations

The exam is conducted to test the knowledge and skills necessary to address issues of major implementations on the 1C:Enterprise 8 platform.

Technical specialists with experience in large-scale implementations of information systems on the 1C:Enterprise 8 platform are invited to participate in the exam.

Requirements for specialists

• Knowledge of architectural features and implementation of 1C:Enterprise 8 mechanisms, which are critical in terms of ensuring the operation of a large information system. Including features and new features of new releases of the Technology Platform.
• Knowledge of design and development techniques for large information systems designed for the simultaneous operation of a large number of users
• Knowledge of methods of operating and configuring large information systems designed for the simultaneous operation of a large number of users
• Possession of methods and technologies for load testing of systems based on the 1C:Enterprise 8 platform
• Ability to administer an information system in order to achieve maximum performance and throughput while simultaneously working with a large number of users
• Ability to evaluate the effectiveness of a running system, monitor problems and bottlenecks
• Ability to investigate performance and concurrency issues in a heavily loaded system
• The ability to correctly diagnose technological problems that arise during the operational operation of a large information system, determine the cause of problems and offer an adequate way to solve them
• Excellent knowledge and understanding of all techniques of the technological knowledge base
• Level of training "1C Professional on technological issues"

Exam Information

The exam is held in oral and written form.

The written part consists of a test.

The oral part takes place as a result of a conversation with the examiner on three questions indicated on the ticket. You have 1 hour to prepare for your answer. 15 minutes are allocated for answering ticket questions (5 minutes per ticket question). If the specialist cannot formulate an answer to the ticket question within 5 minutes, the answer is not counted.

The total exam time is 85 minutes: 60 minutes for preparation and 25 minutes for oral conversation with the examiner.

During the oral conversation with the examiner, the time is distributed approximately as follows:

• 5 minutes to check the written part (if necessary, for example, if the handwriting is illegible, clarifying questions will be asked);
• 15 minutes to answer three questions on the ticket;
• 5 minutes for additional questions if necessary.

To successfully pass the exam and obtain the 1C:Technology Expert certificate, you must:

• Answer 80% of the test questions correctly.
• Correctly answer all three questions indicated in the ticket.
• When answering additional questions of the examiner, demonstrate understanding subject area(more below).
• If the trainee last attended the training more than 12 months before the exam or did not attend the training at all, it is necessary to attend the training in order to successfully pass the certification.

The cost of participation in the exam is 4,900 rubles.

Exam ticket example

QUESTION 1

In the configuration metadata, the sequence "Partition Accounting" with the dimension "Organization" is defined. The document posting handler contains the following code:

Selection = New Structure("Organization");
Filter.Insert("Organization", Organization);
Sequences.Partition Accounting.SetBorder(CurrentDate(), Selection);

In what case can documents of this type be carried out in parallel by different users, and in what case not? Justify your answer. How it is possible to increase parallelism of work in this case?

QUESTION 2

What does TABLE SCAN operation mean in MS SQL Server query plan?

When does the presence of this operation indicate query performance problems?

What negative consequences for system performance can MS SQL Server's choice of such a query plan have?

How is this operation different from CLUSTERED INDEX SCAN?

What are the possible causes of such a "error" MS SQL Server "a.

QUESTION 3

There is a really working multi-user information system on the platform 1C:Enterprise 8.1. As a result of the analysis of system performance, the following excessive locks were found in documents of the type “Sale of Goods and Services”:

• Blocking of redundant entries when checking balances in the GoodsInWarehouses register. The reason is a non-optimal query plan.
• Lock on the empty table of the GoodsOrganizations register. The reason is the peculiarities of the implementation of locks in MS SQL Server
• Lock on adjacent records of the index range when working with the Batch of Goods register. The reason is the peculiarities of the implementation of locks in MS SQL Server

Suggest a way to solve this problem. Describe in detail all the necessary actions.

Examples of additional questions

Question 1

When are shared managed locks released?

Question 2(requires excellent understanding)

Will the MS SQL Profiler trace show events of the Locks\Lock:Acquired class in case of an unsuccessful attempt to acquire a transactional lock?

Question 3(requires excellent understanding)

What is the difference between a covering index and a composite index?

Question 4

How exactly can you find the configuration code that executed the client-server call that required the largest amount of process RAM?

The call must be found among all calls made during the last hour of the information system.

Question 5(requires good understanding)

What is the difference between synchronous updating of statistics and asynchronous updating of statistics in MS SQL Server 2012 DBMS?

Question 6(requires good understanding)

How to determine if there is enough RAM allocated on the server for the PostgreSQL DBMS to work?

Exam preparation

The exam is designed for specialists with experience in implementing large information systems on the 1C:Enterprise 8 platform, and involves self-study.

Materials for self-preparation for the exam:

• Questions for certification "1C Professional on technological issues"
• The book of E.V. Filippov "Handbook 1C: Expert on technological issues" Edition 2

To successfully pass the certification "1C: Expert on technological issues" you must:

• It is great to understand what transaction isolation levels are used by the Technology Platform, and how they differ.
• It is great to understand the difference between managed and object locks, when locks are placed, when they are removed.
• Perfectly understand how to investigate a timeout on a transactional lock on a DBMS, find the victim and the culprit of the error, investigate the cause and propose a solution.
• It is great to understand how to investigate a deadlock on a DBMS, find the victim and the culprit of the error, investigate the cause and propose a solution.
• Perfectly understand how to investigate a timeout on a controlled lock, find the victim and the culprit of the error, investigate the cause and propose a solution.
• Perfectly understand how to investigate a deadlock on managed locks, find the victim and the culprit of the error, investigate the cause and propose a solution.
• It is great to understand what indexes are and how they are used by the DBMS.
• Excellent knowledge and understanding of all techniques of the technological knowledge base
• Good understanding of how to investigate a problem slow work specific operation.
• It is good to understand how to investigate the problem of significant memory consumption by rphost processes.
• Have a good understanding of how to properly configure a working system, including web servers, Technology Platform, DBMS
• It is good to understand how to properly assess the workload of information system equipment.
• Have a good understanding of the structure and features of the Technological Platform.
• Have a good understanding of the structure and features of the Corporate Toolkit.
• Have the skill of developing in an embedded language and know SQL.

In the event that a specialist cannot answer questions that require excellent understanding, then most likely such an answer will not be counted as a positive one.

In the event that the specialist is unable to answer questions that require a good understanding, the specialist will be asked additional questions on sections that require excellent understanding.

Starting today, I am preparing for the most difficult of the certifications for technical specialists in 1C - Technology Expert. I decided to pass this certification for myself, because I would like to know all the features of the 1C Enterprise 8 architecture in the client-server mode of operation, learn how to achieve maximum results in IS performance, and also be able to analyze all the bottlenecks information bases based on the 1C platform.

For preparation, the book "Handbook 1C Expert on Technological Issues" is perfect.

Attention! Our company does not certify and prepare specialists for this exam. It's just personal experience one of our programmers. To prepare for certification, use the official materials of 1C and numerous courses.

In the first post, I will describe the rules for passing the 1C Expert exam, give some examples of test tasks, and collect the main links for preparing on this topic.

Many people say that only franchisee companies need certificates and exams to raise their rating and get discounts on PP - I don’t agree. In my practice, the knowledge gained during the preparation really helps in solving everyday problems. For example, take . After passing this certification, I began to think much less about small technical details, the quality of the code improved, and the time to write was reduced. And in our business, as in many other businesses, time is money 🙂

Certification of specialists for knowledge of the technical nuances of the 1C 8.3 system takes the form of an exam (first day) and subsequent training (three days).

The exam is on the first day. If you answered the examiner's questions unsatisfactorily on the first day (received a minus), the chance of getting the coveted certificate is almost zero - you should have spent more time preparing. However, be sure to stay for the subsequent practical training - it will give you invaluable experience. If you received a “plus minus” on the theoretical part, i.e. answered not perfectly, but in general they answered quite correctly, you can prove your competence during the training. If you prepared brilliantly and answered all the questions of the examiner, and received a "plus" for the theory, you will definitely receive a certificate, but you still need to participate in the seminar.

At the subsequent, after the exam, training, practical matters- how to optimize work, search for "bottlenecks", you will see the action, learn how to find queries that are not optimally composed, understand the intricacies of load testing and much more. In general, there is nowhere else to get such knowledge: either achieve it yourself, stuffing bumps on the project, or learn from the original source (1C) in 3 short days.

If suddenly it happened and you didn’t pass the certification “1C Expert on Technological Issues” the first time, then you don’t have to attend the training at the retake.

The cost of the exam is 4500 rubles. An example of a ticket can be viewed.

Get 267 1C video lessons for free:

Download tickets 1C Expert

At the exam, each candidate for the title of expert is given a ticket, each of which contains 3 questions.

On this resource you can download tickets that were found on the Internet and collected in one archive. No one guarantees their correctness, however this the best option exam preparation:

What you need to know to pass 1C Expert?

In short, everything necessary knowledge can be divided into four major themes:

Rubricator of materials for 1C Expert

Theory:

Practical Training Program 1C Technology Expert

First day

General approaches and basic methods for solving technological issues of major implementations at all stages of the life cycle:

• at the stage of design preparation and development;
• at the implementation stage;
• at the operational stage.

Second day

• "Performance Control Center":
  • health and performance monitoring;
  • collection of information about performance problems when working with data, search for "bottlenecks";
  • problem analysis;
• typical causes of performance and scalability problems;
• optimization methods;
• blocking;
• deadlocks.

The third day

• improved performance and scalability;
• solution of technological issues of large implementations;
• work with clusters;
• transactions;
• methods of information storage organization.

Materials for preparation for certification 1C Expert on technological issues

Books:

Admin Guide

It is very useful to get acquainted with the questions on the technology magazine, the organization of clusters, etc. to prepare for the expert.

Architecture and work with data "1C: Enterprise 8.3".

organization of data when building an IS based on 1C

Professional development in the 1C Enterprise 8.2 system

Questions about data organization optimizing the operation of the program - this should be known not only by an expert, but by a specialist.

Links:

First of all, I would like to note the official 1C resource - a knowledge base on technological issues for large implementations. It contains available information from the primary source - 1C.

Under the program, the applicant will receive unique experience in solving real problems and will be able to pass an individual exam for the certificate "1C: Technology Expert" in a remote format.

The certificate "1C: Technological Expert" is the highest level in the hierarchy of 1C certificates. It confirms that its owner has the knowledge and skills necessary to successfully resolve any technological issues of a major implementation, gives the partner company the right to conduct CKTP projects together with 1C, and is also mandatory for the partner to obtain the status of "1C: ERP Center".

Obtaining the certificate "1C: Technological Expert" is associated with significant difficulties - most do not have enough practical experience, the exam (in the format of a three-day training) is held once a month in " training center No. 1”, registration for the exam is limited.

In order to develop the direction of technological expertise and simplify the acquisition of knowledge on major implementations, 1C introduces the following additions to the existing 1C: Experts training program:

• When working on a CKTP project, specialists with a 1C:Technology Expert certificate can take help of specialists with a 1C:Technology Professional certificate, and such specialists (applicants) can be recruited from another franchisee. The presence of applicants in the team will help to complete the project faster and better, increase the individual rating of "Technological Issues Expert".
• When working on a CKTP project, the applicant receives practical knowledge and skills under the guidance of an experienced 1C:Expert, while contacting the specialists of the 1C company.
• After the successful completion of the project, the 1C specialist can assign the applicant an individual (out of schedule) remote oral-written exam, similar to the one that is carried out as part of the full-time certification (with the possibility of retake). Upon successful completion of the exam, a certificate "1C: Technological Expert" will be issued.

The participation of the applicant does not cancel mandatory requirement on the participation of 1C:Expert in the TsKTP project. No more than three applicants can be involved in the CKTP project, working together with 1C:Expert.

The right to pass an individual exam is given to those applicants who, through their own fault, do not allow downtime and errors in working area of the client, promptly (within one business day) provide correct data upon requests from 1C and apply the recommendations agreed with 1C within three business days. The applicant must submit an application for the exam no earlier than one month after the start of participation in the CKTP project and no later than the deadline for completing work on the CKTP project.

With more detailed information O new program"Applicant in 1C: Experts on technological issues" can be

Updated material

Course recorded on version 8.3 using MS SQL Server 2014 And latest versions productivity tools, with a detailed description of the new settings and features.

Wherein work with 8.2 is also described in the course.

Two new sections: “Testing” and “Backup”

The “Testing” section covers both testing using the Test Center configuration and automated testing. Plus, questions on the equipment for testing are considered.

The “Backup” section discusses the issues of creating backups from scratch using the example of MS SQL Server. It also provides information about recovery models, how they work, and how they relate to backup.

Material format changed

With it, you can quickly find information on any of the topics covered in the course, and also use it as a reference when you encounter performance problems.

The course has become much more detailed

Added more details and technical details on all topics, which will be very useful for preparing for the exam for 1C: Expert and testing for 1C: Professional on technological issues.

• Added lessons for handling exceptions in a transaction
• Added information on intent blocking
• Added work parallel table when using PostgreSQL
• Example added parsing a deadlock using the technology log
• Added information about parallel operation of metadata objects in different modes with different settings.
• Added information about new type of mutex
• Added detailed description 1C server cluster devices, including a description of the main service files
• Updated problem solving to prepare for 1C:Expert
• Added unique processing, which allows you to see exactly which records in terms of metadata are currently locked
• Whole added backup section
• Added information on mechanism for storing and retrieving results
• Added information about lock lifetime V different levels transaction isolation
• Added information on the load testing and selection of appropriate equipment
• Added information on using the mechanism automated testing
• Added information about impact of sorting on performance requests
• Added information about work dynamic lists
• Added information on recommended practices programming
• Added useful scripts and dynamic views

Added new practice tasks

Many of the added tasks are based on real situations from optimization projects.

Also added updated final task which has become even more complex and interesting.

Support in the Master Group

Support is provided on the course lesson pages. You can ask any question about the course materials.

Also you get access to hundreds of questions and answers to them from other course participants.

Support duration: up to 4 months(depending on the selected version of the course).

You can activate access to the Master group in any convenient time within 100 days of purchase.

Membership Requirements

There are no special requirements for course participants.

To successfully complete the course, you must have at least minimal development experience in 1C.

You need a computer with 1C 8.3 and Windows

The secure video player only works in Windows environments. Video viewing is not possible in virtual environments and with remote access tools.

Course and cost versions

This course has THREE versions: LITE, PROF, ULTIMATE.

They differ in purpose, content, cost and terms of support in the Master Group.

For buyers of the Diagnose Performance Issues course

The cost of the course “Diagnosis of 1C performance problems: what specifically slows down the system” will be count when purchasing the course "Acceleration and optimization of systems on 1C: Enterprise 8.3".

You simply place an order for the appropriate version of the Optimization course, while in the order you indicate the discount code that was sent to you after purchasing the course “Diagnosing performance problems”.

For example, taking into account the discount, the LITE version will cost 11,300 9,800 rubles.

Guarantee

We have been training since 2008, we are confident in the quality of our courses and give our standard 60 day warranty.

This means that if you started taking our course, but suddenly changed your mind (or, say, do not have the opportunity), then you have a 60-day period to make a decision - and if you make a return, we will refund 100% of the payment.

Installment payment

Our courses can be paid in instalments or in installments, even without interest. Wherein you get access to the materials immediately.

This is possible when paying individuals in the amount of 3,000 rubles. up to 150,000 rubles.

All you need to do is select the payment method "Payment via Yandex.Checkout". Then, on the website of the payment system, select “Pay in installments”, indicate the term and amount of payments, fill out a short questionnaire - and in a couple of minutes you will receive a decision.

Payment Options

We accept all major forms of payment.

From individuals- payments from cards, payments with electronic money (WebMoney, YandexMoney), payments through Internet banking, payments through communication stores, and so on. It is also possible to pay for the order in parts (in installments), including without additional interest.

Start placing an order - and in the second step you will be able to choose your preferred payment method.

From organizations and individual entrepreneurs– non-cash payment, delivery documents are provided. You enter an order - and you can immediately print an invoice for payment.

Multi-employee training

Our courses are designed for individual learning. Group training on one set is illegal distribution.

If a company needs to train multiple employees, we usually offer “add-on kits” that are 40% cheaper.

To place an order for an “additional kit” select 2 or more course sets in the form starting from the second set the cost of the course will be 40% cheaper.

There are three conditions for using additional kits:

• you cannot purchase only an additional set if at least one regular set has not been purchased before (or together with it).
• there are no other discounts for additional sets (they are already discounted, it would have turned out to be a “discount on a discount”)
• promotions (for example, compensation of 7,000 rubles) do not apply to additional sets for the same reason

Handbook 1C: Expert on technological issues. Edition 2 is devoted to the theory and practice of solving problems of performance and parallelism in information systems on the 1C:Enterprise 8 platform.

The paper provides the theoretical information necessary to understand the main mechanisms that ensure the functioning of the 1C:Enterprise 8 platform and the DBMS as a multi-level multi-user system. In addition, the algorithm of the main business process of investigating problems is given and practical methods for solving specific application problems are given: it describes the deployment, configuration and use of tools for reproduction and investigation, as well as possible ways fixes applied when the causes of problems are found.

When working on the publication, the experience of preparing employees for certification "1C: Expert on technological issues" was taken into account: the book contains the materials and methods necessary for preparing for certification.

The book also includes techniques developed by the author over a long period of time to solve practical problems of performance and parallelism. To a large extent, these are methods of prevention, regular monitoring and early diagnosis.

In the second edition, inaccuracies in the theoretical part and in the instructions were corrected, and new materials were added.

The book is intended for "1C: Technology Experts", for employees of the customer's IT services (IT directors, system administrators, methodologists, DBMS administrators), as well as for employees of 1C: Franchisees: implementers, developers, project managers.

Chapter 1

Chapter 2. Basic Approach to Problem Solving

• We only deal with problems
• How to measure, how to get numbers
• How the system works
• Problem solving business process for key operations

Chapter 3. Theory

• Key Operations
• APDEX Method
• Critical errors
• System Availability Calculation
• Transaction routine work. Rollback transactions
• DBMS data locks. Block levels. Lock Compatibility
• About Managed and Object Locks
• Lock Errors: Timeouts and Deadlocks
  • General issues
  • Time-out
  • Deadlock
• Block escalation
• About Concurrency of Operations with Data of Different Types
  • General information
  • Narrow places
  • Real transactions Record + Record
  • Real transactions Read + Write
• Information about the placement of data. How to get this information
• Information about database indexes. How to obtain this information. Clustered and non-clustered indexes
  • Important addition on indexes for 8.3 without compatibility mode
• Query plans. Getting the query plan in SQL profiler. Plan operators most important to us
  • Getting a query plan in SQL Profiler
  • The most important operators for us
• Features of reading in the object model
• Working with SQL Server Where are temporary tables stored. Where Snapshots are stored for isolation level Read Committed Snapshot
• Working with SQL Server Where to place bases. How to transfer bases
• Working with SQL Server Differences between full (FULL) and simple (SIMPLE) database recovery models. Features of transaction log compression
• Working with SQL Server Setting up and using backups of various types

Chapter 4 Instructions

• How to configure the collection of information about equipment load and how to evaluate this load
• Finding out disk speed
• Configuring automatic restart of the 1C server
  • Restart using platform tools
  • Restarting a service using the operating system
• Scheduled SQL Server Operations and Configuring Their Automatic Execution
  • General issues
  • Updating SQL Server Statistics
  • Clearing the procedural cache (plan cache)
  • Index defragmentation
  • Reindexing database tables
  • Monitoring the implementation of scheduled tasks
• How to enable the 1C technology log and how it can be parsed
• General approach to the analysis of the technological journal "1C"
• Performance measurements
  • Performance measurement by 1C8 debugger
  • The simplest timing code
  • Evaluation of the performance of the BSP (installation instructions, job description)
• Network requirements. How to check the network
  • General issues
  • Network errors
  • Insufficient throughput
  • Routing
  • Active equipment add-ons
  • 1C landscape server add-ons
  • Network Services
• Collection of dump statistics (general principle)
  • Automated dump collection
  • Collecting dumps manually
• Working with the CCC. General principles, standard features, initial setup
  • General issues
• Working with the CCC. Setting up your own control procedures
• Working in profiler. How to get a query plan
• Working in profiler. How to get the sum of duration
• Working in profiler. How to get deadlock graph
• Working in profiler. How to get lock escalation information
• Working with the CUP. General principles, standard features, general workflow, setup wizard, rights table
  • General issues
  • What you need to do to get started
  • Database connection wizard
  • Rights required for the operation of the PCC
• Working with the CUP. Getting a query plan
• Working with the CUP. Deadlock parsing
• Working with the CUP. Regulatory monitoring
• Work in the configurator. Fixing Requests
  • List of rules
  • Explanation of Rule 3 (“FOR CHANGE”)
  • Explanation to rule 4 (correspondence of indexes and query conditions)
  • Explanation for rule 8 (do not use subqueries in conditions)
  • Explanation for rule 9 (don't use joins with subqueries, but use temporary tables)
  • Explanation to rule 10 (do not connect virtual tables with real ones, as well as virtual tables with virtual ones)
  • Explanation to rule 13 (reject OR in problem queries)
  • Explanation to rule 14 (Avoid queries on empty tables in automatic control locks "1C")
  • Explanation to rule 15 (do not get a value through a dot from a field of a composite type)
  • Clarification to rule 16 (understand how a request can be modified by the platform while the RLS mechanism is running)
• Load tests
  • Protozoa
  • Stop in debugger
  • Stop in modal form
  • Load testing by batch processing
  • Work with the Test Center. General principles and standard features. A simple test with the Test Center
  • Embedding Test Center
  • Work with the Test Center. Full Test Template
  • Work with the Test Center. Universal load test
  • Work with the Standard load test "1C". General principles and standard features
  • New 8.3 Features for Functional and Load Testing
  • Classification of load testing
  • Investigation of platform crashes, blocking errors and reasons for poor performance that were reproduced during the test
• General diagnostics business process
• Work in the configurator. Editing the Lock Timeout Parameter
• Working with TJ. How to see which managed locks have been set
• Working with TJ. How to investigate conflict on managed locks
• Measuring Performance Trends by Logging
• About opening modal windows in a transaction
• Hook to get call stack when debugging is not available
• How to Build a Failover Cluster 8.3 from Two Servers
• How to leave the licensing service on only one cluster server 8.3
• How to Build a Failover Cluster 8.2 from Two Servers
  • Set up an 8.2 failover scheme with scaling and load balancing
• Working with the CCC. How to make code available for debugging
• Working with the CCC. Deployment for Lock Error Control

Chapter 5. Techniques and additional information

• Overview of paid and free tools
• Requirements from the ITS disk used when checking for 1C: Compatible!, affecting performance
• Clarifications important for a general understanding of the picture
• Design and technical decisions leading to problems
• Configuration tricks that lead to problems
• Daily monitoring

Chapter 6 Additional Notes

• The Economic Sense of Accounting Automation and Performance Optimization
• About 24x7 availability mode
• About the equipment calculation method
• About work in various DBMS

Chapter 7. Conclusion. About system performance guarantees in a few years

List of abbreviations