We all know the basics of server monitoring –cpu, memory, I/O, and so on. Once you get a good handle on server performance monitoring, no doubt you will be tasked with managing other aspects of the infrastructure like the Exchange, Active Directory, SQL, etc. What does it mean to keep tabs on SQL? What should you be watching for, and what does a high number or low number mean?? Is it good or bad?
You don’t need to wonder anymore. SolarWinds has done a ton of work researching what should be monitored for 100s of applications, and has put the explanation of each metric with goodness/badness defined. And it’s all available on-line, and FREE. You don’t even have to sign up for anything!
Just go to this page, and click on the test drive demo link.
Then, click on any application you need to learn about. Here, I clicked on SQL and opened the metrics list of what we can monitor on SQL.
Next, I click on fragmentation % – I have an idea what that is, but I am not sure why it occurs or what an acceptable percentage is. I scroll down to Component Settings and I see the definition.
This data is available for 100s of applications that have dozens of metrics defined. Check it out!