Standard load test. Standard load test Don't run the test on the server the users are currently working on or they'll get sad! The test gives a very high load

Current version: 2.0.011. Version history here: versions.php

You can download it here: http://infostart.ru/public/173394/ or here: perfomanceTest.cf

The test allows you to measure the performance of the link 1c server - DBMS server in various options in multithreaded mode. The test takes 20-30 minutes.

Don't run the test on the server that the users are currently working on or they'll get sad! The test gives a very big load!

The test results can be viewed as a report inside the configuration.

Load test TPC-1C Gilev

It is also possible to share results with other people who have completed the test using the Share Results processing. After the exchange, it will be possible to compare your results with the results of other people.

More detailed instructions, as well as a discussion of the test can be found at http://infostart.ru/public/173394/.

There are 751 results in the database, Last update from 2018-06-15 06:33:26. The results can be viewed by downloading the test and running the results exchange, or (in a simplified form) here: results.php

Statistics

Version 1.x results: index_old.php

Charting uses c3js and d3js (c3js depends on it).

Put things in order in your work using the configuration 1C "IT Department Management 8"

ATTENTION! Ctrl-F5 or ctrl-r

2000 Human.

background

A mandatory operation for any implementation or modification of an existing information system is the assessment of the required speed of the system and the planning of the necessary computing resources for its implementation. At present, there is no exact solution to this problem in general view, and if, despite
its complexity and cost, such an algorithm will be proposed by some manufacturer, then even small changes in the hardware, version software, system configuration or the number or standard behavior of users will lead to significant errors.
However, there are plenty of ways to evaluate the software and hardware configuration required to achieve the desired performance. All of these methods can be used in the selection process, but the consumer must understand their scope and limitations.

Most of the existing performance evaluation methods are based on
or other type of testing.

There are two main types of testing:
component and integral.

Component testing is carried out
testing of individual components of the solution, starting from performance
processors or storage subsystems before testing
performance of the server as a whole, but without the payload in the form of one or another
business applications.

Stress Testing

The integral approach is characterized by the assessment
performance of the solution as a whole, both its software and hardware parts.
In this case, it can be used as a business application that will be used
in the final solution, as well as some model applications that emulate
some standard business processes and workloads.

Tests TPC and other universal tests allow you to choose the most promising platforms and compare offers from different manufacturers, but they are only background information that does not take into account the specifics of the business. Specialized tests allow you to more accurately choose specific model server and its configuration. However, the most informed decisions are made only on the basis of the results of load tests. Only they allow you to optimally configure the selected
server platform and tune it for maximum performance.

What's happened TPC-1C-GILV

This is a series of independent tests designed to evaluate the performance of the 1C:Enterprise 8.1 platform on your computer(s).

Of course, an "independent" test means that it is not sponsored by 1C.

Test is currently available TPC-A-local Throughput/ TPC-1C-GILV-A" (last updated August 2008 version 1.0.3)

test idea TPC-A-local Throughput/ TPC-1C-GILV-A

You download the configuration upload file (~400 Kb) from this site and upload it to your site. If you deploy the configuration in file options, then to a large extent the test will test the "CPU of your computer - HDD where the base lies" link.

If you expand the configuration into a client-server version, then the CPU of the application server - the CPU of the server of the subd - HDD - of the server of the subd will be mainly subjected to the load.

The test intensively writes 5,000 documents. There is no deep meaning in the business logic of the code, it is simply the performance of the document X conditionally chosen as the standard that is evaluated.

The main beauty of the test is that you do not need to know the technical details. The test is self-executing and gives a score. In addition, you don’t have to tell the result to whom either 🙂

You can compare the performance of several servers, or one server with different disk subsystem characteristics.

By performing a test from the application server and from the client over the network, you can understand the impact of the network from the client to the server.

How to run a test

Running a test is very easy. Gotta push the button

and wait until the test indicator (to the right of the button) reaches 100%.

The test usually takes about 8 minutes.

What do test results mean

The test result is presented as the "write rate" of the test data. The error of the test is 2 units. For an accurate assessment, you can repeat the test 3 times.

After the test indicator reaches 100%, you will see graphs like this:

