Performance problem 1C and MSSQL

Question

ERP

There is 1C Enterprise 8.2, 100 active users, works in conjunction with MSSQL 2012, on two physical servers. In principle, the speed of work suits everyone, but there are several users who perform actions that require a large amount of information from the sampling base, and at the same time the execution speed is extremely critical (procurement planning). Database server configuration: hp dl380g8 (2xXeon E5-2650/128GB RAM/6xSAS 15k rpm). The plans are to switch to FC storage, and purchase a more productive server. As I understand it, a high-performance cluster on MSSQL cannot be done. Tell me, what are the options for increasing the performance of MSSQL?

Answer 1

1. Add the conf so that in free time (at night) the data for heavy reports is prepared by a scheduled task, i.e. the data structure was simplified, calculations were carried out. As a result, a person will receive already generated data. Judging by the description, the report is not just a huge sheet of data, and there is something to optimize there. But 3-5 seconds - I wouldn't bother, your users are spoiled (=
2. If your config does not work in compatibility mode - look at the aggregates, you may gain some time after setting. Does not require configuration.

Answer 2

view performance counters. draw conclusions

Answer 3

The options are:

• Add CPU
• Optimization of purchase plan calculations (views, procedures, indexes)
• Materialized Views
• Secondary tables and precalculation plans

Answer 4

change the procurement planning system to one that will work normally.