hot spots

I've read a little about drives having "hot spots" as a performance issue.
Hot would one go about detecting this? I can't think of a direct way to
monitor accesses to a certain physical area of the disk, are there
performance counters from which this condition might logically be inferred?
tia,
Mark McGintyHi,
See the performance monitor counters
http://www.sql-server-performance.c...counters_io.asp
Thanks
Hari
SQL Server MVP
"Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
> I've read a little about drives having "hot spots" as a performance issue.
> Hot would one go about detecting this? I can't think of a direct way to
> monitor accesses to a certain physical area of the disk, are there
> performance counters from which this condition might logically be
> inferred?
> tia,
> Mark McGinty
>|||Not sure if this will help but take a look at this:
http://www.passmark.com/products/diskcheckup.htm
Message posted via http://www.droptable.com|||"Sameer Premji via droptable.com" <forum@.droptable.com> wrote in message
news:8dcfe4c84c2a420c92d85c5923b07a61@.SQ
droptable.com...
> Not sure if this will help but take a look at this:
> http://www.passmark.com/products/diskcheckup.htm
> --
> Message posted via http://www.droptable.com
Interesting tool, thanks! Sadly, its lack of ability to query drives
connected via SCSI or RAID cuts it's usefulness to the bone, as nearly all
of the storage on production machines I see uses either or both of those
interface technologies.
-Mark|||"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eLX3TvxWFHA.616@.TK2MSFTNGP12.phx.gbl...
> Hi,
> See the performance monitor counters
> http://www.sql-server-performance.c...counters_io.asp
Wow that was fast! :-) Very interesting article, thanks!
-Mark

> Thanks
> Hari
> SQL Server MVP
> "Mark J. McGinty" <mmcginty@.spamfromyou.com> wrote in message
> news:O73iDtxWFHA.1384@.TK2MSFTNGP09.phx.gbl...
>