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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-02 : 07:33:07
|
| Olutimi writes "I run a SQL 2K SP 3 on WIN 2K ADV SP4. I would like to know what counters to monitor to determine how busy the database and server are.Thanks for your kind help." |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-02-02 : 14:02:48
|
| Do some reading on http://www.sql-server-performance.com . They have several articles on this exact thing.Off teh top of my head you want to look at Disk queue length, User connections, Pages / second, CPU utilization. Remember, with SQL server the most important things in order are Disk, RAM, and CPU.<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
|
|
|
Database & Server Utilization