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

Trace Flag 845 OS Dependent? Expand / Collapse
Author
Message
Posted Thursday, November 8, 2012 2:51 AM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, August 14, 2014 2:52 AM
Points: 127, Visits: 1,747
http://www.sqlservercentral.com/articles/trace+flags/70131/
This Trace flag is specifically for 64bit 2005/2008 non Enterprise and Developer edition ...
Is this OS dependent? meaning 2000, 2003, 2008, 2012? Server 64bit versions?


MCITP: Database Administrator 2005
MCTS DBA 2008
Post #1382352
Posted Thursday, November 8, 2012 3:09 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, September 4, 2014 2:51 AM
Points: 167, Visits: 683
Not dependant on the OS as such - however keep in mind that the max memory that can be used on Windows Server 2003 is 512 GB; and on Windows Server 2003 Service Pack 1, the limitation is 1 terabyte. When Windows supports additional memory, SQL Server can use more of the memory (up to max memory allocated to SQL Server).

B
Post #1382357
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse