Trace Flag 834

Question

Post reply

Trace Flag 834

cheshirefox

Hall of Fame

Points: 3464
More actions
April 28, 2011 at 7:36 am

#239235

Anyone using trace flag 834 in production?
Had a call with a major server manufacturer. Due to performance degradation issues on the server, they are recommending we add -T834 to the SQL startup parameters.
Trace flag 834 causes SQL Server to use Microsoft Windows large-page allocations for the memory that is allocated for the buffer pool.
We already have Lock pages in memory configured with the correct service accounts.
Thanks in advance.

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

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Perhaps the following articles may be helpful to your situation:

http://narfle.com/blog/labels/SQL%20Server.asp/

http://blogs.technet.com/b/sql_server_isv/archive/2010/11/30/trace-flag-834-and-when-to-use-it.aspx

http://blogs.msdn.com/b/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Johan Bijnens SSC Guru Points: 135550 More actions · Answer 2

Some state this setting is only for 64-bit.

http://msdn2.microsoft.com/en-us/library/aa366720.aspx

states "?WOW64 on Intel Itanium-based systems does not support 32-bit applications that use this feature. The applications should be recompiled as native 64-bit applications."

Chances are this may work on 32-bit, but .... to what price ?

( with 64-bit they even advise having more than 8GB ram )

Keep in mind your non sqlserver stuff also needs ram to be able to do its stuff (OS/sqlagent, ...)

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Syed Jahanzaib Bin hassan SSChampion Points: 11410 More actions · Answer 3

This flag is use for large page allocation from 2 to 16 MB

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

My Blog
www.aureus-salah.com