4 Answered Questions
[SOLVED] How to identify which query is filling up the tempdb transaction log?
- 2012-06-25 14:49:54
- prasanth
- 148649 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
- 53966 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
- 7210 View
- 6 Score
- 1 Answer
- Tags: sql-server sql-server-2005 tempdb tempdb-version-store
2 Answered Questions
[SOLVED] Issues with TempDB mdf file ever increasing
- 2014-01-13 19:56:24
- nightmareivy
- 11991 View
- 6 Score
- 2 Answer
- Tags: sql-server sql-server-2005 tempdb
2 Answered Questions
[SOLVED] Find which session is holding which temporary table
- 2014-03-25 15:35:08
- SQLMIKE
- 20398 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
- 9426 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
- 23096 View
- 19 Score
- 3 Answer
- Tags: sql-server sql-server-2008-r2 tempdb
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
- 1771 View
- 3 Score
- 1 Answer
- Tags: sql-server sql-server-2014 tempdb process
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
- 10127 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
- 8500 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
- 849 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
- 225 View
- 6 Score
- 1 Answer
- Tags: sql-server transaction tempdb snapshot-isolation tempdb-version-store
1 Answered Questions
[SOLVED] Tempdb Add files require Restart
- 2018-06-28 16:09:31
- user129291
- 1117 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
- 55 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
- 5760 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
- 454 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
- 3867 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
- 5919 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
- 7444 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
- 6360 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
- 1010 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
- 1884 View
- 1 Score
- 1 Answer
- Tags: sql-server tempdb
0 Answered Questions
Why does FREEPROCCACHE let you shrink tempdb?
- 2016-11-07 18:45:26
- James Jenkins
- 1768 View
- 1 Score
- 0 Answer
- Tags: tempdb shrink cache dbcc plan-cache
3 Answered Questions
[SOLVED] SQL Server 2008 R2 SP1 - Tempdb "Available free space" showing negative value
- 2013-03-27 17:35:35
- Chinesinho
- 10154 View
- 7 Score
- 3 Answer
- Tags: sql-server sql-server-2008 tempdb
2 Answered Questions
[SOLVED] TempDB will not shrink. No Open Transactions
- 2014-08-06 16:27:43
- user45117
- 13334 View
- 6 Score
- 2 Answer
- Tags: sql-server-2008 tempdb shrink
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
- 397 View
- 4 Score
- 1 Answer
- Tags: sql-server tempdb
2 Answered Questions
[SOLVED] Allocate space for object 'dbo.SORT temporary run storage
- 2017-01-18 14:43:00
- shamim
- 16001 View
- 1 Score
- 2 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
- 3507 View
- 1 Score
- 1 Answer
- Tags: sql-server sql-server-2014 tempdb datafile
1 Answered Questions
[SOLVED] Risks associated with automatically shrinking TempDB as a SQL agent job?
- 2017-05-15 07:02:20
- Cenderze
- 345 View
- 0 Score
- 1 Answer
- Tags: sql-server sql-server-2016 tempdb shrink
2 Answered Questions
[SOLVED] How to improve TempDb on RAMDisk showing performance on par with physical hard drive
- 2013-08-02 23:56:12
- crokusek
- 1732 View
- -4 Score
- 2 Answer
- Tags: sql-server optimization tempdb
