Trace Flag 845 OS Dependent?

• Feeg

  SSCrazy

  Points: 2766

  More actions

  November 8, 2012 at 2:51 am

  #269975

  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 SQL Server 2008
  MCP SQL 2012/2014
  MCSA SQL Server 2012/2014
  MCSE Data Management and Analytics

• bleroy

  Hall of Fame

  Points: 3052

  More actions

  November 8, 2012 at 3:09 am

  #1557069

  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