DBCC is a T-SQL statement provided by SQL Server. This tag is used for questions regarding DBCC and its use.

learn more… | top users | synonyms

3
votes
1answer
82 views

DBCC CHECKDB Consistency Error

I am having a problem with replicating a table, and I finally tracked it down to a consistency error on the source table, but I am stumped as to what is causing the consistency error. I ran DBCC ...
1
vote
1answer
1k views

DBCC Results: page ID contains an incorrect page ID in its page header

DBCC results for 'tablename' Msg 8909, Level 16, State 1, Line 1 Table error: Object ID 1637580872, index ID 1, partition ID 72057596516040704, alloc unit ID 72057594048020480 (type LOB data), page ...
0
votes
1answer
132 views

SQL Server 2012 - Deadlock happening daily

We have a performance issue with a 3rd-Party application using SQL Server 2012: deadlock happen at least 10 times an hour. The server is virtual server on VMWare 5.5 with PVSCSI adapter in persisted ...
3
votes
0answers
40 views

Increasing the size of differential backups

I have a DB in which some transaction remains open that is increasing the size of differential backups, I had to kill those transaction frequently, I want to drill down to the transaction and find out ...
2
votes
0answers
773 views

TempDB MDF file huge after update script ran

On the weekend we had a huge deployment run that affected a large chunk of our system. It was all run in one massive transaction (probably the wrong thing to do). As a result our TempDB DatabaseFile ...
2
votes
0answers
359 views

Last Known Successful DBCC CHECKDB

I understand that looking at DBCC PAGE is supposed to show me the last known good DBCC CHECKDB but I am not seeing this work correctly. I have a database that I know is corrupted. If I run DBCC ...
1
vote
0answers
55 views

DBCC SHRINKFILE (N'XYZ' , EMPTYFILE) using single core

Is there any way to force DBCC SHRINKFILE to use more than one core? We're running SQL Server 2014 on a hex core machine - and SHRINKFILE is using one hyper threaded core. I/O is at a small fraction ...
1
vote
0answers
381 views

DBCC TABLE CHECK seems to hang

Our nightly maintenance plan includes a database integrity check which normally takes 45 minutes to complete. Now it appears to hang. When looking at the Activity Monitor, a series of process items ...
1
vote
0answers
889 views

Unable to insert into or update table

A have the following table in a SQL Server 2000 database (service pack 2), with about 600,000 rows: Id [int, primary key] Form [int] Element [int] Data [char(8000)] MoreData [varchar(8000)] ...
1
vote
0answers
545 views

DBCC Physical only giving Connection failure

I have a SQL server 2012 Ent DB. The hosting company is trying to setup new backup solution using Symantec Backup Exec. They have come back and said our database is corrupt because they get these ...
0
votes
0answers
55 views

Real corruption?

We have a production database for Solarwinds Orion Network Performance Monitor in which we discovered corruption in a MapStudioFiles table following DBCC CHECKDB errors. CHECKDB Output: Msg 8961, ...
0
votes
0answers
50 views

SQL Server DBCC OUTPUTBUFFER: is the output buffer a circular buffer?

While viewing the results from a long-running SQL process with a large amount of output from "print" statements, it appears that the output buffer is a circular buffer. So midway through the process, ...
0
votes
0answers
227 views

Speeding up an openrowset between SQL Server and MySQL

Good morning I'm trying to import data from an MySQL table using openrowset so I can do calculations and transformations on SQL Server. The problem is that the table in question is quite big. The ...