Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
techbabu303
Starting Member
1 Post |
 Posted - 2006-12-05 : 05:56:38
|
| Iam new to Sql server 2000 administration , would need inputs on counters to monitor so that I can do regular health check up of the system.Environment:Sql server 2000 SP3windows 2003 sp12GB RAM2GHZ processorTotal size of 23 databases = 7.38GBCounters currently montioring using the task manager on sqlserv.exe :1. Mem Usage I assuume amount of RAM is consuming2. VM size is virtual memory in play3. Page Pool - Not sure what this is ? assuming paging mechnaism in windows 4. NP pool - Not sure on this 5. I/O reads - reads like select to db 6. I/0 writes - insert and update to DB 7. Page File usage - Not sure on this too, please explainAny other counters or freeware tools to use please suggest and also please explain the above counters 3,4,7 in detail please or point me to links if possible.Thx in Advance Sat |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-12-05 : 08:23:58
|
| sql-server-performance.com has some good articles on using perfmon to monitor health. I don't see any CPU data points in your set and I think you are overdoing the RAM monitoring for basic health monitoring.Jayto here knows when |
 |
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-12-06 : 01:44:57
|
| plz go thru these links:http://www.windowsitlibrary.com/Content/77/15/1.htmlhttp://www.sql-server-performance.com/performance_monitor_counters_sql_server.aspits me monty |
|
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-12-06 : 07:22:28
|
| Advice: If there is absolutely no reason why you can't migrate to SQL SP4 then MIGRATE.Service Packs fix errors that make your life easier.RegardsNThe revolution won't be televised! |
|
|
|
|
|
|
Monitoring SQL server