Below the graphs are some previous similar tests.

The color of the graph hints at the current quality of the "total" performance for work without taking into account locks.

The green color of the graph, together with some indicators on the right, conditionally chosen as benchmarks, allows us to make a cross-platform generalized assessment of "good" performance 🙂

How to enjoy test results

As a result, you received a certain performance index (consider speed). It doesn't matter if the result is good or bad, it is the result of the PLATFORM running on your hardware. In the cases of the client-server version, this is the result of a complex chain of passing requests through various sections. You get the overall actual result, which is determined by the BOTTOM POINT in the system. THE BOTTLE PLACE IS ALWAYS!

In other words, both DBMS settings, OS settings, and equipment affect the overall team result 🙂

Which server is better

This test, performed on a specific server, gives a result on a set of hardware settings, operating system, subd etc. However, a high score on a particular server hardware means that, under normal conditions, the same result will be on identical server hardware. This test is free help in the ability to compare the installation of 1C:Enterprise under Windows and Linux, three different DBMS supported by the 1C:Enterprise 8.1 platform.

Test safety

The test is absolutely safe. It does not lead to a "fall" of the server (there is no "stress" algorithm) and does not require preliminary measures even on a "combat" server. Confidential data is also not recorded in the test results. Collects information about the parameters of the CPU, RAM, HDD. Serial numbers devices are not assembled. All this can be easily verified - the test code is 100% open. No transfer of information without your knowledge is possible.

How to post test results

If you want to help develop the test, you can run a number of tests on your servers. Then leave the general list of tests done only those that you want to publish and send the dt-upload with the results.

The data will be manually checked (that they are not erroneous), the addressee of the tests is added to the column "author" of the tests and added to the upload, available for download to everyone.

Classification TPC-A-local Throughput/ TPC-1C-GILV-A

The test belongs to the section of universal integral cross-platform tests. Moreover, it is applicable for file and client-server variants of 1C:Enterprise operation. The test works for all DBMS supported by 1C.

Universality allows you to make a generalized assessment of performance without being tied to a specific typical platform configuration.

On the other hand, this means that for accurate calculations of a custom project, the test allows you to make a preliminary assessment before specialized load testing (for example, using 1C: Testcenter).

Note. Test modification " A" means "automatic lock management". After the release of official versions of standard solutions from 1C, it is planned to modify the test to work in the "managed locks" mode and designate it with the letter " M".

Download test

This test is not commercial and is available for free download.

Test results

Top - 3 best 1C client-server installations on MS SQL Server. You too can get into this table. You can see the results in more detail by downloading the test.

Technical details

What happens in the test within the "one" cycle of the operation?

An example of executing sql commands can be found in the attached file.

How to measure the workload of iron

It should be noted that the test itself already partially performs the measurement. For a more detailed picture, I recommend using Mark Rusinovich's Process Explorer utility.

The figure shows an example of a measurement for the file version.

Contacts for TPC-1C-GILV

http://gilev.ru/1c/ tpc

test results, suggestions for development

and send feedback by e-mail: [email protected]

Go to other materials of the site

TurboConf 5 - expanding the capabilities of the 1C Configurator

ATTENTION!

If you have lost the message input box, click Ctrl-F5 or ctrl-r or the Refresh button in the browser.

Topic not updated long time, and has been marked archived. Adding messages is not possible.
But you can create a new thread and you will definitely get an answer!
Every hour there are more than 2000 Human.

Computers (conditional name) participating in the tests - description (disks are indicated only for the database):

(clarification between servers network 1 Gbit)

1) IT33- desktop on Core i5 4 cores at 2.8 GHz, DDR3 3 GB, one HDD 7200 rpm.

2) REAL- THE MOST POWERFUL as I thought)) 8 Xeon cores at 3 GHz, DDR2 48 GB, RAID10 on SSD

3) REAL2- 8 Xeon cores at 2 GHz, DDR2 22 GB,RAID10 on 10,000 rpm SAS hard drives

Tests were carried out in the 1c configuration from Gilev:

>1)REAL2--->REAL2--->25.64(TCP--SQL)
>2)REAL2--->REAL2--->26.32(SQL--Shared Memory)

