read queue extremely high SQL Server 2005

[G. Janssen]

Hi all,

We have a problem with performance of our Microsoft Dynamics SQL Server 2005
box.
It is a HP DL350 with P400 Controller (with battery and 512MB cache on
controller)
on controller 8 disks
2 mirror disks drive c
2 mirror disks drive e (SQL Log)
4 raid 10 disks drive f (SQL Data)

When performing an action in the database (posting invoice) we see the
average read queue on drive f: fot 4 minutes 100%
in that case cpu is 5%, on drive e no action.
We have latest controller firmware (5.20).

Do we have wrong SQL parmeters we could check?

kind regards,
Gerrit

 

[Meinolf Weber]

Re: read queue extremely high SQL Server 2005

Hello G. Janssen G.,

Think you should better post this here:
microsoft.public.sqlserver.server

and there are a lot more NG's about SQL available.

Best regards

Meinolf Weber
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
no rights.
** Please do NOT email, only reply to Newsgroups
** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm


> Hi all,
>
> We have a problem with performance of our Microsoft Dynamics SQL
> Server 2005
> box.
> It is a HP DL350 with P400 Controller (with battery and 512MB cache on
> controller)
> on controller 8 disks
> 2 mirror disks drive c
> 2 mirror disks drive e (SQL Log)
> 4 raid 10 disks drive f (SQL Data)
> When performing an action in the database (posting invoice) we see the
> average read queue on drive f: fot 4 minutes 100%
> in that case cpu is 5%, on drive e no action.
> We have latest controller firmware (5.20).
> Do we have wrong SQL parmeters we could check?
>
> kind regards,
> Gerrit

 

[G. Janssen]

Re: read queue extremely high SQL Server 2005

Thanks, I'll do that!

Kind regards,
Gerrit

"Meinolf Weber" wrote:

> Hello G. Janssen G.,
>
> Think you should better post this here:
> microsoft.public.sqlserver.server
>
> and there are a lot more NG's about SQL available.
>
> Best regards
>
> Meinolf Weber
> Disclaimer: This posting is provided "AS IS" with no warranties, and confers
> no rights.
> ** Please do NOT email, only reply to Newsgroups
> ** HELP us help YOU!!! http://www.blakjak.demon.co.uk/mul_crss.htm
>
>
> > Hi all,
> >
> > We have a problem with performance of our Microsoft Dynamics SQL
> > Server 2005
> > box.
> > It is a HP DL350 with P400 Controller (with battery and 512MB cache on
> > controller)
> > on controller 8 disks
> > 2 mirror disks drive c
> > 2 mirror disks drive e (SQL Log)
> > 4 raid 10 disks drive f (SQL Data)
> > When performing an action in the database (posting invoice) we see the
> > average read queue on drive f: fot 4 minutes 100%
> > in that case cpu is 5%, on drive e no action.
> > We have latest controller firmware (5.20).
> > Do we have wrong SQL parmeters we could check?
> >
> > kind regards,
> > Gerrit
>
>
>