SQL Server Monitoring - Important SQL Server Monitroing Counters

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

Author

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)

calin
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?

by
Alex
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.

by
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.

by

Leave a comment

Name:
  *  
Email:  (your email is kept secure)
 *  
Website:

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 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. ...
  • Hello, Constraints can be defined as rules that govern the values that are inserted into a column. These rules help in enforcing data integrity. For example if a NOT NULL constraint is defined over a ...