Share This Post

Sysadmin newbie: Server & Application Monitoring Terms Decoded

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!

Share This Post

A community professional, keynoter, and evangelist who has driven social media and marketing strategies, editorial successes, delivered customer successes and built some of the largest and longest-running online communities. Rod has created, managed and grown small, medium, and mega-sized conferences; run entire editorial teams to deliver record traffic and market leadership; as product manager, directed the success of hundreds of product releases; supported sales and marketing to ensure customer success; developed, run and sold businesses; written thousands of technical articles, white papers, case studies, and technical documentation; hosted and delivered hundreds of attendance shattering webinars and virtual tradeshows; and delivered keynote speeches and sessions at a wide variety of events including conferences, webinars, events, and user groups.

Leave a Reply