July 19, 2005 at 8:19 am
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
July 19, 2005 at 9:19 am
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>
<http://www.windowsitlibrary.com/Content/77/15/3.html>
<http://www.devarticles.com/c/a/SQL-Server/How-to-Perform-a-SQL-Server-Performance-Audit/>
The last one is very helpful as it also has some handy checklists you can use.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply