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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-11-19 : 08:11:34
|
| I have IIS and SQL 2000 running on the same server.I'd like to keep an eye on when traffic may be pushing the server to it's limit.What are the best tools to watch CPU load, memory and otherwise track resource usage?Sam |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-19 : 08:12:15
|
| Performance Monitor. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-11-19 : 08:42:42
|
| OK. If PM shows the CPU pegging at 100% for a couple of seconds, is that a concern and what would be the next step? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-19 : 12:23:21
|
| For a couple of seconds, no that is not a concern. When you see peaks and valleys in the graph for PM, then you are usually ok. It is when it stays flatline above say 80% that you could have a problem. There are other CPU counters that you should check to see if you are a CPU bottleneck. Head over to sql-server-performance.com to see what counters are suggested. That site has some excellent information. It lets you know what the threshold values should be.Tara |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-11-19 : 12:59:30
|
| Has anybody ever had to repair performance counters. The sql ones were missing. So I reloaded them, now the regular server ones are all fuct.I smell blue screen!!!!Tenacious O |
|
|
|
|
|
|
Performance Monitoring