Home > Archive > MS SQL Server > December 2006 > Re: SQL Server slow after RAM upgrade - Average Disk Queue









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: SQL Server slow after RAM upgrade - Average Disk Queue
Paul Johnston

2006-12-04, 5:15 am

Hi all,

Many thanks for your replies. You are correct memory is not the real
issue. It could be that we have i/o bottleneck elsewhere.

According to the performance monitor our average disk queue length is
at max most of the time. I have no idea what this means. Could
someone please explain the significance, if any, of this performance
counter.

Thanks

Paul.

Gina Auer wrote:[color=darkred
]
> You most likely have checked this already - but here is some
> interesting information:
>
> http://technet2.microsoft.com/Windo...3.mspx?mfr=true
>
> Usually, you should set the size of your paging file at two or
> two-and-a-half times the amount of installed physical memory if
> applications such as Microsoft SQL Server or Microsoft Exchange Server
> are present. If you set the same value for the minimum and maximum size
> of your paging file, the amount of disk defragmentation is reduced.
>
> John Bell wrote:

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com