The tempdb tag has no wiki summary.
4
votes
2answers
326 views
SQL Server 2008 R2 SP1 - Tempdb “Available free space” showing negative value
Please help as this issue is driving me nuts...
Tempdb has four data files & one log file. They are all located on the same dedicated drive.
When I right click on tempdb in SQL Server Management ...
2
votes
2answers
153 views
Best practice for tempdb log file
I have read many blogs here and there about how to configure tempdb data files but i didnt found any information regarding the tempdb log file.
Here's the strategy that I'm presently using with my ...
3
votes
1answer
39 views
tempdb logs on same drive as tempdb data or with other logs?
For many reasons I only have 3 hard drives (RAIDed and in an Always-On AG) for all my database files:
D: Data
E: Logs
F: Tempdb
Should the tempdb log file go on F: with the data file(s) or on E:?
...
1
vote
1answer
2k views
TempDB data files don't shrink well on SQL 2008
So ideally you want to pre-size your TempDB data and log files appropriately so that this isn't a concern, but sometimes a rogue developer runs a crazy huge query on a production server during work ...
2
votes
0answers
104 views
tempdb objects creator wanted, bufferpool issue caused by tempdb objects
I have a number of tables in tempdb named like
#A0030B77
#A01D908C
#A06D1FCB
#A0F72FB0
#A1614404
#A1EB53E9
#A205D8FE
#A255683D
How (if) can I get spid of the process which created them?
These ...
2
votes
0answers
66 views
Is it normal for tempdb TPS to be higher than all other databases combined?
I'm investigating some performance issues on a production DB here, and I've noticed a slightly odd thing that I'm not sure is weird or not.
If I run a quick Performance Monitor trace for the ...
2
votes
0answers
573 views
823 errors on tempdb
Have a couple Fiber channel SAN-attached cluster servers which have been intermittently reporting errors like:
2012-05-09 16:31:54.13 spid74 Error: 823, Severity: 24, State: 2.
2012-05-09 ...
