whai is the need of adding T845 oarameter in startup in sql server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » whai is the need of adding T845 oarameter in...

whai is the need of adding T845 oarameter in startup in sql server

Rate Topic

Display Mode

Topic Options

Author

Message

c.ajitkumar

Posted Monday, November 21, 2011 2:40 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:56 AM
Points: 295, Visits: 491

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

SQLRNNR

Posted Monday, November 21, 2011 4:17 PM

SSCoach

Group: General Forum Members
Last Login: Thursday, May 16, 2013 1:46 PM
Points: 18,732, Visits: 12,329

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 2008

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

SQLSACT

Posted Tuesday, November 22, 2011 6:09 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,185, Visits: 2,099

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

c.ajitkumar

Posted Tuesday, November 22, 2011 11:41 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:56 AM
Points: 295, Visits: 491

Thanks all for giveing me the answer

Post #1210421

opc.three

Posted Friday, August 17, 2012 1:35 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 6,696, Visits: 11,713

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1346731

« Prev Topic | Next Topic »

Permissions