>3)REAL2--->REAL2--->25.64(SQL--Shared Memory) + IT33(client) - from client to Servers network=10 Mbit

>4 )REAL2--->REAL2--->24.27(SQL--Shared Memory) + REAL(client) - hmm.. strange 1 Gbit network... why are there less parrots..
>5)REAL2--->REAL2--->37.59(File)

** **** **************************
>1)REAL--->REAL--->8.73(TCP--SQL)

>2)REAL---> Real2--->11.99(TCP--SQL) --- this has already begun to lead me to some thoughts))

>3)REAL--->REAL--->17.48(File)

** **** ******************************

>1)IT33--->IT33--->26.88(TCP--SQL)
>2)IT33--->IT33--->34.72(SQL--Shared Memory)
>3)IT33--->IT33--->59.52(File)

Results:

I watched the test results ... twisted this way and that)) and then it dawned on me (I measured the speed of the RAM),

that on the speed of 1s 8.x (I note that the Test Results are based on SINGLE-USER mode, but also for the client-server version in multi-user work - I think they will also have a considerable share of influence) -

so the speed of 1C is affected by: CPU bus frequency + RAM memory frequency

----> what affects WRITE and READ speeds in RAM. What is the basis of performance 1s 8.x.

Computers that divided the prizes According to the speed of work 1s))

1)IT33--->IT33--->59.52(File)

RAM DDR 3 (Read 11089 Mb / s, Write 7047 Mb / s) ------ as I expected, the difference will be significant with servers

2)REAL2--->REAL2--->37.59(File)
- RAM DDR2 (Read=3474, Write=2068)

3) REAL--->REAL--->17.48(File)
- RAM DDR2 (Read=1737 Mb/s, Write=1042 Mb/s) - as it turned out, the speed is lower than on Real2 - exactly 2 times,

due to the enabled Virtual Cores (Hyper-trading) - we will most likely disable it.

CONCLUSIONS:

The highest speed of 1s 8.x is achieved:

I) for the File option (I'm personally not interested)

A) launching the Client (any) on a computer with a high speed of working with RAM. (e.g. Terminal Server

DB there).

II) for Client-Server variant

1) Fat Clients 1C on "Terminal server" - with +

2) Thin clients 1C- there is not much difference where ... but it is desirable to configure via "HTTP://".
3a) "SQL server" + "Server 1c enterprise"(in Shared Memory mode) - on the same wheelbarrow with The highest speed Write / Read RAM + The highest frequency GHz Processor cores disks

Specifications:

- supportshared memory- appeared on the engine starting from 8.2.17 (ATTENTION in the configuration - the compatibility mode with previous versions engine), Naimed Pipes will be used on previous engines - also showing good results))

- RAID on SSD drives - it is advisable to use RAID10 - for fault tolerance, while taking into account the SCARF for Write:

example RAID10 (4 pcs Write Penalty=2) , Write Speed= 4/2 = 2 disks, No Read Penalty.

You can further increase the reliability and stability SSD speeds- not using the entire disk space.

example (raising the reliability of the Desktop SSD to the level of the Server SSD):

If, for example, an Intel 520 series 120GB SSD, and allocate 81 GB, and leave the rest of the space unallocated -

then about 32% of the SSD space will be allocated for over provisioning in addition to the already hidden 8%. In total we get about 40%

The difference between the Intel 710 series server SSD and the Intel 320 series desktop SSD is precisely the difference in over provisioning: more than 40% for the Intel 710 and 8% for the Intel 320.

If there are many 1C clients from 100 onwards:

1) On current technologies Ethernet networks -IT IS NOT SUITABLE to enter "SQL" "Server 1C".

for example, due to Latency (delays) in the Gigabit network Ethernet - real exchange rate with SQL= 30 MB/s - which is not enough even for intensive work with the Database of the 1st user.

2) Because actually "Server 1s"="Object DBMS" (multidimensional objects), and "SQL"= "Relational DBMS"(flat-table data storage)

=> the FLAT projection of the 1C Objects is stored in the SQL database and the 1C Server collects the Object from this projection, then works with this Object, and finally, upon completion of the work, lays it out again in a flat view, saving it in SQL.

That as a consequence between "SQL" "Server 1C" - and you have to refuse to split into two physical servers. But you can use the full implementation of NUMA nodes. ( This should be supported by the OS and the processors themselves).

3b) We distribute the SQL server and Server 1c separately: On current Ethernet technologies - e.g. Gigabit - NOT ESSENTIAL
-SQL to server with The highest speed Write / Read RAM + The highest frequency GHz Processor cores
-Several PHYSICAL servers in Cluster 1s c The highest speed Write / Read RAM + The highest frequency GHz Processor cores+ it is desirable to use RAID on SSD- disks

Products for accounting and management accounting of 1C company are most common in the territory of the Russian Federation. Thousands of companies conduct their business based on standard and specialized 1C configurations. With such massive use, a number of questions regularly arise about optimizing the budget for software and the reasonable use of resources. The controversy around server parts this complex, in particular - on which operating system to base the 1C server and which DBMS to entrust the processing of 1C databases. During our tests, we will try to answer these questions.

Test participants

MS Server operating system and MS SQL DBMS

• The 1C company openly positions this bundle as the main working model, respectively, 1C products are created primarily for it.
• Presence of the protocol of direct high-speed exchange of information SharedMemory
• There is an official technical support and service contracts
• There is a knowledge base and tons of information on installation and fine tuning 1C+MS SQL

Unix operating system and PostgreSQL DBMS

• The system is completely free (except for the license for the 1C:Enterprise server)
• There is a possibility flexible settings set of parameters that improve the performance of the DBMS
• Declared support for PostgreSQL DBMS by 1C products
• Possibility of database replication

Of course, the cost of the project, fault tolerance and technical support are important criteria when choosing an information system for 1C. However, there is a factor that in most cases dramatically affects the decision-making - this is speed.

Since there is simply a great amount of technical literature on these two systems on the Internet, one could argue for a long time about long comparative tables, which, depending on the goals, emphasize the benefits of a particular product. You can discuss this or that parameter among hundreds of others of the same kind - how unique it is in its kind and how it affects the achievement of the result. But theory without practice is dead - we propose to omit the theory in this article and go directly to the facts in order to test the performance of both information systems in practice with a certain level of recommended settings and in various server architecture options (see Table 2).

Test Methods

In our tests, we will rely on two methods of synthetic load generation and imitation of user work in 1C. This is the Gilev test (TPC-1C) and a special test 1C "Test Center" from the 1C: KIP toolkit with special user scenarios.

Gilev test (TPC-1C)

Gilev test belongs to the section of universal cross-platform load tests. It can be used for both file and client-server 1C:Enterprise architecture. The test measures the amount of work per unit of time in one thread and is suitable for assessing the speed of single-threaded workloads, including the speed of drawing the interface, the impact of resource costs, reposting documents, month-end procedures, payroll, etc. Universality allows you to make a summary assessment of performance without being tied to a single platform configuration. The result of the test is a total assessment of the measured 1C system, expressed in conventional units.

A specialized test from the Test Center toolkit 1C: KIP

Test center- a tool for multi-user load testing of systems based on 1C: Enterprise 8 (see Figure 1). With its help, you can simulate the work of the company without the participation of real users, which allows you to evaluate the applicability, performance and scalability of the information system in real conditions. The system is a configuration that provides a mechanism for managing the testing process. To test an infobase, it is necessary to integrate the Test Center configuration into the configuration of the tested database by comparing and merging configurations. As a result of the merging, objects and common modules necessary for the operation of the Test Center will be added to the metadata of the database under test.

Figure 1 - Scheme of work "Test Center" 1C: instrumentation

Thus, using the 1C: instrumentation toolkit, based on the available data in real 1C production bases, the programmer generates a full-fledged automatic testing scenario based on a list of documents and reference books that are key to of this type configuration (application for spending funds, order to a supplier, sale of goods and services, etc.). When you run the scenario, the Test Center will automatically play the multi-user activity described in the scenario. To do this, the Test Center will create the required number of virtual users (in accordance with the list of roles) and start the execution of actions.

Test Options

