sql server efficient

Hi

I have some trouble with efficient of my MSSQL 2000, SP4. Server reads about 10-80 MB per secound from phisical disk (average about 20MB), but transfer into LAN only about 50-500 KB per secound (average 150 KB). It starts about 2-3 month ago and incrise, it means 3 monts ago server read about 2-3MB per secound, 2 month ago 5MB per secount and so on. Reads is so big, that raid now can't answer to sql, and users need to wait for result of simple query

I have stoped all jobs and main application, and generally nothing has chenged (transfer and read was minimally slower). So I think I have:
- unoptimal small aplication or raport or enduser which generate in QA such big reads,
- or some cache buffer which is filling by server without sense
- or some rootkit with job "to make trouble"

How to find what is going on?

Marek

.

Relevant Pages

  • Re: sbs 2003 r2 keep restarting need advice
    ... i just dont know if to use the Small Business Server 2003 R2 Transition ... Pack or installed windows server 2003 on the secound SERVER ... having a secound dfs server installed for faultolarence porpeses ...
    (microsoft.public.windows.server.sbs)
  • Re: sbs 2003 r2 keep restarting need advice
    ... Yes, you can have additional DCs, but you cannot have a 2nd SBS. ... Any additional server in an SBS AD must use nonSBS media. ... Pack or installed windows server 2003 on the secound SERVER ...
    (microsoft.public.windows.server.sbs)
  • Mirrored Volume
    ... I have a HD with critical informations ina W2K server. ... Configuring a secound ... will ensure me I can restore the system in case of failure of ...
    (microsoft.public.windows.server.general)