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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2007-02-09 : 00:40:04
|
| Hi Experts,Below are some counters from perfmon. Can anybody tell me what should be the acceptable figures for each count? Memory\Available MBytesMemory\Pages/secNetwork Interface(Broadcom NetXtreme Gigabit Ethernet)\Bytes Total/secPaging File(\??\D:\pagefile.sys)\% UsagePhysicalDisk(2 H:)\Avg. Disk Queue LengthPhysicalDisk(2 H:)\Disk Reads/secPhysicalDisk(2 H:)\Disk Writes/secPhysicalDisk(5 F:)\Avg. Disk Queue LengthPhysicalDisk(5 F:)\Disk Reads/secPhysicalDisk(5 F:)\Disk Writes/secProcessor(_Total)\% Processor TimeSQLServer:Access Methods\Full Scans/secSQLServer:Buffer Manager\Buffer cache hit ratioSQLServer:Databases(_Total)\Transactions/secSQLServer:General Statistics\User ConnectionsSQLServer:Locks(_Total)\Average Wait Time (ms)SQLServer:Locks(_Total)\Number of Deadlocks/secSystem\Context Switches/secSystem\Processor Queue LengthThanksSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
MohammedU
Posting Yak Master
145 Posts |
|
|
|
|
|
Perfmon Counters