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

whai is the need of adding T845 oarameter in startup in sql server Expand / Collapse
Author
Message
Posted Monday, November 21, 2011 2:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:27 AM
Points: 316, Visits: 613
Hi,

Please give me the explanation about when to add T845 parameter in start up
for LPM(Lock pages in memory) for 32 bit system
Post #1209655
Posted Monday, November 21, 2011 4:17 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
That flag is for 64 bit. Not sure what effect it would have on a 32bit if any effect at all.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1209716
Posted Tuesday, November 22, 2011 6:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:37 AM
Points: 1,379, Visits: 2,688
c.ajitkumar (11/21/2011)
Hi,

Please give me the explanation about when to add T845 parameter in start up
for LPM(Lock pages in memory) for 32 bit system

-T845 Does nothing for 32bit systems

The trace flag was released to enable 64bit Standard Edition systems to use Lock page in memory.
Post #1210053
Posted Tuesday, November 22, 2011 11:41 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 4:27 AM
Points: 316, Visits: 613
Thanks all for giveing me the answer
Post #1210421
Posted Friday, August 17, 2012 1:35 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 7:44 PM
Points: 7,107, Visits: 12,661
If you're looking for LPIM on a 32-bit system enable AWE (applies to all 32-bit systems, even ones with < 4GB). Adding startup option -T845 is unnecessary on a 32-bit system to enable AWE.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1346731
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse