|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Physical Disk bottleneck?I am running SQL 2K enterprise, using RAID 5 with 6 disks. I returned the
following performance counters and was hoping somebody could tell me if there are any signs of disk bottlenecks. The values specified are in the order of Average, Minimum, and Maximum. Physical Disk: % Disk Time 145.839, .576, 400.861 Physical Disk: % Disk Read time 1, 0, 8 Physical Disk: % Disk Write time 70, 0, 456 Physical Disk: Avg. Disk Queue Length 1, 0, 9 Physical Disk: Avg. Disk sec/Transfer 0, 0, 0 Physical Disk: Current Disk Queue Length 4, 0, 208 Physical Disk: Disk Bytes/sec 1269170, 30323, 7073880 Physical Disk: Disk Transfers/sec 77, 5, 257 Robert,
These numbers don't look too bad. Maybe some peaks for things like checkpoints but overall probably OK. I would use fn_virtualfilestats though to see how your disks are doing. -- Andrew J. Kelly SQL MVP "Robert R via SQLMonster.com" <u3288@uwe> wrote in message news:5ae5af3dd79e1@uwe...Show quoteHide quote >I am running SQL 2K enterprise, using RAID 5 with 6 disks. I returned the > following performance counters and was hoping somebody could tell me if > there > are any signs of disk bottlenecks. The values specified are in the order > of > Average, Minimum, and Maximum. > > Physical Disk: % Disk Time 145.839, .576, 400.861 > Physical Disk: % Disk Read time 1, 0, 8 > Physical Disk: % Disk Write time 70, 0, 456 > Physical Disk: Avg. Disk Queue Length 1, 0, 9 > Physical Disk: Avg. Disk sec/Transfer 0, 0, 0 > Physical Disk: Current Disk Queue Length 4, 0, 208 > Physical Disk: Disk Bytes/sec 1269170, 30323, 7073880 > Physical Disk: Disk Transfers/sec 77, 5, 257 > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1 I have never heard of fn_virtualfilestats. Is it described in BOL?
What about Physical Disk: Current Disk Queue Length having an average of 4? Andrew J. Kelly wrote: Show quoteHide quote >Robert, > >These numbers don't look too bad. Maybe some peaks for things like >checkpoints but overall probably OK. I would use fn_virtualfilestats though >to see how your disks are doing. > >>I am running SQL 2K enterprise, using RAID 5 with 6 disks. I returned the >> following performance counters and was hoping somebody could tell me if >[quoted text clipped - 11 lines] >> Physical Disk: Disk Bytes/sec 1269170, 30323, 7073880 >> Physical Disk: Disk Transfers/sec 77, 5, 257 Hi Robert
From: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp Physical Disk: Current Disk Queue Length counter to see how many system requests are waiting for disk access. The number of waiting I/O requests should be sustained at no more than 1.5 to 2 times the number of spindles making up the physical disk. Most disks have one spindle, although redundant array of inexpensive disks (RAID) devices usually have more. A hardware RAID device appears as one physical disk in System Monitor; RAID devices created through software appear as multiple instances. You have 6 spindles. John Show quoteHide quote "Robert R via SQLMonster.com" wrote: > I have never heard of fn_virtualfilestats. Is it described in BOL? > > What about Physical Disk: Current Disk Queue Length having an average of 4? > > Andrew J. Kelly wrote: > >Robert, > > > >These numbers don't look too bad. Maybe some peaks for things like > >checkpoints but overall probably OK. I would use fn_virtualfilestats though > >to see how your disks are doing. > > > >>I am running SQL 2K enterprise, using RAID 5 with 6 disks. I returned the > >> following performance counters and was hoping somebody could tell me if > >[quoted text clipped - 11 lines] > >> Physical Disk: Disk Bytes/sec 1269170, 30323, 7073880 > >> Physical Disk: Disk Transfers/sec 77, 5, 257 > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1 > John answered the one question and as for virtualfilestats I think you can
answer that one on your own<g>. -- Andrew J. Kelly SQL MVP "Robert R via SQLMonster.com" <u3288@uwe> wrote in message news:5aea6812b9cf1@uwe...Show quoteHide quote >I have never heard of fn_virtualfilestats. Is it described in BOL? > > What about Physical Disk: Current Disk Queue Length having an average of > 4? > > Andrew J. Kelly wrote: >>Robert, >> >>These numbers don't look too bad. Maybe some peaks for things like >>checkpoints but overall probably OK. I would use fn_virtualfilestats >>though >>to see how your disks are doing. >> >>>I am running SQL 2K enterprise, using RAID 5 with 6 disks. I returned the >>> following performance counters and was hoping somebody could tell me if >>[quoted text clipped - 11 lines] >>> Physical Disk: Disk Bytes/sec 1269170, 30323, 7073880 >>> Physical Disk: Disk Transfers/sec 77, 5, 257 > > -- > Message posted via SQLMonster.com > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1  
Thread options
|
|||||||||||||||||||||||
