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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy