Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

all information about SQL “Memory To Leave” area (also called MTL or “Memory To Reserve”).

Posted by Simon Cho on 03/07/2011

The Database Administrator’s Guide to the SQL Server Database Engine .NET Common Language Runtime Environment
http://www.sqlskills.com/resources/Whitepapers/SQL%20Server%20DBA%20Guide%20to%20SQLCLR.htm

If you use linked server queries, you need to read this….
http://blogs.msdn.com/psssql/archive/2009/09/22/if-you-use-linked-server-queries-you-need-to-read-this.aspx

How It Works: DBCC MemoryStatus Locked Pages Allocated and SinglePageAllocator Values
http://blogs.msdn.com/psssql/archive/2009/05/15/how-it-works-dbcc-memorystatus-locked-pages-allocated-and-singlepageallocator-values.aspx

I had log backup jobs setup which started to fail intermittently for last couple of weeks. The SQL server complained of “insufficient system memory”. The jobs were backed up as part of maintenance plan – maxtransfersize option
http://www.sqlservercentral.com/Forums/Topic362968-24-1.aspx

How to find who is using / eating up the Virtual Address Space on your SQL Server
http://blogs.msdn.com/sqlserverfaq/archive/2010/02/16/how-to-find-who-is-using-eating-up-the-virtual-address-space-on-your-sql-server.aspx

VirtualAlloc Function
http://msdn.microsoft.com/en-us/library/aa366887%28VS.85%29.aspx

SQL Server encounters memory pressure and generate 701 Error due to incorrect configuration of Service Broker
http://blogs.msdn.com/sqlserverfaq/archive/2010/03/25/sql-server-encounters-memory-pressure-and-generate-701-error-due-to-incorrect-configuration-of-service-broker.aspx

SQLOS’s memory manager and SQL Server’s Buffer Pool
http://blogs.msdn.com/slavao/archive/2005/02/11/371063.aspx

FAIL_VIRTUAL_RESERVE
http://www.sqlservercentral.com/Forums/Topic432976-360-1.aspx

Fix for “Failed Virtual Allocate Bytes” error? – Service Broker problem
http://social.msdn.microsoft.com/Forums/en/sqlservicebroker/thread/1d527f9e-5497-4e02-a2b2-f0ee3a386326

FIX: Error message when you use SQL Server Service Broker in SQL Server 2005: “Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 589824”
http://support.microsoft.com/default.aspx?scid=kb;en-us;959007

INF: Using DBCC MEMORYSTATUS to Monitor SQL Server Memory Usage
http://support.microsoft.com/kb/271624

Server Memory Options
http://msdn.microsoft.com/en-us/library/ms178067.aspx

Various memory errors are logged to SQL Server error log when using SQL CLR objects
http://support.microsoft.com/kb/969962

FIX: The memory usage of a SQL Server service increases quickly when you run a query that uses a linked server in SQL Server 2005 or in SQL Server 2008
http://support.microsoft.com/kb/971622

AppDomain marked for unload due to memory pressure- Jonathan Kehayias

http://social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/e5ca2988-df87-4ce4-8fb7-b338a81a390e

help with this AppDomain event- Jonathan Kehayias

http://social.msdn.microsoft.com/forums/en-US/sqlnetfx/thread/cc1b3e43-0db8-4e75-b5ab-bc2a4c93b12b/

SQL Server 2005: CLR Integration

http://blogs.msdn.com/sqlclr/archive/2006/03/24/560154.aspx

Using the SQL Server Service Startup Options
http://msdn.microsoft.com/en-us/library/ms190737.aspx

Come on 64bit so we can leave the mem…. – Bob Ward

http://blogs.msdn.com/b/psssql/archive/2009/08/26/come-on-64bit-so-we-can-leave-the-mem.aspx

 

Simon Cho

Advertisements

2 Responses to “all information about SQL “Memory To Leave” area (also called MTL or “Memory To Reserve”).”

  1. Fran said

    Recently we encountered memory on our x64 SQL 2008 R2 server. Your site covers lots of the errors we have. Thank you so much for putting them in one place!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: