Post reply

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

  • November 21, 2011 at 2:40 pm

    #248145

    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

  • November 21, 2011 at 4:17 pm

    #1411106

    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[/url]
    Learn Extended Events

  • November 22, 2011 at 6:09 am

    #1411395

    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.

  • November 22, 2011 at 11:41 am

    #1411726

    Thanks all for giveing me the answer

  • August 17, 2012 at 1:35 pm

    #1527236

    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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply