4 Answered Questions
[SOLVED] How to identify which query is filling up the tempdb transaction log?
- 2012-06-25 14:49:54
- prasanth
- 146132 View
- 61 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
- 53083 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
- 7021 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
- 11752 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
- 19913 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
- 9363 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
- 22778 View
- 18 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
- 1665 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
- 10098 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
- 8179 View
- 4 Score
- 2 Answer
- Tags: sql-server tempdb
1 Answered Questions
[SOLVED] Does RCSI use less or same space than SNAPSHOT? Why?
- 2013-12-13 08:35:34
- Fulproof
- 222 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
- 809 View
- 5 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
- 835 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
- 5310 View
- 11 Score
- 2 Answer
- Tags: sql-server tempdb
2 Answered Questions
[SOLVED] Should I check for existence of temp tables in Stored Procedures?
- 2014-08-08 14:34:17
- Akash
- 5750 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
- 7367 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
- 6186 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
- 931 View
- 6 Score
- 3 Answer
- Tags: sql-server sql-server-2012 tempdb
0 Answered Questions
Why does FREEPROCCACHE let you shrink tempdb?
- 2016-11-07 18:45:26
- James Jenkins
- 1556 View
- 1 Score
- 0 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
- 1630 View
- 1 Score
- 1 Answer
- Tags: sql-server tempdb
3 Answered Questions
[SOLVED] SQL Server 2008 R2 SP1 - Tempdb "Available free space" showing negative value
- 2013-03-27 17:35:35
- Chinesinho
- 10112 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
- 12735 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
- 371 View
- 4 Score
- 1 Answer
- Tags: sql-server tempdb
1 Answered Questions
[SOLVED] SQL Server tempdb on SSD or virtual RAM disc to increase temp-table performance
- 2016-08-04 16:05:46
- headgrowe
- 567 View
- 2 Score
- 1 Answer
- Tags: sql-server sql-server-2014 performance-tuning tempdb
2 Answered Questions
[SOLVED] Allocate space for object 'dbo.SORT temporary run storage
- 2017-01-18 14:43:00
- shamim
- 14418 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
- 3303 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
- 311 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
- 1720 View
- -3 Score
- 2 Answer
- Tags: sql-server optimization tempdb
