Please follow the link in my signature on posting performance problems and posting code and data for the best help.

First off I would get rid of the NOLOCK hints, unless...

If you want to do the same thing in each database, then this would be another alternative solution

DECLARE @sql NVARCHAR(MAX)

SELECT @sql =

REPLACE(

CAST(

(

SELECT 'USE ' + QUOTENAME(name) +';' + CHAR(13)...

http://www.sqlservercentral.com/Forums/Topic1410348-391-1.aspx

While Solarwinds now does application monitoring, it will be up to you to investigate if it does what you need it to do.

I would seriously recommend, getting trial editions of...

Solarwinds, is primarily a network monitoring tool but has branched out into a IT Management & monitoring solutions

http://www.solarwinds.com/

I evaluated it a good few years ago now and it wasn't mature...

Restore from backup would be the only way now I am guessing due to repair_allow_data_loss being run and terminated.

runal_jagtap (1/23/2013)

---

Microsoft SQL Server 2005 - 9.00.5000.00 (X64)

Dec 10 2010 10:38:40

Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2

(Build 3790:...

What edition of SQL Server?

If its a heap, you need to do

ALTER TABLE tablename REBUILD

page count column from sys.dm_db_index_physical_stats

also contained on the index properties GUI in SSMS in the fragmentation tab

All statistics and indexes rebuilt and updated on the order table?

Can you post the execution plans as a SQLPLAN file from the below query, if they exist any more.

select

query_plan

from...

So I take it you already hold a MCITP DBA or MCITP DD certification for 2008? Congratulations on that.

As 70-459 is an upgrade, your best learning the concepts in...

You cannot mark them as answered on SSC, as it is primarily a discussion forum so topics are open for all to see and people may come back with their...

Could check the default trace see what else was happening at the time, or if you have any custom auditing try and look through that to see what was going...

Please take a moment to read through the second link in my signature on posting code and data for the best help.

But based on your post, you need something like...

The database couldn't be X-locked to perform the snap, something was happening with the database which prevented the first step of CheckDB to complete.

It needs to create a snapshot of...