All Questions
Tagged with tempdb dbcc-checkdb
8 questions
6
votes
1
answer
4k
views
DBCC CHECKDB on a user database: Time-out occurred while waiting for buffer latch type 2 for page (X:XXX), database ID 2
Our Ola Hallengren IntegrityCheck job failed due to a buffer latch timeout while running DBCC CHECKDB on a user database.
However, the buffer latch timeout reported was in TempDB (database ID 2).
...
- 483
0
votes
0
answers
283
views
How does DBCC CHECKDB use tempdb?
I would like to know the working principle of DBCC regarding the tempdb. I want to know why it uses tempdb for what purpose. I didn't find any advanced article about that so maybe someone can shortly ...
- 1,303
1
vote
1
answer
534
views
Filestream directory exists for a partition but the corresponding partition does not exist in the database
I am investigating a high memory usage issue of tempdb on a production SQL Server 2017 Enterprise (64-bit) deployment. This is similar to an issue discussed here. The server has two production DBs ...
2
votes
1
answer
3k
views
DBCC CHECKDB grows tempdb to a huge size - Legacy MS SQL Server 2008 R2 Instance
I have an older Microsoft SQL Server Instance (2008 R2 SU3 GDR - Build: 10.50.6220). When I run DBCC CHECKDB via a Maintenance Plan, the TempDB grows very large.
The largest DB on the instance is ...
- 21
13
votes
4
answers
68k
views
Allocate space for object 'dbo.SORT temporary run storage
DBCC CHECKDB returns:
Could not allocate space for object 'dbo.SORT temporary run storage:
140737951236096' in database 'tempdb' because the 'PRIMARY' filegroup
is full.
Create disk space ...
- 331
3
votes
1
answer
485
views
Suspect (Torn) Pages regarding tempdb?
I have a virtualised SQL Server 2005 (SP3) that reported the following message:
Database_Name, Database_Id, File_Id, Event_Type, Event_Type_Desc, Error_Count, Last_Update_Date
tempdb, 2, 1, 3, Torn ...
- 131
2
votes
1
answer
1k
views
TempDB not selectable for DBCC maintenance plan
I'm trying to clean up some of our maintenance plans and noticed that our TempDB is not getting it's weekly dose of DBCC CHECKDB goodness. I've tried to go into the maintenance plan and make sure it'...
- 3,844
9
votes
3
answers
9k
views
How might a corrupt partition in TempDB result in DBCC CHECKDB reporting no issue?
One of our SQL Servers reported the following error recently:
DATE/TIME: 2/25/2013 9:15:14 PM
DESCRIPTION: No catalog entry found for partition ID 9079262474267394048
in database 2. The ...
- 70.5k