When setting up test scripts to faithfully simulate simultaneous operation a large number users are given certain testing parameters for each type of document (see table 1):

• Document - indicates a specific document in the working database, on the basis of which load testing will be performed
• Run priority - forms the order in which tests are run for each type of document
• Number of documents - determines the volume of generated test documents
• Pause, seconds - delay when starting a series of tests within the same document type
• The number of lines in the document is an information pointer that reports the “massiveness” of the test document, which affects the processing time and the load on resources

Tests are performed in 3 iterations, the results are recorded in a table. Thus, the obtained test results, measured in seconds, most realistically and objectively reflect the level of performance of 1C bases in conditions as close as possible to real ones (see Tables 3.1 and 3.2).

Table 1. Test script parameters

Table 2. Specifications test stand

Table 3.1 Test results with Gilev's test (TPC-1C). The highest value is considered optimal.

Table 3.2 Test results using a special test 1C: KIP. The smallest value is considered optimal.

1. In a special test 1C, the operations of "reading data and complex calculations", such as "Turnover balance sheet" and "Calculation of cost estimates" are several times faster on the MS SQL DBMS from Microsoft.
2. During the operations of "recording data and posting documents" in most tests best result shows the PostgreSQL DBMS optimized for 1C.
3. Gilev's synthetic test also shows the advantage of PostgreSQL. This fact is connected with the fact that the synthetic test is based on measuring the speed of creating and posting certain types of documents, which is also considered to be the operations of “data recording and document posting”.

Let's finish with cross-platform comparison, let's move on to comparisons within each system:

1. As expected, 1C tests on a hardware platform show better results than on a virtual one. The difference in the results of the special 1C test in both cases is small, which indicates the gradual optimization of virtual hypervisor manufacturers.
2. It is also expected that the use of shared memory technology (SharedMemory) speeds up the process of data exchange between the 1C server and the DBMS. Accordingly, the test results are slightly better than those of the scheme with network interaction of these two services via the TCP-IP protocol.

We can conclude that with the correct setting of 1C and DBMS, you can achieve significant results even on free software. Therefore, when designing a new IT structure for 1C, it is necessary to take into account the level of load on the system, the type of prevailing operations in the database, the available budget, the presence of a specialist in non-standard DBMS, the need for integration with external services, etc. Based on these data, it is already possible to select the required solution.

Read on for testing.

background

A mandatory operation for any implementation or modification of an existing information system is to assess the required speed of the system and plan the necessary computing resources for its implementation. At present, there is no exact solution to this problem in a general form, and if, despite
its complexity and cost, such an algorithm will be proposed by some manufacturer, then even small changes in hardware, software version, system configuration, or the number or standard behavior of users will lead to significant errors.
However, there are plenty of ways. All of these methods can be used in the selection process, but the consumer must understand their scope and limitations.

Most of the existing performance evaluation methods are based on
or some other type of testing.

There are two main types of testing:
component and integral.

Component testing is carried out
testing of individual components of the solution, starting from performance
processors or storage subsystems before testing
performance of the server as a whole, but without the payload in the form of one or another
business applications.

The integral approach is characterized by the assessment
performance of the solution as a whole, both its software and hardware parts.
In this case, it can be used as a business application that will be used
in the final solution, as well as some model applications that emulate
some standard business processes and workloads.

Tests TPC and other universal tests allow you to choose the most promising platforms and compare offers from different manufacturers, but they are only reference information that does not take into account the specifics of your business. Specialized tests allow you to more accurately select a specific server model and its configuration. However, the most informed decisions are made only on the basis of the results of load tests. Only they allow you to optimally configure the selected
server platform and tune it for maximum performance.

What's happened TPC-1C-GILV

This is a series of independent tests designed to evaluate the performance of the 1C:Enterprise 8.1 platform on your computer(s).

Of course, an "independent" test means that it is not sponsored by 1C.

Test is currently available TPC-A-local Throughput/ TPC-1C-GILV-A" (last updated August 2008 version 1.0.3)

test idea TPC-A-local Throughput/ TPC-1C-GILV-A

You download the configuration upload file (~400 Kb) from this site and upload it to your site. If you deploy the configuration in the file version, then to a large extent the test will test the "CPU of your computer - HDD where the base is located" link.

If you expand the configuration into a client-server variant, then the CPU of the application server - the CPU of the server of the subd - of the server of the subd will be mainly subjected to the load.

The test intensively writes 5,000 documents. There is no deep meaning in the business logic of the code, it is simply the performance of the document X conditionally chosen as the standard that is evaluated.

The main beauty of the test is that you do not need to know the technical details. The test is self-executing and gives a score. In addition, the result to whom you do not have to tell you is also not necessary :)

You can compare the performance of several servers, or one server with different disk subsystem characteristics.

By performing a test from the application server and from the client over the network, you can understand the impact of the network from the client to the server.

How to run a test

Running a test is very easy. Gotta push the button

and wait until the test indicator (to the right of the button) reaches 100%.

The test usually takes about 8 minutes.

What do test results mean

The test result is presented as the "write rate" of the test data. The error of the test is 2 units. For an accurate assessment, you can repeat the test 3 times.

After the test indicator reaches 100%, you will see graphs like this:

Below the graphs are some previous similar tests.

The color of the graph hints at the current quality of the "total" performance for work without taking into account locks.

The green color of the graph in combination with some indicators conditionally chosen for the standards on the right allows us to make a cross-platform generalized assessment of "good" performance :)

How to enjoy test results

As a result, you received a certain performance index (consider speed). It doesn't matter if the result is good or bad - this is the result of the PLATFORM on your hardware. In cases of the client-server version, this is the result. You get the overall actual result, which is determined by the BOTTOM POINT in the system. THE BOTTLE PLACE IS ALWAYS!

In other words, both DBMS settings, OS settings, and equipment affect the overall team result :)

Which server is better

This test, performed on a specific server, gives a result on a combination of hardware settings, operating system, subd, etc. However, a high score on a particular server hardware means that, under normal conditions, the same result will be on identical server hardware. This test is a free help in the ability to compare the installation of 1C:Enterprise under Windows and Linux, three different DBMS supported by the 1C:Enterprise 8.1 platform.

Test safety

The test is absolutely safe. It does not lead to a "fall" of the server (there is no "stress" algorithm) and does not require preliminary measures even on a "combat" server. Confidential data is also not recorded in the test results. Collects information about the parameters of the CPU, RAM, HDD. Device serial numbers are not collected. All this can be easily verified - the test code is 100% open. No transfer of information without your knowledge is possible.

How to post test results

If you want to help develop the test, you can run a number of tests on your servers. Then leave the general list of tests done only those that you want to publish and send the dt-upload with the results.

The data will be manually checked (that they are not erroneous), the addressee of the tests is added to the column "author" of the tests and added to the upload, available for download to everyone.

Classification TPC-A-local Throughput/ TPC-1C-GILV-A

The test belongs to the section of universal integral cross-platform tests. Moreover, it is applicable for file and client-server variants of 1C:Enterprise operation. The test works for all DBMS supported by 1C.

Universality allows you to make a generalized assessment of performance without being tied to a specific typical platform configuration.

On the other hand, this means that for accurate calculations of a custom project, the test allows you to make a preliminary assessment before specialized load testing (for example, using 1C: Testcenter).

Note. Test modification " A" means "automatic lock management". After the release of official versions of standard solutions from 1C, it is planned to modify the test to work in the "managed locks" mode and designate it with the letter " M".

Download test

This test is not commercial and.

Test results

Top - 3 best 1C client-server installations on MS SQL Server. You too can get into this table. You can see the results in more detail by downloading the test.

Technical details

What happens in the test within the "one" cycle of the operation?

How to measure the workload of iron

It should be noted that the test itself already partially performs the measurement. For a more detailed picture, I recommend using Mark Rusinovich's utility.

The figure shows an example of a measurement for the file version.

Contacts for TPC-1C-GILV

http://site/1c/ tpc

test results, suggestions for development

Every support specialist has experience in receiving abstract complaints from users. Everyone is familiar with the wording: “she thinks for a very long time”, “I have a red window”, “the system works somehow wrong”, and also “this has not happened for a long time, and here it is again”.

