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, December 17, 2014 2:19 AM
Points: 323, Visits: 619
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: 2 days ago @ 3:20 PM
Points: 18,064, Visits: 16,099
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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: Thursday, December 18, 2014 12:03 AM
Points: 1,380, Visits: 2,708
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, December 17, 2014 2:19 AM
Points: 323, Visits: 619
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: Thursday, December 18, 2014 8:51 PM
Points: 7,140, Visits: 12,763
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