Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Suggestions on TEMPDB Setup Expand / Collapse
Posted Thursday, March 21, 2013 10:50 AM


Group: General Forum Members
Last Login: Saturday, November 19, 2016 9:49 AM
Points: 193, Visits: 450
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.


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



Group: General Forum Members
Last Login: Tuesday, July 19, 2016 4:34 AM
Points: 2,850, Visits: 4,076
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?

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