performance bottleneck  
Author Message
danceswithbikers





PostPosted: Thu May 31 12:22:25 CDT 2007 Top

SQL Server >> performance bottleneck

I am looking at the performance of one of our production servers and have
done Perfmon. I am seeing a definite bottleneck on the following drives

I, L, H and J

What do you thing and is there anything else I am missing here.

Thanks for your help.



PhysicalDisk
E
T
O
I
L
H
J

% Disk Time
0.693
56.483
1.917
379.04
326.234
470.186
149.234

Avg.Disk Queue Length
0.007
0.565
0.019
3.79
3.262
4.702
1.492

Current Disk Queue Length
0.01
0.181
0.014
27.186
2.664
3.443
2.935

Disk Writes/sec
1.234
112.324
22.064
5.734
5.535
8.989
4.184

SQL Server185  
 
 
TheSQLGuru





PostPosted: Thu May 31 12:22:25 CDT 2007 Top

SQL Server >> performance bottleneck 1) how does a % Disk Time counter get to be over 100? :-)

2) I don't think we have enough information to help you. What is the
capabilities and number of spindles of each drive system? What was CPU
utilization? Memory situation and usage? Were things running 'slowly'??

--
TheSQLGuru
President
Indicium Resources, Inc.



>I am looking at the performance of one of our production servers and have
>done Perfmon. I am seeing a definite bottleneck on the following drives
>
> I, L, H and J
>
> What do you thing and is there anything else I am missing here.
>
> Thanks for your help.
>
>
>
> PhysicalDisk
> E
> T
> O
> I
> L
> H
> J
>
> % Disk Time
> 0.693
> 56.483
> 1.917
> 379.04
> 326.234
> 470.186
> 149.234
>
> Avg.Disk Queue Length
> 0.007
> 0.565
> 0.019
> 3.79
> 3.262
> 4.702
> 1.492
>
> Current Disk Queue Length
> 0.01
> 0.181
> 0.014
> 27.186
> 2.664
> 3.443
> 2.935
>
> Disk Writes/sec
> 1.234
> 112.324
> 22.064
> 5.734
> 5.535
> 8.989
> 4.184
>
>
>


 
 
mrdenny





PostPosted: Thu May 31 14:00:01 CDT 2007 Top

SQL Server >> performance bottleneck These numbers don't seem all that out of line. The queueing on the I drive
is a little high, but without knowing how many spindles are behind the I
drive and what else those spindles are doing I can't say for sure.

What is the Avg Disk Sec/Write number for that drive?
--
Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration /
Microsoft Office SharePoint Server 2007: Configuration)
MCITP (dbadmin, dbdev)




> 1) how does a % Disk Time counter get to be over 100? :-)
>
> 2) I don't think we have enough information to help you. What is the
> capabilities and number of spindles of each drive system? What was CPU
> utilization? Memory situation and usage? Were things running 'slowly'??
>
> --
> TheSQLGuru
> President
> Indicium Resources, Inc.
>


> >I am looking at the performance of one of our production servers and have
> >done Perfmon. I am seeing a definite bottleneck on the following drives
> >
> > I, L, H and J
> >
> > What do you thing and is there anything else I am missing here.
> >
> > Thanks for your help.
> >
> >
> >
> > PhysicalDisk
> > E
> > T
> > O
> > I
> > L
> > H
> > J
> >
> > % Disk Time
> > 0.693
> > 56.483
> > 1.917
> > 379.04
> > 326.234
> > 470.186
> > 149.234
> >
> > Avg.Disk Queue Length
> > 0.007
> > 0.565
> > 0.019
> > 3.79
> > 3.262
> > 4.702
> > 1.492
> >
> > Current Disk Queue Length
> > 0.01
> > 0.181
> > 0.014
> > 27.186
> > 2.664
> > 3.443
> > 2.935
> >
> > Disk Writes/sec
> > 1.234
> > 112.324
> > 22.064
> > 5.734
> > 5.535
> > 8.989
> > 4.184
> >
> >
> >
>
>
>
 
 
jbellnewsposts





PostPosted: Fri Jun 01 02:31:01 CDT 2007 Top

SQL Server >> performance bottleneck Hi



> I am looking at the performance of one of our production servers and have
> done Perfmon. I am seeing a definite bottleneck on the following drives
>
> I, L, H and J
>
> What do you thing and is there anything else I am missing here.
>
> Thanks for your help.
>
>
>
> PhysicalDisk
> E
> T
> O
> I
> L
> H
> J
>
> % Disk Time
> 0.693
> 56.483
> 1.917
> 379.04
> 326.234
> 470.186
> 149.234
>
> Avg.Disk Queue Length
> 0.007
> 0.565
> 0.019
> 3.79
> 3.262
> 4.702
> 1.492
>
> Current Disk Queue Length
> 0.01
> 0.181
> 0.014
> 27.186
> 2.664
> 3.443
> 2.935
>
> Disk Writes/sec
> 1.234
> 112.324
> 22.064
> 5.734
> 5.535
> 8.989
> 4.184
>
You may want to look at some previous posts such as
http://tinyurl.com/2ysoya which point you to resource that tell you about
what you should be monitoring and what values you can expect.

Also check out the articles such as
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx which
will still be relivant to SQL 2000, http://support.microsoft.com/kb/319942/
and
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc

John