![]() ![]() The way most database performance tools work is by collecting a small amount of data at fixed intervals and moving that data into a data store. Many tools will even reduce data collection as load increases (or allow for some data to be lost). The basic idea of monitoring the performance of any type of computer system is to minimize resource consumption while doing the monitoring, which is called "observer overhead." Tools are designed with this in mind. However, Activity Monitor can consume a lot of server resources, particularly if it runs on SQL Server Management Studio on your database server. Activity Monitor is a tool inside Microsoft's SQL Server Management Studio that may seem innocuous. ![]() One thing I have noticed in a number of recent consultations is the use of Activity Monitor for troubleshooting performance issues on a server. No one calls us when everything is running well. I get to work with a lot of customers, so I get to see a lot of SQL Servers - and a lot of SQL Server performance problems. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |