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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-05-18 : 11:47:52
|
| We are at the very early stages of assessing our SQL Servers to determine if we should move our data to a SAN. EMC would like us to monitor the following perfmon objects.Add all counters and all instances for the following objects:• Physical Disk• Process• Processor• SQLServer:Access Methods• SQLServer:Buffer Manager• SQLServer:Databases• SQLServer:General Statistics• SQLServer:Latches• SQLServer:Locks• SQLServer:Memory Manager• SQLServer:SQL StatisticsThe duration would be every 60 seconds for what appears to be only 2 hours (not nearly long enough in my opinion). Should I be concerned about the load this will place on a server? I typically do not add "ALL" counters and instances for an object when monitoring a server.Also, when monitoring the physical disk counters below is it necessary to divide the results by the number of physical disks in each RAID or are the results useful as is?Physical Disk Average Disk sec/Read Average Disk sec/Write Average Disk Queue Length Disk Reads/sec Disk Writes/sec Disk Transfers/secThanks, Dave |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-05-18 : 12:07:08
|
| I think it is safe to monitor the counters in that way. This is actually pretty common when you are troubleshooting a performance issue. you will definitely want to do a little math with the disk counters you collect also, as you indicated.-ec |
 |
|
|
|
|
|
Perfmon Counters Impacting Server Performance?