Re: read queue extremely high SQL Server 2005

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


.

Relevant Pages

  • Re: Connection to SS 2000 failing
    ... sort needs to spill to disk c) a hash needs to spill to disk, ... Some other processes is hogging your system, and the posting of the ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.connect)
  • How to read a table record by record and process and update another table
    ... there is a problem is posting back to the newsgroup I have to ... Albert first of all many thanks for your help I admit your posting ... and surprised that Access queries cannot even accomodate multiple SQL ... I was after similar to opening a cursor against a SQL query and keep ...
    (microsoft.public.access.queries)
  • How to read a table record by record and process and update another table
    ... there is a problem is posting back to the newsgroup I have to ... Albert first of all many thanks for your help I admit your posting ... and surprised that Access queries cannot even accomodate multiple SQL ... I was after similar to opening a cursor against a SQL query and keep ...
    (microsoft.public.access.macros)
  • Re: Microfocus & Oracle data types
    ... Thanks, Robert. ... SQL is fairly new to me ... ... > Top posting ... > Hello Michael ...
    (comp.lang.cobol)
  • Re: Select question
    ... Posting CREATE TABLEs, INSERTs for sample data and expected ... do have in common: SQL. ... >but if table is derived you can't create the same query ... still find SQL Server's optimizer producing odd-looking plans. ...
    (microsoft.public.sqlserver.programming)