4 Answered Questions
[SOLVED] How to identify which query is filling up the tempdb transaction log?
- 2012-06-25 14:49:54
- prasanth
- 153306 View
- 63 Score
- 4 Answer
- Tags: sql-server sql-server-2008 sql-server-2005 transaction-log tempdb
2 Answered Questions
[SOLVED] How to find the SQL statements that caused tempdb growth?
- 2012-02-25 06:26:25
- u23432534
- 55583 View
- 26 Score
- 2 Answer
- Tags: sql-server sql-server-2008 tempdb
1 Answered Questions
[SOLVED] Find transactions that are filling up the version store
- 2013-03-11 13:43:17
- a_horse_with_no_name
- 7554 View
- 6 Score
- 1 Answer
- Tags: sql-server sql-server-2005 tempdb tempdb-version-store
1 Answered Questions
[SOLVED] how to find out what process(es) caused the autogrowth of a database or a database file?
- 2016-07-13 11:41:25
- marcello miorelli
- 1973 View
- 3 Score
- 1 Answer
- Tags: sql-server sql-server-2014 tempdb process
2 Answered Questions
[SOLVED] Issues with TempDB mdf file ever increasing
- 2014-01-13 19:56:24
- nightmareivy
- 12370 View
- 6 Score
- 2 Answer
- Tags: sql-server sql-server-2005 disk-space tempdb auto-growth
2 Answered Questions
[SOLVED] Find which session is holding which temporary table
- 2014-03-25 15:35:08
- SQLMIKE
- 21204 View
- 10 Score
- 2 Answer
- Tags: sql-server sql-server-2005 tempdb
2 Answered Questions
[SOLVED] Splitting TempDB into multiples files equal to number of CPUs
- 2013-01-23 22:21:47
- Preet Sangha
- 9572 View
- 8 Score
- 2 Answer
- Tags: sql-server sql-server-2008-r2 storage tempdb disk-structures
3 Answered Questions
[SOLVED] Safely moving and creating new tempdb files
- 2012-07-11 18:49:10
- Stuart Blackler
- 23690 View
- 19 Score
- 3 Answer
- Tags: sql-server sql-server-2008-r2 tempdb
3 Answered Questions
[SOLVED] What are the most effective techniques to reduce SQL Server disk space use when updating all rows in a very large table?
- 2014-03-12 17:25:40
- BrianCooksey
- 10189 View
- 6 Score
- 3 Answer
- Tags: sql-server transaction-log tempdb
2 Answered Questions
[SOLVED] Tempdb autogrowth settings
- 2012-07-15 19:38:20
- Stuart Blackler
- 9059 View
- 4 Score
- 2 Answer
- Tags: sql-server tempdb
2 Answered Questions
[SOLVED] TempDB will not shrink. No Open Transactions
- 2014-08-06 16:27:43
- user45117
- 14401 View
- 7 Score
- 2 Answer
- Tags: sql-server-2008 tempdb shrink
1 Answered Questions
[SOLVED] Does RCSI use less or same space than SNAPSHOT? Why?
- 2013-12-13 08:35:34
- Fulproof
- 234 View
- 6 Score
- 1 Answer
- Tags: sql-server transaction tempdb snapshot-isolation tempdb-version-store
1 Answered Questions
[SOLVED] IO request time and less write latency
- 2015-05-07 13:44:46
- Zerotoinfinity
- 894 View
- 6 Score
- 1 Answer
- Tags: sql-server-2012 transaction-log tempdb compression
1 Answered Questions
[SOLVED] Tempdb Add files require Restart
- 2018-06-28 16:09:31
- user129291
- 1579 View
- 3 Score
- 1 Answer
- Tags: sql-server sql-server-2012 performance-tuning tempdb
1 Answered Questions
IDERA suggests to alter procedures in tempdb
- 2017-05-16 20:12:16
- k1rk
- 56 View
- 1 Score
- 1 Answer
- Tags: sql-server tempdb
2 Answered Questions
[SOLVED] SQL Server tempdb on RAM Disk?
- 2017-01-13 03:43:36
- d-_-b
- 6391 View
- 11 Score
- 2 Answer
- Tags: sql-server tempdb
3 Answered Questions
[SOLVED] Sort spills to tempdb due to varchar(max)
- 2019-01-16 14:10:17
- Frederik Vanderhaegen
- 478 View
- 10 Score
- 3 Answer
- Tags: sql-server query-performance tempdb cardinality-estimates
1 Answered Questions
[SOLVED] What frequency of hash/sort spills into tempdb is concerning?
- 2014-06-02 16:19:58
- Matthew Rodatus
- 4102 View
- 9 Score
- 1 Answer
- Tags: sql-server performance tempdb
2 Answered Questions
[SOLVED] Should I check for existence of temp tables in Stored Procedures?
- 2014-08-08 14:34:17
- Akash
- 6201 View
- 7 Score
- 2 Answer
- Tags: sql-server sql-server-2012 sql-server-2014 stored-procedures tempdb
3 Answered Questions
[SOLVED] How might a corrupt partition in TempDB result in DBCC CHECKDB reporting no issue?
- 2013-02-27 17:16:33
- Max Vernon
- 7571 View
- 8 Score
- 3 Answer
- Tags: sql-server sql-server-2012 tempdb dbcc-checkdb
2 Answered Questions
[SOLVED] TempDB Version Store cleanup
- 2013-07-08 17:07:34
- Cougar9000
- 6733 View
- 7 Score
- 2 Answer
- Tags: sql-server sql-server-2005 tempdb tempdb-version-store
3 Answered Questions
[SOLVED] Recommendations for more than one tempdb file
- 2016-12-22 19:34:57
- Rafaells
- 1180 View
- 5 Score
- 3 Answer
- Tags: sql-server sql-server-2012 tempdb
1 Answered Questions
[SOLVED] Why does FREEPROCCACHE let you shrink tempdb?
- 2016-11-07 18:45:26
- James Jenkins
- 2273 View
- 1 Score
- 1 Answer
- Tags: tempdb shrink cache dbcc plan-cache
1 Answered Questions
How to find which query is causing tempdb growing?
- 2016-09-12 08:24:25
- Gianmatteo Stucchi
- 2392 View
- 1 Score
- 1 Answer
- Tags: sql-server tempdb
2 Answered Questions
[SOLVED] SQL Server tempdb on SSD showing IO
- 2018-05-03 16:18:20
- G Devine
- 442 View
- 7 Score
- 2 Answer
- Tags: sql-server sql-server-2012 tempdb
2 Answered Questions
[SOLVED] what is the best practice for tempdb autogrowth?
- 2018-01-25 14:03:16
- sql_girl
- 4078 View
- 7 Score
- 2 Answer
- Tags: sql-server t-sql disk-space tempdb auto-growth
3 Answered Questions
[SOLVED] SQL Server 2008 R2 SP1 - Tempdb "Available free space" showing negative value
- 2013-03-27 17:35:35
- Chinesinho
- 10231 View
- 7 Score
- 3 Answer
- Tags: sql-server sql-server-2008 tempdb
1 Answered Questions
[SOLVED] Splitting SQL Server tempdb to use a second drive when first drive is full
- 2014-05-15 20:02:14
- Alton XL
- 444 View
- 4 Score
- 1 Answer
- Tags: sql-server tempdb
3 Answered Questions
[SOLVED] Allocate space for object 'dbo.SORT temporary run storage
- 2017-01-18 14:43:00
- shamim
- 18732 View
- 1 Score
- 3 Answer
- Tags: sql-server sql-server-2008 tempdb dbcc-checkdb
1 Answered Questions
[SOLVED] 'Logical file name "MyDB" is already in use' Even though the database doesn't exist
- 2016-01-15 14:47:50
- Brandon
- 3852 View
- 1 Score
- 1 Answer
- Tags: sql-server sql-server-2014 tempdb datafile
