Perry Thanks, but the query didn't return anything. I am running my backups via Maintenance Plans (SSIS).

Hanshi I need the script to run via my CMS to see where...

I'll read through all of this later but the Environment is too large and too much going on to test backups regularly. 150 + Servers. Just one DBA.

99% of the...

Sorry I don't want to verify the backup> I want to check all my backup jobs to see which ones have or haven't got the verify enabled. Is there some...

Thanks

RUn this see if a process has a High Allocation and Low deallocation.

Are you running Service Broker ( a badly written service broker)?

select * from sys.dm_db_task_space_usage

where internal_objects_alloc_page_count <> 0

How do I find the query cost in the cache plan.

DWalker Thanks just read the article right before I saw your reply. Breaks it down very weel.

Keith - No reason other than best practise and knowledge growth, I do have...

Sorry the traceflag is 1204/05

Deadlocks are different from locking\blocking in SQL.

Deadloacks: 2 processes trying to obtain an incompatible lock on the same resource at the same time. The process which is the quickest to...

FOUND THIS..

http://www.sqlskills.com/blogs/paul/can-guid-cluster-keys-cause-non-clustered-index-fragmentation/

WHich backs up my understanding.

I'm sure I read an artical on this recently on SSC but I can't locate it at the moment.

Got it.

No read me file to know what the options are.

Do you have a link for a trusted website which will have SQLPING or SQLRECON ready to be downloaded.

Execellent response.

Cheers.

Talib123 (12/13/2013)

---

Use Select * from sys.databases

Find the dbid

Select * from sys.sysprocesses where dbid = dbid

Find the spid number

kill spid number

If the spid is a minus number you have...