Which Measures within Performance Monitor

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Which Measures within Performance Monitor

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-26 : 09:11:52

Simon writes "Hi All

Im using performence monitor on Win2000 with sql 7 on a clustered enviornment. We are running some tests with 40 users accessing the system and I want to monitor the effects on the system.

These are the measures I have selected to use for Performence monitor ;

Memory Pages/Sec
Memory Available Bytes
PhysicalDisk % Disc Time
PhysicalDisk Avg. Disk Queue Length
Processor % Total Processor Time
SQL Server Access Methods Page Splits/sec
SQL Server Access Methods Full Scans/Sec
SQL Server Buffer Manager Buffer Cache Hit Ratio
SQL Server Buffer Manager Cache Size (pages)
SQL Server General Statistics User Connections
SQL Server General Statistics Log In/Sec
SQL Server General Statistics Log Out/Sec
SQL Server Locks Number of Deadlocks/Sec
SQL Server Locks AVG Wait Time (ms)
SQL Server SQL Statistics Batch Requests/Sec
SQL Server SQL Statistics SQL Comilations/Sec

I do have a couple of questions

1.Any other obvious measures I've missed from my selection ?
2. Are there useful correlations I can draw from the above e.g number of user connections and number of deadlocks ?
3. For the following measures which thresholds should I be using e.g > 10 for five minutes is bad /good/indifferent ?!
SQL Server Locks Number of Deadlocks/Sec
SQL Server Locks AVG Wait Time (ms)

Many thanks for any help ..realise this is a bit of a longwinded one !!!"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources