Monitoring SQL server

• coenzyme77

  SSCommitted

  Points: 1669

  More actions

  January 17, 2007 at 3:53 pm

  #69386

  O great SQL  minds, I need to establish a bare bones performance monitor. O, I’ve read what many of the manuals and white papers say, but I’m looking for the “real life” important

  ounters. If you respond please indicate the complete performance object and counters name. i.e. SQL Server:Buffer Manager\AWE lookup maps/sec, makes it so much easier than having to comb thru SQL   AWE. Thanks for everyone for being there to help

  SQL Server 2000 SP4   

   

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 12:13 am

  #683916

  You have to use the permon counters based on your requirements.

  Here is the link for basic counters.. http://www.sqlservercentral.com/columnists/sjones/performancemonitoringbasiccounters.asp

   

  http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

  http://www.microsoft.com/technet/community/chats/trans/sql/sql0513.mspx

  http://www.sql-server-performance.com/sg_sql_server_performance_article.asp

   

  MohammedU
  Microsoft SQL Server MVP

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  January 18, 2007 at 7:20 am

  #683990

  http://sqlblogcasts.com/blogs/grumpyolddba/archive/tags/Trending+and+Statistics/default.aspx

   

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/