hot spots

17 May 2005 8:05 PM

Mark J. McGinty

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

17 May 2005 8:07 PM

Hari Prasad

Hi,

See the performance monitor counters

http://www.sql-server-performance.com/performance_monitor_counters_io.asp

Thanks
Hari
SQL Server MVP

Show quoteHide quote

"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
>

17 May 2005 8:49 PM

Mark J. McGinty

"Hari Prasad" <hari_prasa***@hotmail.com> wrote in message
news:eLX3TvxWFHA.616@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> See the performance monitor counters
>
> http://www.sql-server-performance.com/performance_monitor_counters_io.asp

Wow that was fast! :-) Very interesting article, thanks!

-Mark

Show quoteHide quote

> 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
>>
>
>

17 May 2005 8:25 PM

Sameer Premji via SQLMonster.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.sqlmonster.com

17 May 2005 8:48 PM

Mark J. McGinty

"Sameer Premji via SQLMonster.com" <fo***@SQLMonster.com> wrote in message
news:8dcfe4c84c2a420c92d85c5923b07a61@SQLMonster.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.sqlmonster.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