Linked Questions

1
vote
1answer
136 views

Sleeping spid is utilizing over 10 million pages of tempdb logspace

I was trying to figure out what is using all the tempdb logspace. It is coming from a sleeping spid that was creating a clustered index on a nearly 3 billion row table. (This particular clustered ...
0
votes
1answer
612 views

MS SQL Server: DBCC ShrinkDatabase - Does it really not shrink the database below the minimum size?

Per Microsoft's documentation on DBCC ShrinkDatabase command, it shouldn't shrink the database below it's "minimum size". But when I ran the command, my database data files' initial file sizes shrunk ...
0
votes
1answer
275 views

Secondary Tempdb filling up on AG Setup

I'm currently facing this problem in one of my Production environments. I have an AG with around 130 DBs with readable secondaries enabled. However, there are not routing lists defined and ...
0
votes
1answer
3k views

TempLog.ldf Grows Too Large [duplicate]

We have a stored procedure that we run regularly. It blows up the size of TempLog.ldf from nothing to 150 GB in the course of 3-4 hours. What's going on and why is it so big? TempDB.mdf is a constant ...
0
votes
0answers
125 views

TempDB log file bloated suddenly [duplicate]

I am trying to understand what could be the possible reason which would have caused tempdb ldf file grow full and went out of space on the drive it resides. Compared the pattern for last month and ...
-1
votes
2answers
1k views

Shrink Tempdb log file when reaching a specific size [closed]

how I can shrink tempdb log file when reaching a specific size?? I'm scheduling job to shrink tempdb but still I face a problem of disk space due to tempdb is full!

15 30 50 per page
1
2