Have you PHYSICALLY been in the room with that server with a screen looking at what's going on?

Lots of possible culprit would be visible from there. Especially with reboots...

You need to learn to use profiler if you're going to succeed in this career. There's nothing here you can't learn to do on your own.

Open profiler, connect on...

That might start you up : exec sp_helplogins

In case you preffer a ready made solution...

The answer to your current question will also be in that script.

http://sqlfool.com/2011/06/index-defrag-script-v4-1

I don't know about the shutdown, but I can say for sure that you're way overdue to run checkdb!

'GData_Antivirus' finished without errors on 2011-02-12 10:00:02.673 (local time).

That's before last...

Sean Lange (10/11/2011)

Kiara (10/11/2011)

<inserts copy/paste argument from multiple...

The backup will keep running without blocking anything else (short of slowing other disk operations).

The backup contains the db image at the time of the END of the backup.

Well database growing = longer backups. Nothing weird there.

I'd make sure the hds are fixed before alarming everybody and their spouses.

Any reasons you can't let the backup finish? ...

Sorry for trying to help. I'll stop that RIGHT AWAY.

Learn xquery and dig your way thru the plans.

Sorry for the troubles.

AFAIK there's no dmv for that (can you imagine all the ram it would take to log all that).

That's why traces where invented. I'd go with the default trace...

What's the exact error?

I'd check for viruses (need to be directly logged in to see that). There was one with a similar "feature" a few years ago in xp.

I'd also check for...

You need to go back to school (or learning) and figure this out. You don't need 1 query to monitor a...

http://www.red-gate.com/products/dba/sql-monitor

Can you start a trace for 1 minute?