Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Suggestions on TEMPDB Setup Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 10:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, May 4, 2014 11:25 AM
Points: 176, Visits: 406
Can someone look into this article and let me know is it really good to set tempdb auto growth ENABLED. It's just wondering me.

"http://msdn.microsoft.com/en-us/library/ms175527.aspx"

I am planning to allocate a separate drive for Tempdb data and log files with autgrowth disabled by adjusting size to 85% of the drive.
Post #1433912
Posted Friday, March 22, 2013 5:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 12:26 AM
Points: 2,840, Visits: 3,963
DBA_Learner (3/15/2013)
I have a teradata environment with database aroudn 3TB. This server has around 40 core processors. Microsoft suggested to Use only 32 processors instead of 40 as there was a bug.
can we restrict the machine to use some limited cores (like 32 instead of 40). ? This is new to me.Any reference of link or related article?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1434198
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse