Skip to main content
B
bmehringer1-Visitor
1-Visitor
June 7, 2019
Solved

Utilization Subsystem Performance Issues

  • June 7, 2019
  • 1 reply
  • 1097 views

All - I wanted to share a hard learned lesson when using the Utilization Subsystem to track statistics on the executed services on the platform.  The Utilization Subsystem has 4 settings on its configuration tab, and we had all 4 set to TRUE:

US_Settings.png

We found that when we had the last setting set to TRUE, then our TempDB file for MS SQL Server was growing very quickly (40 - 50GB every 24hrs).  Our server was running out of disk space daily and when we restarted the server, we got all the TempDB space back and everything ran fine for another day.

 

We wrote an app that monitors the TempDB size on our SQL server and you can clearly see when we changed setting "Enable Statistics Persistence" to FALSE and the growth speed of the TempDB database slowed drastically.

US_Chart.png

 

Wanted to share with anyone else using the Utilization Statistics in 8.3 and above.

 

Best answer by posipova

Thank you for sharing this. Please keep in mind, it's never the best practice to run statistics (or deeper level of logs, for example) at all times and should be done when necessary. Depending on the application, it can easily affect performance and consume too much of resources.

1 reply

P
posipova20-TurquoiseAnswer
20-Turquoise
June 17, 2019

Thank you for sharing this. Please keep in mind, it's never the best practice to run statistics (or deeper level of logs, for example) at all times and should be done when necessary. Depending on the application, it can easily affect performance and consume too much of resources.

Terms & ConditionsAccessibility statement