home Success stories 1c technology expert questions. Methods for solving technological issues of large implementations

1c technology expert questions. Methods for solving technological issues of large implementations

Material updated

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

Wherein working 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 regarding testing equipment are considered.

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

The format of materials has changed

It can be used to quickly find information on any of the topics covered in the course, and can also be used as a reference if you encounter performance issues.

The course has become much more detailed

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

Added lessons on handling exceptions in a transaction
Added information on intent locks
Added parallelism table when using PostgreeSQL
Example added clearing deadlocks using a technology log
Added information about parallel operation of metadata objects V different modes with different settings.
Added information about new type of deadlock
Added detailed description 1C server cluster devices, including a description of the main service files
Updated solving problems to prepare for 1C:Expert
Added unique processing, which allows you to see which records in terms of metadata are currently blocked
Added whole backup section
Added information on mechanism for storing and retrieving results
Added information about lock lifetime in different transaction isolation levels
Added information on conducting 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 on work dynamic lists
Added information on recommended techniques programming
Added useful scripts and dynamic views

Added new practical 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.

Master group support

Support is provided on the course activity 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.

Duration of support: 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 from the date of purchase.

Requirements for participants

There are no special requirements for course participants.

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

You need a computer with 1C 8.3 and Windows

The protected player for viewing video materials works only in Windows environments. Video viewing is not possible in virtual environments or with remote access tools.

Course and cost versions

U this course there are THREE versions: LITE, PROF, ULTIMATE.

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

For buyers of the Diagnosis of Performance Problems course

The cost of the course “Diagnostics of 1C performance problems: what exactly is slowing 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, and in the order you indicate the discount code that was sent to you after purchasing the “Diagnostics of Performance Problems” course.

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

Guarantee

We have been teaching 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 change 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 return 100% of the payment.

Installment payment

Our courses can be paid for in installments or in installments, including without interest. Wherein You get immediate access to materials.

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

All you need to do is select the payment method “Payment via Yandex.Checkout”. Next, on the payment system website, select “Pay in installments”, indicate the term and amount of payments, fill out a short form - 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 shops, and so on. It is also possible to pay for the order in installments (in installments), including without additional interest.

Start placing your order - and in the second step you can choose your preferred payment method.

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

Training of several employees

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

If a company needs to train multiple employees, we typically offer “add-on kits” that cost 40% less.

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 was not purchased before (or along with it)
There are no other discounts for additional sets (they are already discounted, it would be a “discount on a discount”)
promotions are not valid for additional sets (for example, compensation of 7,000 rubles) for the same reason

Starting today, I begin preparing for the most difficult certification for technical specialists in 1C - Technology Expert. I decided to undergo this certification for myself, because I would like to learn all the features of the 1C Enterprise 8 architecture in client-server mode, 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.

The book " Desk book 1C Expert on technological issues.”

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

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

Many people say that certificates and exams are needed only by franchisee companies to raise their ratings and receive discounts on PP - I disagree. In my experience, the knowledge gained during 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 writing time decreased. And in our business, as in many other matters, time is money :)

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

On the first day there is an exam. If you answered the examiner’s questions unsatisfactorily on the first day (received a minus), your chance of receiving the coveted certificate is almost equal to zero— we should have spent more time preparing. However, be sure to stay for the subsequent practical training - you will gain invaluable experience there. If you received a “plus minus” on the theoretical part, i.e. They didn’t answer perfectly, but overall they answered quite correctly, you can prove your competence during the training. If you prepared brilliantly and answered all the examiner’s questions, 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 training, after the exam, practical issues are discussed - how to optimize work, search for bottlenecks, you will see action, learn to find not optimally composed queries, understand the intricacies of load testing and much more. In general, there is nowhere else to get such knowledge: either achieve it yourself, making headway on a project, or learn from the original source (1C) in 3 short days.

If suddenly this happened and you did not pass the “1C Technological Expert” certification the first time, then you no longer have to attend the training at the retake.

The cost of the exam is 4,500 rubles. You can see an example of a ticket.

Get 267 video lessons on 1C for free:

Download 1C Expert tickets

During 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, but this the best option exam preparation:

What do you need to know to pass 1C Expert?

In short, all the necessary knowledge can be divided into four large topics:

Categories for 1C Expert materials

Theory:

Practical training program 1C Technology Expert

First day

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

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

Second day

"Performance Management Center":
- health and performance monitoring;
- collecting information about performance problems when working with data, searching for bottlenecks;
- problem analysis;
common causes of performance and scalability problems;
optimization methods;
blocking;
deadlocks.

The third day

increased performance and scalability;
solving technological issues of large implementations;
working with clusters;
transactions;
methods of organizing information storage.

Materials for preparing for 1C certification Expert on technological issues

Books:

Administrator's Guide

It is very useful to prepare for the expert to familiarize yourself with questions on a technology magazine, organizing clusters, etc.

Architecture and working 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 - not just an expert, but a specialist should know this.

Links:

First of all, I would like to note the official 1C resource - a knowledge base on technological issues for large-scale implementations. Collected there available information from the original source - 1C company.

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

The work provides theoretical information necessary to understand the basic mechanisms that ensure the functioning of the 1C:Enterprise 8 platform and the DBMS as a multi-level multi-user system. In addition, an algorithm for the main business process of investigating problems is given and practical techniques for solving specific application problems are provided: the deployment, configuration and use of tools for reproducing and investigating, 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 to prepare for certification.

