SQL Monitor and DBCC/Backups

robinw

Hi all

Just trying out the trial version with a view to purchase.

I have been getting an alert on tempdb file growth occurring out of hours on a Saturday.

Turns out it was the weekly DBCC checks causing growth (which is fine).

However, when I look at the queries running at this time, DBCC does not show anywhere in SQL Monitor.

I have also today ran a full backup on one of the databases taking around 45 minutes. Disk IO measurements went up according to the monitor graphs - but again, no sign of the backup having been run in SQL Monitor reports or queries being run at the time.

It might be something i've missed in the setup - but any reason as to why these commands are not showing when I investigate peak areas of activity?

Thanks for your help in advance.

Russell D

It'll be difficult without any more information to go on, can you send the logs into support?

robinw

Hi Russell.

I'll see if we get the same result on this weekends DBCC run.

If we do, I'll send the logs to you first thing on Monday morning.

What is the process of sending into support please?

Thanks.

Russell D

If you've got a valid support contract you can just fire them into support at red-gate.com with as much detail as you think relevant.