Guest G. Janssen Posted September 23, 2008 Posted September 23, 2008 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
Guest Meinolf Weber Posted September 23, 2008 Posted September 23, 2008 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
Guest G. Janssen Posted September 25, 2008 Posted September 25, 2008 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 > > >
Recommended Posts