October 7, 2009 at 8:24 pm
Dear All,
We Have MSSQL Server 2000 SP4.
My Machine is IBM X3650 M2 with 12 disk @ 300 GB SAS.
8 disk using Raid 5 and the capacity is 1,8 TB, as Array X.
4 disk using Raid 0 and the Capacity is 1,2 TB, as Array Z.
Array X : use for 2 partition that are Drive C and D.
"Drive C" use for WIndows 2003 Server System and MSSql Server and "Drive D" for MSSQL Server Data.
Array Z : Use For MSSQL Server Logs.
My Question are:
1. On performance monitor, "AVg Disk Queue Length" often in high scale.
Can someone help me, why it's can and resolve the problem?
Thank You
October 8, 2009 at 5:36 am
This link should help
http://www.sql-server-performance.com/articles/audit/hardware_bottlenecks_p1.aspx
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply