SQL Server Monitoring - Important SQL Server Monitroing Counters

Who is online?  87 guests and 0 members
home  »  blogs  »  Ritesh Medhe  »  SQL Server Monitoring - Important SQL Server Monitroing Counters
  Rate This Blog Entry:  register  or  login


riteshmedhe Ritesh Medhe (Member since: 3/31/2011 11:34:25 AM)
Ritesh Medhe is a Microsoft Certified DBA & a BI professional with over 8 years of experience. Expertise: Performance optimization & SQL Server Administration

View Ritesh Medhe 's profile

Comments (3)

3/2/2012 7:30:56 AM calin said:

At least for SQL Server - database engine, a bit misleading and incomplete. Better check the free list from PAL, perhaps? As a great starting point?

3/8/2012 6:15:38 AM Alex said:

Completely agree with calin, the list is misleading and incomplete. For example:

Buffer Cache Hit Ratio - Doesn't show you if there is enough memory at all.

Page Splits/sec - you cannot get too much info from this one, because it count creating new pages as splits too.

Robert L Davis
3/11/2012 7:53:32 PM Robert L Davis said:

Agree with the others. Take for example the counter SQLAgent:Jobs-Failed Jobs. It lists that it is pattern based. When would any value greater than 0 be acceptable for this counter? And a much better counter for determining if you have enough memory is Page Life Expectancy. This tells you how frequently pages are getting aged out of cache. Though I really prefer to poll the DMVs to get the pattern of memory grants pending.


Leave a comment

Email:  (your email is kept secure)

example: "http://www.SQLServerGeeks.com"

Type the characters:

SQLServerGeeks FaceBook group

SQLServerGeeks Events

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Ritesh Medhe's latest blog posts

  • We have heard people talking about big data especially DWH folks. Do we really know the definition of BIG Data? Majority of us would attribute big data solely to the size of data. Well to know the rea...
  • This white paper will navigate you through the process of exposing SSAS cubes over port 80 Prequisites : SSAS server must have IIS installed (if both the servers are different you might need to setup ...
  • It's a known fact that an ideal Production DBA is like a parent to 100's of children. By children I mean database servers, and yes, they are like babies to DBAs. No matter how unpleasant your child is...
  • Hello Guys, We all are aware that monitoring a database server for that matter any server is of prime importance in order to ensure business continuity. I will be talking only from database perspectiv...
  • It often happens that DBA’s/Developers end up creating database objects(mostly tables) during development phase for various reasons like intermediate testing or backup . Such objects often end u...
  • I always say that database sizing is one of the prime tasks and concern for any DBA. As a DBA you should ensure that there is no single record claiming space in the databasefor no reason. DBA's should...
  • It is always a big challenge to maintain application’s performance optimum. Increasing data on regular basis is often the cause for performance degrades. In most of the cases end users report th...
  • Scenario: Database sizing is one of the most critical tasks for any DBA. One of the DBA’s tasks is to also ensure optimum performance. Database/table size is one of the key factors impacting the...
Blogs RSS Feed

Latest community blog posts

  • Hi Friends, In this blog post, let’s have an insight on how Auditing can be done in SSIS packages? The basic auditing in package includes measures like How many rows were inserted, updated or de...
  • Hi SQL Geeks, Here are the blog posts by Piyush Bajaj for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at ht...
  • Hi SQL Geeks, Here are the blog posts by Ahmad Osama for the month of May. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at htt...
  • Hi Friends, Are you facing any issue on SQL Server 2014 while running the same query which is running fine on previous version of SQL Server? If answer is yes then this may be due to the change in SQL...
  • I have written a SQL Server Change Data Capture GUI interface to facilitate for CDC operations. The project is hosted here https://sqlcdcapp.codeplex.com/ . Feel free to download, review and suggest c...
  • Recently I came across an interesting deadlock scenario I wasn’t aware off. I didn’t have idea that foreign key constraint can also result in deadlocks. The detailed steps to replicate the...
  • Hi Friends, In my earlier blog, I just explain about the importance of filtered indexes. Link for that blog is mention below: http://sqlservergeeks.com/blogs/princerastogi/personal/599/filtered-indexe...
  • A few words about the technology of our site. It's easy to take technology for granted, to focus on content and pay no attention to how it is being delivered. Typically we would encourage this focus. ...