Hi Gail,

The mdf file is available. So there shouldnt be any data loss, correct?

Yes, something like that

Also, I checked percent_complete for checkdb from sys.dm_exec_requests and it is showing as 0.Its SQL Server 2014 EE 64bit SP1. There are only 2 user databases on this instance....

This job has 2 steps. It is stuck in the second step which does the DBCC CHECKDB. DBCC CHECKDB is in suspended state and the waittype it is showing...

Hi Gail,

The output was clean

Thanks

Good Morning Gail,

Actually, the job took much longer than usual to complete today. It was showing lastwaittype as LATCH_EX and waitresource as DBCC_OBJECT_METADATA. It was also showing self-blocking. I have...

Hi John,

The job finally completed. I want to know what action do i need to take if it repeats again

Thanks

max server memory just controls the buffer pool, not CLR, full text,multiple other processes that run outside of the Buffer Pool memory

But, SQL Server can acquire more memory than what is specified in max server memory

Good morning Gail Shaw,

When i install an application, set it to use 1GB RAM , will SQL Server grab this 1 GB RAM

Good morning Jonathan,

I am getting below error on running the script:

Msg 9455, Level 16, State 1, Line 1 

XML parsing: line 2, character 233, illegal qualified name character

I thoroughly looked at Event logs,SQL Logs and did not find anything.Is the problem with the PowerShell script?

Good Morning Experts,

This re-occurred again today. When it ran the first time, it performed CHECKDB only on 2 databases and failed. After we re-ran the job it performed CHECKDB on...