In such a situation, it is very difficult to immediately figure out where the error lies and what to do in the first place. In this article, we will consider what the performance of 1C depends on, i.e. high-load systems created on the basis of 1C:Enterprise, in situations where the symptoms are not fully understood and it is impossible to make a specific diagnosis.

The main reasons affecting the performance of 1C

In more than 60% of cases, the reasons for poor performance are:

• suboptimal queries and programming code configurations (26% of cases);
• Suboptimal indexing of object tables (19% of cases);
• Suboptimal load on the disk subsystem (16% of cases).

Leading Microsoft developers are in solidarity with this.

Thus, to get a significant improvement in the performance of a database application, it is possible to optimize the area of ​​​​data access, including the logical and physical design of databases (as far as possible in 1C), as well as by creating the right queries and using optimal indexing. Part of the database performance problems can be solved by increasing the hardware capacity, but not always: bad design applied solution cannot be compensated by a more powerful server. It is not uncommon that, without understanding the causes of a performance problem, user companies go to great expense by purchasing new equipment, and the problem remains unresolved.

High-quality diagnostics of 1C performance using the entire range of existing tools is the key to successful problem solving and cost optimization

The first step to identifying and fixing poor performance problems should be to write complete list key problematic operations, indicating the exact speed of their execution at the moment and the expected speed of their execution in the future.

Example:

Incorrect: The program freezes while generating a report. I want it to build faster.

Right: The formation of the report "Debt Statement" takes 5 minutes 10 seconds. The expected speed of generating this report is no more than 20 seconds.

After the list of problems is compiled and digitized, it is necessary to analyze the causes, starting with the search for problematic code, if any (for example, “heavy” requests, long waits on locks, deadlocks, etc.).

Tools for identifying problematic code

• 1C:Performance Management Center (a module included in the 1C:Corporate toolkit manufactured by 1C);
• cloud services Gilev;
• Regular tools built into the DBMS of leading vendors.

The effectiveness of the use of these tools is guaranteed by the qualification of the developer "1C: Technological Expert", which implies his participation in large-scale implementations of 1C. At the same time, different experts, based on their individual experience, may give preference to one or another tool/method.

In parallel with the use of one of the presented tools, standard equipment load monitoring tools are also used (“Performance monitors” counters).

Based on the measurements obtained, the class of the cause is revealed:

• The problem is in the code;
• And / or a problem in the hardware;
• The problem is in other resource-intensive programs used on production servers.

Load testing 1C - a methodology for evaluating server hardware

As already mentioned, among the factors that can affect the performance of 1C, both positively and negatively, server hardware and its configuration occupy an important place. Consider the options for measuring, assessing the load and testing the system performance in the following conditions:

• Server 1C is available and located:
• Together with DBMS;
• On a separate server.

To assess the conformity of the parameters of the existing server hardware system requirements, it is necessary to collect data on the load on the hardware, including the processor, i.e. load testing 1C. For this, "Performance Monitor" is used - a tool that allows you to measure equipment on the working circuit and remove performance counters.

Below is basic set counters that need to be configured to monitor hardware performance in Windows. The collection is made from all servers where 1C servers are installed.

If the processor percentage counter for the "Processor" view is high, you should identify processes that can be stopped without affecting the operation of the server, and also transferred to other servers.

The "Process" view will allow you to set up monitoring for each individual process, as well as determine which of the processes take the most CPU time. If only the 1C server is installed on the server, then in order to understand what load it gives to the hardware, you need to configure the collection of the following counters:

If the current system is in an unsatisfactory state, then on the basis of the collected measurements, using a linear relationship, it is necessary to calculate the parameters of the equipment for installing the target system.

If acquisition of server hardware is only planned, its parameters can be calculated by emulating the operation of the planned system, but on a smaller scale, on the existing equipment. For this, "1C: Test Center" is used, which is included in the 1C Corporate Toolkit. Based on the measurements obtained, using the calculation methods, the parameters of the planned system and, accordingly, the requirements for the equipment are determined. This test can be used repeatedly for different measurements, after adding and expanding the functionality. This technique has high precision and ease of calculation.