Please note: 6 year old thread

If it's leaving a transaction open, I suspect the procedure's failing somewhere or has something else wrong.

Put the date in single quotes

None of those are promotions from DBA, they're just alternate career paths. To move DBA to one of those would be a side-ways step, not upward.

I'm going to go...

mJai (11/26/2013)

---

Thanks, That returned me the following results. From the start time this seems like this process's been running for over 3 days.

Oldest active transaction:

SPID (server...

You'll definitely need to rebuild the clustered index to release the free space into the data file for reuse by other tables, may need to run DBCC CleanTable as well

DBCC CheckIdent

Look in Books Online for the exact syntax and explanation of how it works

It says locks, so one would assume it has something to do with locks.

As I said above, the 'average wait time for an instance' is useless. You need to investigate,...

Depends on what the waits are for. Average wait time by itself is useless, to even begin to start you need to know what waits and what the tool considers...

About fixing metadata, I'm not discussing about the complexity of parsing the files and checking each page's content and I really don't want to go this way. When I said...

7% reserved is low for a server this size. The OS needs memory to map and manage memory. I'd go with Jonathan's recommendations (in book and blog post referenced above)...

Autoclose doesn't set the database to the OFFLINE state. A database closed by Auto_Close...

I generally recommend leaving min server memory at 0 unless there's a good reason otherwise. Good reasons may include over-committed virtual machines and multi-instance clusters where it is possible for...

Most of them don't do what they promise. I personally wouldn't use any.

As for what you use when repair doesn't work - restore. Restore from backup. Emergency mode repair is...