2012年3月29日星期四

Disk writes/sec value

I picked up the disk writes/sec for a particular physical
disk and noticed it shoot to 2800 at times..
What does that mean ? There are 2800 writes to that array
that may comprise of 6 disks or so..
Jamie,
Check out these for more details on the proper counters:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
But what exactly is it your trying to determine? The best counter(s) to
view for an overall indication of how busy your disks are is the current
(and average) disk queues.
Andrew J. Kelly SQL MVP
"Jamie" <anonymous@.discussions.microsoft.com> wrote in message
news:23a6401c45ecc$d9104d00$a301280a@.phx.gbl...
> I picked up the disk writes/sec for a particular physical
> disk and noticed it shoot to 2800 at times..
> What does that mean ? There are 2800 writes to that array
> that may comprise of 6 disks or so..

没有评论:

发表评论