Hi Lynn Pettis,

Not really understanding why it it did consistency checks on all databases, after we manually restarted the job after 1 hour. Could you please let me know what...

Hi Gail Shaw,

When we manually restarted the job after 1 hour,it did not encounter any log backup jobs. and it did consistency checks on all databases.

Hi Grant Fritchey,

So, you are saying when dbcc checkdb and log backup job run at same time, there will be contention.

When the two jobs are running at same time, dbcc...

Hi Jeff,

It was management's decision. So, can we conclude that it stopped when it ran for the first time due to log backup job running at same time?

The job actualy runs a Powershell script that does DBCC CHECK on all databases. The output log just says "Maintenance completed with errors".Thats it, there is no other information or...

Interesting thing is that, after 1 hour, the DBCC CHECK job was restarted. During its run, it did not encounter any log backup jobs and fascinatingly it did CHECKDB on...

It just says "Maintenance completed with errors". Thats it, there is no other information or error message posted in the SQL Logs or Job output files etc.

Hi Jeff,

The Senior DBA got CPU and memory utilization data for last 7 days from system admin team. He found that there was no CPU or memory pressure when...

Good morning experts

Sorry for delay. Our senior dba got the data from the sysadmin team. Thanks a lot for your help

We cannot use extended events as it is not supported. Please let me know how to set up the trace

can you please post the script that worked for you, for the benefit of community

Dear Gail Madam,

How to know which query caused tempdb to become full 1 hour back?

We are adding space and tempdb log becomes full in few days. Please advise

Dear Gail Madam

I did not understand your message. Are you saying that there is no point in shrinking tempdb log file?could you please let me know the solutions

Dear Experts,

Also, is there a way to find what caused tempdb to become full last night?