if i want to monitor sql server2000

• Papillon

  Hall of Fame

  Points: 3303

  More actions

  July 19, 2005 at 8:19 am

  #165008

  Can any body have idea about minimum and maximum values for the following factors for

  sql server2000 if i want to monitor sql server2000

  Total Memory - KB

  SQL Cache Memory - KB

  Lock Memory - KB

  Optimizer Memory - KB

  Connection Memory - KB

  Granted WorkSpace Memory - KB

  Memory Grants Pending -

  Memory Grants Success -

  Buffer Hit Ratio -

  Page LookUps/Min -

  Page Reads/Min -

  Page Writes/Min -

  Total Pages -

  Database Pages -

  Free Pages -

  Please help me

  T.I.A

  Shashank

  ---

  Regards,

  Papillon

• ramses2nd

  Hall of Fame

  Points: 3720

  More actions

  July 19, 2005 at 9:19 am

  #575523

  Here are some links that I have used in the past. They give some good information on what the counters represent and the threshold they should adhere to.

  <http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=28&rl=1&gt;

  <http://www.windowsitlibrary.com/Content/77/15/3.html&gt;

  <http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/&gt;

  The last one is very helpful as it also has some handy checklists you can use.