Viewing 15 posts - 151 through 165 (of 274 total)
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...
September 26, 2016 at 11:05 am
Hi Gail,
The output was clean
Thanks
July 19, 2016 at 11:03 am
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...
July 19, 2016 at 7:30 am
Hi John,
The job finally completed. I want to know what action do i need to take if it repeats again
Thanks
July 19, 2016 at 7:12 am
max server memory just controls the buffer pool, not CLR, full text,multiple other processes that run outside of the Buffer Pool memory
June 16, 2016 at 8:43 am
But, SQL Server can acquire more memory than what is specified in max server memory
June 16, 2016 at 7:08 am
Good morning Gail Shaw,
When i install an application, set it to use 1GB RAM , will SQL Server grab this 1 GB RAM
June 16, 2016 at 5:04 am
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
June 8, 2016 at 9:43 pm
I thoroughly looked at Event logs,SQL Logs and did not find anything.Is the problem with the PowerShell script?
June 5, 2016 at 6:26 pm
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...
June 5, 2016 at 5:45 am
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...
June 2, 2016 at 7:36 pm
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.
June 2, 2016 at 6:50 am
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...
June 1, 2016 at 10:40 pm
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?
June 1, 2016 at 8:54 pm
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...
June 1, 2016 at 7:45 pm
Viewing 15 posts - 151 through 165 (of 274 total)