| =?iso-8859-1?Q?Mart=EDn?= 2002-11-28, 9:24 am |
| Sylvain,
You must monitor the Diks subsytem, in this part could be
the problem.
>-----Original Message-----
>Hi all,
>
>I have a big problem with a sql server 2000 on which the
dedicated CPU stay
>always above 90%.
>
>It happens since the time that we migrate this server
from another one. The
>new one configuration is the following:
> - 4*XEON 700 Mhz, 2Gb de RAM and SAN connection (it
should be ok !!!)
>The new instance is linked to an application that sniff
computer on the
>network and save these info on the DB (a lot of
transaction read/write)
>
>Before on the old server (PIII 450 396 Mo RAM)we never
had this behaviour.
>
>In order to secure other instance on the new server we
can dedicate only one
>processor and 800 Mo of RAM....
>
>So if you have any idea ......
>
>
>
>
>
>.
>
|