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.