Server Monitoring CPU consumption is higher than expected. What can I do?
1) Check for updates
Please check regularly for updates, as most of them offer performance improvements. We recommend you to apply Server Monitoring updates out of working hours since the update may perform long running background operations on the database.
The latest version of Server Monitoring is always available here: direct link.
2) Apply recommended configuration
A database will always take all computing resources available to complete requests as soon as possible. Therefore, it is recommended to plan the resources for you Server Monitoring server according to its usage.
Please find below our recommendations based on the number of monitored servers:
|Monitored servers||CPU||Memory (RAM)|
Installing Server Monitoring on an SSD type disk drive is recommended for better performance.
Also, you may need to allocate additional disk space for your Server Monitoring Server, depending on the number of servers and websites monitored, and the amount of data collected and stored in the SQL Server database.
Finally, please note that it is generally a good idea to run a monitoring application such as Server Monitoring on a dedicated server. This prevents other applications from reducing available resources.
3) Contact our customer support
If all the above recommendations failed to provide you an acceptable experience with Server Monitoring, please do not hesitate to contact our customer support at https://terminalserviceplus.freshdesk.com. We will be happy to help troubleshoot your Server Monitoring installation.
In order to facilitate our technical support and to reproduce your issue, we might ask you for an export of your database.
To do so, open an elevated command prompt, enter the following command:
sqlcmd -S [Your SQL Server Instance Name] -Q "BACKUP DATABASE [ServerMonitoring] TO DISK = N'ServerMonitoring_Support.bak' WITH NOFORMAT, NOINIT, NAME = 'demodb-full', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
Once the export has finished, please send us the file located at C:\Program Files (x86)\Microsoft SQL Server[YourVersionOfSQLServer]\MSSQL\Backup\ServerMonitoring_Support.bak.