SQL Server Database - EcoSys - Help - Hexagon PPM

EcoSys Performance Tuning

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
9.0

Regular SQL Server Maintenance

Update Statistics for EcoSys Schema Objects

Analyze statistics during off-peak hours on a weekly basis or after a bulk insert or delete. Start the SQL Server Agent, and then create a task to update statistics for the FMUSER objects.

TempDB Optimization

The tempdb database is used as a scratch area for hashes and sorts. Reducing I/O latency for such operations may be beneficial.

The number of tempdb files should match the number of processor cores on the database server.

Configure the file system for database log and data files as RAID 10. Latency should be < 10ms.

Memory/CPU

Set MAXDOP to the number of physical cores. Memory allocated to SQL Server should be set to 80% of the memory allocated to the server. The default setting for both parameters is unlimited, which may cause deadlocking.