The tempdb tag has no wiki summary.
2
votes
0answers
43 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 ...
3
votes
1answer
55 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:?
...
3
votes
1answer
98 views
How to determine cause of runtime increase given two query plans with SpillToTempDb warning
Two actual query plans were captured for two executions of one query:
Plan "Fast" took ~1s and occurs about 90% of the time.
Plan "Slow" took ~16s.
Since the graphical plans look ...
4
votes
3answers
211 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 ...
2
votes
2answers
57 views
Moving one TempdB on 3 instance server
I have a large virtual SQL Server (Full 2008R2).
I run 3 SQL instances and would like to relocate the TempdB database file to another location, splitting off from the TempdB log file.
The trouble I ...
5
votes
1answer
73 views
When REBUILDing indexes on SQL Server, what bearing does tempdb & LOG disk speed have?
Say I have the a data disk that is 50x faster than the LOG and tempdb (measured by Random Write speed) disk. (Don't ask why that's something we'll be fixing if needed)
I have a table that's got 19 ...
4
votes
2answers
137 views
Objects in Tempdb that are not associated with a session
I have a SQL Server 2005 instance where my tempdb i apparently holding on to objects that are not in use anymore. The database has 24gb total and is apparently unable to go below 8gb in use. For ...
2
votes
0answers
19 views
SQL Server 2008 R2 SP1 - Tempdb “Available free space” showing negative value [duplicate]
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 ...
5
votes
2answers
547 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 ...
4
votes
1answer
135 views
Find transactions that are filling up the version store
we have enabled the "READ_COMMITTED_SNAPSHOT" for some of our SQL Server 2005 databases.
Now from time to time we see that our TempDB is filling up the harddisk and we suspect the version store to be ...
3
votes
2answers
329 views
Splitting TempDB into multiples files equal to number of CPUs
The article SQL Server tempdb Best Practices Increase Performance suggests that I should split tempdb into a number of files equal to the number of cores. So for 4 cores you get 4 files.
By ...
1
vote
2answers
202 views
Should a SQL Server TempDB space be allowed to be reclaimed?
If I don't have space concerns at the moment, should I size my TempDB as a large space initially and not let it's space be reclaimed?
What's the best way determine what the optimal initial size for ...
2
votes
0answers
116 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 ...
1
vote
2answers
181 views
Size of TempDB Microsoft SQL Server 2005
Are there drawbacks to having a large tempdb in a SQL Server database? Assuming the disk is not full.
I am creating large temporary tables in a couple of queries. Once I am finished running queries, ...
1
vote
2answers
103 views
SQL 2008 RTM Temp Tables
Today I implemented a monitoring solution on our SQL server using Cacti and the first thing i noticed is the growth in the number of temporary tables, in just 3 hours on our test system we had an ...
