Re: SQL Server lagging

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

From: Brian Henry (nospam_at_nospam.com)
Date: 03/08/05 

Date: Tue, 8 Mar 2005 11:33:51 -0500

woops ment to post that to sqlserver2000 not exchange2000

"Brian Henry" <nospam@nospam.com> wrote in message
news:%23%239%23zi$IFHA.3628@TK2MSFTNGP15.phx.gbl...
> We have a problem with two of our SQL Server boxes right now. They worked
> fine for a while then out of no where to do a simple insert into tablea
> (colA) value (1) type of command into an empty table it takes ober 15
> minutes to execute.. now this isn't a slow server and still 15 minutes on
> a slow server is horrible.. the only thing installed on the server too is
> SQL Server 2000 SP3.. the server specs are Dual Xeon 3.0GHz chips with 2GB
> of RAM on windows 2003 with a RAID 5 SCSI 15K array with ~130GB of free
> space. Any ideas on what to look for or what could cause such a long time
> to execute? the wierd thing is that it works perfectly fine again after
> the server is restarted on both servers this is happening on. The server
> is set up on a basic TCP/IP configuration and its configured to use both
> processors and licensed for it also.
>
> If no one has an idea of what it could be, does anyone know the MS number
> I can call to get support with this, paying for it is perfectly fine also
> since we need this fixed as soon as possible. thanks a lot!
>