No announcements
Found 87860 threads
-
2 VotesHuge Tempdb usage
You canincrease tempdb performance by disabling the auto update stats, which will save your tempdb some work.Answered | 11 Replies | 3159 Views | Created by RANJITH ROUTHU - Friday, June 24, 2016 7:18 PM | Last reply by JRStern - Sunday, June 26, 2016 4:07 PM
-
0 Votes
Tempdb usage
Troubleshooting Insufficient Disk Space in tempdb.Answered | 2 Replies | 2010 Views | Created by Nibras33 - Tuesday, November 27, 2012 6:51 PM | Last reply by Rama Udaya - Tuesday, November 27, 2012 7:05 PM -
0 Votes
tempdb Transaction file log usage
select * from ::fn_virtualfilestats( 2, 2 )--log -- This DMV query shows currently executing tasks and -- tempdb space ...Answered | 2 Replies | 1435 Views | Created by Tharindu Dhaneenja - Tuesday, November 4, 2014 6:08 AM | Last reply by Uri Dimant - Tuesday, November 4, 2014 6:39 AM -
0 Votes
SQL Reporting Services tempdb usage
The SQL Server Instance has a differente temp database called Tempdb which is used for store temporary data used by the SQL Server Database engine, so lets say you have ...Answered | 2 Replies | 7393 Views | Created by ian1489 - Friday, June 1, 2012 7:28 PM | Last reply by ian1489 - Monday, June 4, 2012 11:52 AM -
0 Votes
Locking And Excessive TempDB Usage
More information: Four Tips for SQL Tuning for SharePoint Part 3 ...Answered | 2 Replies | 1032 Views | Created by SlightlyDave - Wednesday, September 2, 2015 10:05 PM | Last reply by SlightlyDave - Tuesday, September 8, 2015 6:20 PM -
4 Votes
TempDB
I have a server with a 300GB database that has a 4GB tempdb, and I have one with a 80GB database with a 16GB tempdb.Answered | 24 Replies | 9253 Views | Created by soussou123 - Tuesday, May 5, 2009 7:04 AM | Last reply by soussou123 - Monday, May 18, 2009 9:48 AM -
0 Votes
tempdb files
initial datafile size 2MB, I modified I tempdb initial datafile size to 20MB after restart, sp_helpfile shows use ...Answered | 8 Replies | 5164 Views | Created by Ryan_XH - Tuesday, June 7, 2011 5:24 PM | Last reply by aG_ - Tuesday, June 7, 2011 7:52 PM -
0 Votes
TempDB and SSRS
Your tempdb grows because of transactions caused by the Stored Procedures that input data to the reports.Answered | 4 Replies | 2853 Views | Created by Steve Hawkes - Wednesday, August 19, 2015 3:45 PM | Last reply by Kumar muppa - Thursday, August 20, 2015 4:23 AM -
0 Votes
Tempdb- Disk size Requirement for Tempdb Database?
Hi, Size of the tempdb depends on various factors.Answered | 6 Replies | 7828 Views | Created by -kit - Wednesday, March 26, 2014 9:42 PM | Last reply by ACDBA - Thursday, March 27, 2014 8:37 PM -
4 Votes
Shrink tempdb
Hallo asdfasdfsadfsadsddfsdf, I would not recommend to shrink tempdb.Answered | 6 Replies | 8242 Views | Created by asdfghjkl_asdfghjkl - Thursday, September 15, 2011 9:09 AM | Last reply by Uwe Ricken - Thursday, September 15, 2011 1:47 PM -
0 Votes
Tempdb
Reason for removing temp data files: we are facing performance issues on tempdb & IO level.Answered | 4 Replies | 638 Views | Created by RANJITH ROUTHU - Thursday, July 7, 2016 9:16 PM | Last reply by Andrea Caldarone - Friday, July 8, 2016 9:12 AM -
0 Votes
TempDB
Also, check the ...Answered | 3 Replies | 2312 Views | Created by Surya.chamala - Saturday, September 14, 2013 6:38 PM | Last reply by Sarat (SS) - Sunday, September 15, 2013 1:06 AM -
1 Votes
Tempdb
Hi Baskar Lakshmi, Check out the following link on my blog, that discusses how to recover from out-of-disk space conditions for tempdb and how you can prevent this ...Answered | 7 Replies | 2443 Views | Created by Baskar Lakshmi - Thursday, August 16, 2012 11:19 AM | Last reply by Santhosh H - Thursday, August 16, 2012 12:33 PM -
0 Votes
Tempdb
see here Jon nicely explained - What is the best practice for configuring tempdb?Answered | 6 Replies | 2194 Views | Created by WatchmanX - Monday, April 29, 2013 9:17 PM | Last reply by Harsh Chawla - Tuesday, April 30, 2013 8:09 AM -
1 Votes
Monitoring tempdb
If you want to monitor the usage of tempdb, you could use this script : DECLARE @runtime datetime SET @runtime = ...Answered | 2 Replies | 3058 Views | Created by MrFlinstone - Tuesday, January 17, 2012 1:58 PM | Last reply by Harsh Chawla - Tuesday, January 17, 2012 2:01 PM -
0 Votes
Tempdb management
That will help in unnecessary maintenance and efficient usage of space.Answered | 7 Replies | 5136 Views | Created by vahdam_mn - Tuesday, March 9, 2010 3:53 AM | Last reply by SQLEnthusiast - Monday, March 15, 2010 5:42 AM -
0 Votes
Tempdb
You cant drop tempdb, if you try to drop database it will throw error tempdb is system database 2.Answered | 7 Replies | 1967 Views | Created by SLNSH - Wednesday, March 13, 2013 10:54 AM | Last reply by Saurabh Sinha DBA - Wednesday, March 13, 2013 1:39 PM -
5 Votes
shrink tempdb
sys.dm_db_session_space_usage andAnswered | 5 Replies | 1201 Views | Created by Zeal DBA - Monday, June 10, 2019 8:41 AM | Last reply by Dedmon Dai - Tuesday, June 11, 2019 7:10 AM -
0 Votes
TempDb and TOP (n)
Hi sqljoker, You can check the CPU usage for TOP(n).Answered | 3 Replies | 2512 Views | Created by sqljoker - Wednesday, October 10, 2012 3:46 PM | Last reply by ShubhashChandra - Monday, October 15, 2012 3:54 PM -
0 Votes
Tempdb is not getting shrink
If your workload needs 250 GB of tempdb, it needs 250 GB of tempdb.Answered | 18 Replies | 2564 Views | Created by Chetan Vishwakarma - Thursday, September 1, 2016 1:31 PM | Last reply by S_NO - Friday, September 2, 2016 11:15 AM - Items 1 to 20 of 87860 Next ›
No announcements
