SQL Server running very slow

[dBjason]

SQL Server 8


Hello,

My problem is just that, I have a server running waaay slower than usual. Stored procedures which usually take 3-5 minutes are now taking 20-30 minutes.

I don't know where to start or what to do, any ideas?

Thanks,
Jason

 

[mrdenny]

How much memory is in use? (How much do you have total? How much is SQL configured to use?)
What are the CPUs running at?
Is there anything else going on, on the server?
Have any drives gone bad?
Has any other hardware gone bad?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[dBjason]

Thanks mrdenny, that actually gave me alot to go on as well as things to think about in future situations.

Come to find out, two [rather large] procs were running simultaneously. Looks like I need to manage some job scheduling...

 

[mrdenny]

Ah, that will do it.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)