4 Answered Questions
[SOLVED] How to identify which query is filling up the tempdb transaction log?
- 2012-06-25 14:49:54
- prasanth
- 171083 View
- 70 Score
- 4 Answer
- Tags: sql-server sql-server-2008 sql-server-2005 transaction-log tempdb
3 Answered Questions
[SOLVED] How to find the SQL statements that caused tempdb growth?
- 2012-02-25 06:26:25
- u23432534
- 60591 View
- 29 Score
- 3 Answer
- Tags: sql-server sql-server-2008 tempdb
2 Answered Questions
[SOLVED] Find which session is holding which temporary table
- 2014-03-25 15:35:08
- SQLMIKE
- 25887 View
- 14 Score
- 2 Answer
- Tags: sql-server sql-server-2005 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
- 9209 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
- 2494 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
- 13708 View
- 6 Score
- 2 Answer
- Tags: sql-server sql-server-2005 disk-space tempdb auto-growth
1 Answered Questions
[SOLVED] Tempdb Add files require Restart
- 2018-06-28 16:09:31
- user129291
- 3245 View
- 4 Score
- 1 Answer
- Tags: sql-server sql-server-2012 performance tempdb performance-tuning
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
- 8021 View
- 9 Score
- 3 Answer
- Tags: sql-server sql-server-2012 tempdb dbcc-checkdb
1 Answered Questions
[SOLVED] Why does FREEPROCCACHE let you shrink tempdb?
- 2016-11-07 18:45:26
- James Jenkins
- 3568 View
- 1 Score
- 1 Answer
- Tags: tempdb shrink cache dbcc plan-cache
2 Answered Questions
[SOLVED] Splitting TempDB into multiples files equal to number of CPUs
- 2013-01-23 22:21:47
- Preet Sangha
- 10103 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
- 25564 View
- 22 Score
- 3 Answer
- Tags: sql-server sql-server-2008-r2 tempdb
2 Answered Questions
[SOLVED] TempDB will not shrink. No Open Transactions
- 2014-08-06 16:27:43
- user45117
- 18864 View
- 9 Score
- 2 Answer
- Tags: sql-server-2008 tempdb shrink
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
- 10415 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
- 10842 View
- 4 Score
- 2 Answer
- Tags: sql-server tempdb
1 Answered Questions
[SOLVED] IO request time and less write latency
- 2015-05-07 13:44:46
- Zerotoinfinity
- 1116 View
- 6 Score
- 1 Answer
- Tags: sql-server-2012 transaction-log tempdb compression
1 Answered Questions
[SOLVED] Does RCSI use less or same space than SNAPSHOT? Why?
- 2013-12-13 08:35:34
- Fulproof
- 260 View
- 6 Score
- 1 Answer
- Tags: sql-server transaction tempdb snapshot-isolation tempdb-version-store
2 Answered Questions
[SOLVED] Is it generally faster to select into a temp table than selecting into an actual table?
- 2020-01-22 23:49:41
- J.D.
- 3619 View
- 34 Score
- 2 Answer
- Tags: sql-server sql-server-2016 memory tempdb temporary-tables
2 Answered Questions
[SOLVED] SQL Server tempdb on RAM Disk?
- 2017-01-13 03:43:36
- d-_-b
- 8530 View
- 12 Score
- 2 Answer
- Tags: sql-server tempdb
2 Answered Questions
[SOLVED] How to Move TempDB Files to a Different Drive or Folder?
- 2017-11-27 14:55:05
- Oreo
- 3570 View
- 8 Score
- 2 Answer
- Tags: sql-server t-sql tempdb datafile
1 Answered Questions
[SOLVED] What frequency of hash/sort spills into tempdb is concerning?
- 2014-06-02 16:19:58
- Matthew Rodatus
- 5055 View
- 11 Score
- 1 Answer
- Tags: sql-server performance tempdb
3 Answered Questions
[SOLVED] Sort spills to tempdb due to varchar(max)
- 2019-01-16 14:10:17
- Frederik Vanderhaegen
- 561 View
- 10 Score
- 3 Answer
- Tags: sql-server performance tempdb cardinality-estimates query-performance
2 Answered Questions
[SOLVED] what is the best practice for tempdb autogrowth?
- 2018-01-25 14:03:16
- sql_girl
- 7008 View
- 7 Score
- 2 Answer
- Tags: sql-server t-sql disk-space tempdb auto-growth
2 Answered Questions
[SOLVED] Should I check for existence of temp tables in Stored Procedures?
- 2014-08-08 14:34:17
- Akash
- 6947 View
- 7 Score
- 2 Answer
- Tags: sql-server sql-server-2012 sql-server-2014 stored-procedures tempdb
2 Answered Questions
[SOLVED] SQL Server tempdb on SSD showing IO
- 2018-05-03 16:18:20
- G Devine
- 666 View
- 8 Score
- 2 Answer
- Tags: sql-server sql-server-2012 tempdb
2 Answered Questions
[SOLVED] TempDB Version Store cleanup
- 2013-07-08 17:07:34
- Cougar9000
- 8350 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
- Rafael Lima
- 1873 View
- 6 Score
- 3 Answer
- Tags: sql-server sql-server-2012 tempdb
1 Answered Questions
How to find which query is causing tempdb growing?
- 2016-09-12 08:24:25
- Gianmatteo Stucchi
- 4415 View
- 2 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
- 29168 View
- 7 Score
- 3 Answer
- Tags: sql-server sql-server-2008 tempdb dbcc-checkdb
3 Answered Questions
[SOLVED] SQL Server 2008 R2 SP1 - Tempdb "Available free space" showing negative value
- 2013-03-27 17:35:35
- Chinesinho
- 10479 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
- 619 View
- 4 Score
- 1 Answer
- Tags: sql-server tempdb
