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 |
|
mvanwyk
Yak Posting Veteran
99 Posts |
 Posted - 2009-06-29 : 12:07:28
|
| Hi Guys.Can someone point me in the right direction, I’m trying to understand Windows 2003 Server Performance counters.What do i need to look out for with regards to server performance and possible issues.On the following Performance Object.SQL Server.(What indicates a Performance issue/ bottlenecks)Hard Drive.(What indicates a Performance issue/ bottlenecks)CPU.(What indicates a Performance issue/ bottlenecks)Memory.(What indicates a Performance issue/bottlenecks)Any pointer will be appreciated |
|
|
mvanwyk
Yak Posting Veteran
99 Posts |
Posted - 2009-06-29 : 12:42:18
|
| Just to add.I have this so far.% Total Processor Time counter (If over 80% for 10 min's or longer then there might be a problem)Memory Object: Pages/Sec(If over 0 for 10 min's or longer then there might be a problem)PhysicalDisk Object: Avg. Disk Queue Length(if over 2 for 10 min's or longer then there might be a problem)Buffer Manager Object: Buffer Cache Hit Ratio (This should exceed 90%)If anyone can add to this list it would be much appreciated. |
 |
|
|
|
|
|
Off Topic.... Sort Of