Questions tagged [tempdb]
138 questions
-1
votes
1 answer
Need T-SQL script in SQL Server 2008 that will tell me disk space needed for a given dataset in tempdb BEFORE I run a select into with a given query
I need to find a T-SQL query in SQL Server 2008 that will tell me how much disk space will be needed for a given dataset in tempdb BEFORE I actually run a select into statement with a given query in order to create a new table.
Example:
select *
…
TuSabesTuSabes
- 61
- 1
- 10
-1
votes
1 answer
Optimize tempdb log files
Have a dedicated DB server with 16 cores and 200+ GB of memory.
Use tempdb a lot but it typically stays under 4 GB
Recently added a dedicated SSD stripe for tempdb
Based on this page should create multiple files
Optimizing tempdb Performance…
paparazzo
- 44,497
- 23
- 105
- 176
-1
votes
1 answer
Query Stuck in Suspended mode with IO_Completition as Wait Type
I am running a query in SQL Server 2008r2, it is stuck with
Task State: Suspended (Sometimes changes to Running but mostly Suspended)
Wait Type: IO_Completion.
There is another query running on the tempdb at the same time.
Is there any way to solve…
daniely
- 7,313
- 5
- 29
- 46