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 «««123

Poor Man's Enterprise Feature - Lock Pages in Memory Expand / Collapse
Author
Message
Posted Monday, September 20, 2010 11:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 11,194, Visits: 11,137
Charles Hottle (9/20/2010)
Is this update required for an environment running SQL Server 2008 SP1 Standard 32-bit using AWE and PAE in order for Lock Pages in Memory to be functional? I only see 64-bit referenced in the various posts that I've seen. Thanks.

No the update is for 64-bit only.
See http://blogs.msdn.com/b/psssql/archive/2009/09/11/fun-with-locked-pages-awe-task-manager-and-the-working-set.aspx




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #989586
Posted Saturday, September 25, 2010 4:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 10, 2013 11:15 AM
Points: 14, Visits: 36
When adding the -T846 where exactly do add the parameter at the very begining? Can you please show an
example, it would be well appreciated.

Thank you
Post #993308
Posted Saturday, September 25, 2010 5:46 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 11,194, Visits: 11,137
brown-415622 (9/25/2010)
When adding the -T846 where exactly do add the parameter at the very begining? Can you please show an example, it would be well appreciated.

The trace flag is 845 not 846.

You need 2005 64-bit Standard at least SP3 + Cumulative Update 4, or 2008 64-bit Standard at least SP1 + Cumulative Update 2:
http://support.microsoft.com/kb/970070

Here is a link showing how to set it as a start-up option:
http://blogs.msdn.com/b/psssql/archive/2010/02/19/did-you-start-your-sql-server-engine-correctly.aspx

How to know your system is now using Locked Pages successfully:
http://blogs.msdn.com/b/psssql/archive/2007/10/18/do-i-have-to-assign-the-lock-privilege-for-local-system.aspx

How to configure start-up options (general info):
http://msdn.microsoft.com/en-us/library/ms345416.aspx

Using start-up options:
http://msdn.microsoft.com/en-us/library/ms190737.aspx




Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #993315
Posted Saturday, September 25, 2010 6:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 10, 2013 11:15 AM
Points: 14, Visits: 36
I have read all the documentation my issue is I'm not sure where to put the -T845 parameter
at startup.


-ll:\masterdb\mastlog.ldf;-el:\LOG\ERRORLOG;-dl:\masterdb\master.mdf

Does it go at the begining? I keep getting an error when restart SQL service.

running 64 bit standard 2005 with cumm patch 11.

Thanks
Post #993321
Posted Saturday, September 25, 2010 6:46 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 11,194, Visits: 11,137
brown-415622 (9/25/2010)
I have read all the documentation my issue is I'm not sure where to put the -T845 parameter at startup.Thanks

Well excuse me! You didn't give that impression by quoting the wrong number
It goes at the end.
edit: exactly as shown in the picture in the link I gave: http://blogs.msdn.com/b/psssql/archive/2010/02/19/did-you-start-your-sql-server-engine-correctly.aspx





Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #993322
Posted Sunday, September 26, 2010 12:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 10, 2013 11:15 AM
Points: 14, Visits: 36
Thanks for your help, it worked.
Post #993388
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse