Browse by Tags

• Configuration
• Database Administration
• Internals
• TSQL2sday

• TSQL Tuesday #11 Misconceptions – Enable AWE on 64bit SQL Servers

  This post is part of the monthly community event called T-SQL Tuesday started by Adam Machanic ( blog | twitter ) and hosted by someone else each month. This month the host is Sankar Reddy ( blog | twitter ) and the topic is Misconceptions in SQL Server Read More... Posted Tuesday, October 12, 2010 1:58 PM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, Memory Allocation, Internals, Configuration, TSQL2sday

• Troubleshooting the SQL Server Memory Leak (or Understanding SQL Server Memory Usage)

  Learn how SQL Server allocates and uses the physical memory available on a server, as well as why SQL Server doesn't release memory like most other applications. Read More... Posted Monday, August 24, 2009 10:32 PM by Jonathan Kehayias | 10 Comments Filed under: Database Administration, Memory Allocation, Internals

• Understanding the VAS Reservation (aka MemToLeave) in SQL Server

  For a long time now I've had a Word Document I was working on to cover the subject of the VAS Reservation (aka MemToLeave) in SQL Server. I've been quite busy this year, so I never got around to completing it, and I wasn't sure of where I wanted to publish Read More... Posted Tuesday, July 07, 2009 2:41 AM by Jonathan Kehayias | 22 Comments Filed under: Database Administration, Memory Allocation