Repair

[cfk]

I have an sql server 2000 db running on a four processor box. The system has slowed down and performance keeps going up and down almost randomly. I'm defraging all the indecies.
Is there a routine I can run to check for performance isses / errors within the database.
Is there any routine to run to repair a database if it is corrupt.

 

[tlbroadbent]

SQL Books Online contains a lot of information about repairing databases. Look up the DBCC CHECKDB command.

The first priority for SQL Performance improvement is to analyze the application. The next issue is database structure. The table may be indexed but are the indexes used by the queries.

Check the following link for some web resources on performance tuning.

http://tlbroadbent.home.attbi.com/sql/ss_performance.htm

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.