Dave

Thanks for the reply...

I current am running 9.00.4226, which is SP3 CU6. According to my monitoring tools the server was maxing CPU before the 0900 job for deadlock notification...

Correct. I just use the above script as a job to notify me of any certain alerts

You could try

EXEC xp_readerrorlog 6,1,'dbcc'

Change the 6 to...

Which DBCC commands are you tring to audit?

In most cases you can query the Error log to find out when they are run.

DECLARE @ErrorLog TABLE

(

LogDate DATETIME...

A blog to support Gila's post

Table variable are limited (IMO) if you are dealing with a large number of records.

I have found that using large record set temp table can offer better performace (if...

Try the list below. I have used this myself as it help with formatting too.

http://www.c-sharpcorner.com/UploadFile/mgold/Query2Excel12032005011029AM/Query2Excel.aspx

If your talking about within SSMS then it is displayed at the bottom of each query window you open.

Or you can run SELECT @@SPID

Is the SQL server under pressure, i.e. high CPU, % RAM used, Long running queries etc etc

Doesn't matter if it's before or after, unless it's doing a sampled update. If it's a sampled update then doing it after the indes rebuild is a very bad idea...

Im with Lynn on this one..

In times when queries were running slower than usual I found it to be either the stats or the proc cache.

Simply adding the recompile (as...

You could use the "Execute As" function in the SP.

This user would have existing on both servers and the relevant permissions to select/update/delete on the table(s) in the SP.

There are a few books out there but on the other hand I like to review articles and blogs.

A few are below which I have used in the past..

http://www.sql-server-performance.com/articles/clustering/clustering_best_practices_p1.aspx

http://www.sql-server-performance.com/articles/clustering/clustering_resources_p1.aspx

A good...

The only way I can think of without using .NET is to open/parse the rdl (as it is XML) and extract the SQL statement (should be found the <Query> and...

Are you running manual scripts to rebuild indexes or the standard MS plan?

If you your using a script you could try setting the "SORT_IN_TEMPDB" (If your recovery model is not...

You could try changing the recovery model (if you operational policy allows it).

If you do change the model then be sure to backup the db (after you set back to...