The book also includes techniques developed by the author over a long period of time for solving 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:Experts on technological issues”, for employees of the customer’s IT services (IT directors, system administrators, methodologists, DBMS administrators), as well as for employees of 1C: Franchisee companies: implementers, developers, project managers.

Chapter 1. Let's go up to the porch and open the door

Chapter 2. Basic approach to problem solving

We only work with problems
How to measure, how to get numbers
How the system works
Business process for solving problems for key operations

Chapter 3. Theory

Key Operations
APDEX Method
Critical errors
System Availability Calculation
Regulatory work of the transaction. Rollback transactions
DBMS data locks. Blocking levels. Lock compatibility
About managed and object locks
Locking errors: timeouts and deadlocks
- General issues
- Time-out
- Deadlock
Block escalation
About Concurrency in Data Operations different types
- General information
- Narrow places
- Real transactions Write + Write
- Real Transactions Read + Write
Information about data placement. How to obtain this information
Information about database indexes. How to obtain this information: Clustered and nonclustered indexes
- Important addition on indexes for 8.3 without compatibility mode
Query plans. Getting a query plan in the SQL profiler. Plan operators most important to us
- Getting a query plan in the 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 are Snapshots stored for the Read Committed Snapshot isolation level?
Working with SQL Server. Where to place the bases. How to transfer databases
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

Chapter 5. Techniques and additional information

Review of paid and free tools
Requirements from the ITS disk used when checking on 1C: Compatible!, affecting performance
Clarifications important for a general understanding of the picture
Design and technical solutions leading to problems
Configuration Practices that Cause Problems
Daily monitoring

Chapter 6 Additional Notes

Economic sense of accounting automation and productivity optimization
About 24x7 availability mode
About the equipment calculation method
About working in various DBMSs

Chapter 7. Conclusion. About guarantees of system performance after several years

List of abbreviations

As part of the program, the applicant will receive unique experience in solving real problems and will be able to pass an individual exam for the “1C: Expert in Technology Issues” certificate in a remote format.

The “1C: Technology Expert” certificate 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 major implementation, gives the partner company the right to conduct TsKTP projects together with the 1C company, and is also mandatory for the partner to obtain the “1C: ERP Center” status.

Obtaining the “1C:Technology Expert” certificate is associated with significant difficulties - most people lack 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 area of technological expertise and simplify the acquisition of knowledge on issues of major implementations, 1C is introducing the following additions to the existing 1C:Experts training program:

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

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

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

For more detailed information about the new program “Challenger in 1C: Experts on Technological Issues”, you can

The 1C company, together with certified 1C:Technology Experts and other technical specialists, conducts Knowledge base on technological issues of large implementations. The knowledge base contains materials in the following areas:

Methods and technologies aimed at increasing technological quality major implementations

Problems and solutions

The 1C company also publishes other materials on administration of 1C:Enterprise 8, development methods, optimization methods, equipment selection and other issues of large implementations.

1C:Technology expert

The implementation of corporate information systems places increased demands on the qualifications of technical specialists. Successful implementation requires experience and knowledge that will allow:

avoid mistakes at the stage of finalizing the code of the application solution;

select equipment that provides sufficient system performance;

provide full load testing of the system;

carry out successful implementation;

correctly administer the operating system;

monitor and analyze the performance of a running system;

solve technological problems that may arise during the implementation and operation of the system.

The company "1C" carries out certification of technical specialists according to their competencies "1C: Expert on technological issues". Specialists who have this certificate have the experience and knowledge necessary to successfully resolve any technological issues of large-scale implementation.

A mandatory part of certification is the participation of a specialist in training "Increasing system performance and scalability". Main objectives of the training:

exchange experience and knowledge;

obtain the theoretical knowledge necessary to solve problems of corporate implementations;

acquire practical skills in solving these problems;

master methods and technologies designed to solve these problems.

The company "1C" publishes in the public domain list of organizations with certified specialists on their staff.

Enterprise Technology Support Centers

The company "1C" provides paid services for technological supervision of projects for implementation and support of corporate information systems on the platform 1C:Enterprise 8.

All work is carried out with the participation of 1C Company developers, who:

Provide all necessary techniques and tools;

Monitor the correctness of the technical decisions made;

Provide prompt assistance in solving complex technical problems;

Monitor the progress of work and the results obtained.

Knowledge base on technological issues of major implementations on the 1C:Enterprise 8 platform

1C company, jointly with certified “1C:Technology Experts” and other technical specialists, maintains and regularly updates a knowledge base on technological issues of major implementations. The knowledge base is the main source of information on these issues and, as it develops, will contain comprehensive information on:

Methods and technologies aimed at improving the technological quality of large-scale implementations

Problems and solutions

The knowledge base on technological issues of large implementations is a constantly updated information resource. Follow the knowledge base updates. On the developer forum The section "Technological Issues of Major Implementations" provides up-to-date information on all updates. In this section you can discuss topics for future articles.

Control questions:

1. What does the 1C:Enterprise 8 software system include?

2. Areas of application of “1C:Enterprise 8”.

3. Typical application solutions on the 1C:Enterprise 8 platform and their purpose.

4. Architecture of the 1C:Enterprise 8 platform (version 8.3.1).

5. Selecting an automation system on the 1C:Enterprise 8 platform. Standardization of standard solutions.

6. Architectural and technological solutions in the 1C:Enterprise 8 platform that increase system performance.

7. Composition and purpose of “1C: Corporate tool package”.

8. Use of the “Corporate Tool Package”.