sql server 2000 gone slow 1

[shams123]

Hi guys,

For some odd reason my sql server has gone really really slow! Every query in sql query analyzer is suddenly taking ages to run!

Any idea what could possibly cause this? A different machine with the same specs and database is fast as expected.

Thanks!

 

[hmckillop]

has the tempdb run out of space - check where master/tempdb etc are located and check they arent running out of space.

Second option - try running profiler to see where the problem lies (i.e. if excessive reads etc could be query plans are skewed)

101 other options - wait to George gets started

"I'm living so far beyond my income that we may almost be said to be living apart

 

[SQLDenis]

proably statistics that are out of date

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[mrdenny]

It could be any number of things. Way more information will be needed before anyone can take more than a guess as to what the problem is.

Here are some common possible reasons.

1. The OS doesn't have enough memory left to it. (Check this in the Task Monitor).

2. The drives that the database is on are at capacity. (Check the performance monitor for the disk queueing for that drive.)

3. There is another process running that is taking all the CPU power from the server.

4. There are to many processes running taking all the CPU power from the server.

5. Your stats are out of date.

6. Indexes are missing or were dropped that are needed.

Does the problem go away if SQL Server is restarted?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com

 

[shams123]

Hi Denny,

That helped, my code had some problems and that was causing the bottleneck.

Cheers!

 

[mrdenny]

No problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005)

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

http://www.mrdenny.com