All Questions
Tagged with sql-server-2005 tempdb
19 questions
1
vote
2
answers
4k
views
Understanding the usage of version store in tempdb
We are trying to analyze the growth of tempdb on one of our SQL server 2005 Ent SP4.
I know tempdb would need the space depending upon the transactions, and how queries are designed to use it.
We ...
- 7,203
3
votes
1
answer
505
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
1
vote
0
answers
39
views
How to identify the creator of the temporary table in SQL Server 2005 [duplicate]
On my server many users performing complex queries using tempdb. Sometimes a failed specifying boundary values obtained are very large tables.
So I want to know who created this temporary table.
...
- 417
18
votes
2
answers
36k
views
Find which session is holding which temporary table
We have a SQL Server 2005 database the temp database has become full. By going into SQL Server Management Studio I can see all the temporary tables in the tempdb. Is it possible to tell which session ...
- 437
6
votes
2
answers
18k
views
Issues with TempDB mdf file ever increasing
I have a tempdb growth issue. Let me preface everything by giving my tempdb settings.
Even with no queries running on the database/server tempdb keeps on increasing in size, at first rapidly and then ...
- 123
2
votes
1
answer
2k
views
TempDB on Solid State Drives on SQL Server Cluster
Can solid state drives be used for the TempDB on a SQL Server failover cluster if they are local drive on both machines? It is supported in 2012 but our cluster is a SQL 2005. The application that it ...
- 21
1
vote
1
answer
2k
views
Simple update query balloons tempdb
I am trying to do a bulk update of a column from a csv file, however when I do the actual update operation my tempdb balloons to over 20 GB in size (overtaking the entire size of the SSD the tempdb is ...
- 1,045
8
votes
2
answers
16k
views
TempDB Version Store cleanup
From what I can find the version store will only clean up versions that are older than the oldest active transaction. Question: Is the oldest transaction database specific or will SQL Server keep all ...
- 1,538
4
votes
3
answers
2k
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 ...
- 24.3k
6
votes
2
answers
18k
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 ...
user1822
1
vote
2
answers
685
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,507
2
votes
1
answer
834
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 ...
- 336
12
votes
1
answer
6k
views
SQL Server TempDB behaviour in large memory environment
Reading over this question reminded me of a question I had a while ago.
We have a SQL Server that has 512GB of RAM, the main database is 450 GB. We see quite a lot of action in TempDB (ok, I think ...
- 71k
4
votes
3
answers
988
views
Creating new TempDB files
I would like advice on what would be the best setup for our SQL Server 2005 TempDB.
At the moment our Temp DB consists of a single MDF file of 3 GB and a single log file of 120 MB on the D: drive of ...
- 195
81
votes
4
answers
221k
views
How to identify which query is filling up the tempdb transaction log?
I would like to know how to identify the exact query or stored proc which is actually filling up the transactional log of TEMPDB database.
- 1,033