Browse by Tags

• Q & A: I can't make SQL Server 2005 32 bit version to use all memory on the machine

  I’m currently using the RTM+SP1 x86-SQL2005 build on a server which has 32GB of physical memory. I notice that during ramp-up the memory usage (as seen under task manager) increases to about 28GB (i.e. “Available memory” reduces to 4GB) and stays there. Read More... Posted Thursday, August 03, 2006 10:41 AM by slavao | 6 Comments Filed under: SQL Server Memory Management, Q&A

• Q and A: Enabling AWE settings for SQL Server 32 bit edition in WOW

  Q. A customer wants to run SQL 2000 SP4 in a Windows Server 2003 SP1 x64 edition. They did the installation without problems but SQL Server is not using more than 4GB of memory. Is it possible to enable AWE in this configuration? A. The answer is yes, Read More... Posted Wednesday, April 12, 2006 2:25 PM by slavao | 1 Comments Filed under: SQL Server Memory Management, Q&A

• Q and A: SQL Server memory allocated outside of Buffer Pool, formerly known as MemToLeave

  Q. Under SQL Server 2000 Is the memtoleave concept still valid under 64-bit? A. Yes. If SQL Server’s component requests memory larger than 8 KB block, the block will be allocated outside of Buffer Pool. Remember, inside of SQL Server, Buffer Pool is preferable Read More... Posted Tuesday, March 14, 2006 2:14 PM by slavao | 2 Comments Filed under: SQL Server Memory Management, Q&A

• Q and A: Do I need to run "sp_configure 'awe enabled', 1" to make 64 bit version of SQL Server use locked pages?

  The answer is No. The source of possible confusion came from one of my previous posts: http://blogs.msdn.com/slavao/archive/2005/11/15/493019.aspx . I apologize for the confusion. In order to make 64 bit version of SQL Server leverage locked pages all Read More... Posted Monday, March 13, 2006 1:44 PM by slavao | 0 Comments Filed under: SQL Server Memory Management, Q&A

• Q and A: Virtual Address Space, VAS, reservation - why bother?

  Seems like today is a question day :-). I will attempt to answer several questions about VAS I got today: Q1. There is one aspect of Virtual Memory that is just not clear yet. I think I understand about VAS, but maybe not as much as I could, but I don’t Read More... Posted Tuesday, November 15, 2005 3:09 PM by slavao | 4 Comments Filed under: SQL Server Memory Management, Q&A

• Q and A: x64 & AWE mechanism

  Today I received following question: Hello, We will be running Windows Server 2003 x64 with SQL Server 2005 x64. I would think AWE would not come into the picture in this scenario. I'm trying to find out more about SQL Server 2005 memory management on Read More... Posted Tuesday, November 15, 2005 1:15 PM by slavao | 11 Comments Filed under: SQL Server Memory Management, Q&A

• Q and A: Controlling size of a single cache in SQL 2005

  Q: I have teaching a class on Yukon for the Ascend program, and the class had a question I wanted to double check before answering. On an Itanium with 1 TB of RAM, the class’ curiosity asked, “If plan cache is very large “Then how does Plan Cache lookups Read More... Posted Friday, June 03, 2005 11:08 AM by slavao | 2 Comments Filed under: SQL Server Memory Management, Q&A