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: Yesterday @ 10:01 PM
Points: 314, Visits: 611
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:26 PM
Points: 21,629, Visits: 15,286
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: 2 days ago @ 5:58 AM
Points: 1,375, Visits: 2,663
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: Yesterday @ 10:01 PM
Points: 314, Visits: 611
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: Yesterday @ 7:08 PM
Points: 7,097, Visits: 12,599
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