question

pradnyag41 avatar image
pradnyag41 asked

How does Trace 834 works in sql server?

1) How does Trace 834 works in sql server? 2) Why its not holding memory in bufferpool with large page allocation and trace834? 3) How does it manages bufferpool memory with large page allocation.?
memory-utilizationtrace-flags
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
The precise internals are only available to Microsoft. The general definitions are [available here][1] in the documentation. A more detailed explanation is [available here][2]. If you're still seeing lots of spills from memory, it could be that you're not running a 64bit machine, that you just don't have enough memory, or that your queries are extremely large (not enough memory again). Hard to say with the information supplied. [1]: http://support.microsoft.com/kb/920093 [2]: http://blogs.msdn.com/b/psssql/archive/2009/06/05/sql-server-and-large-pages-explained.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.