Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Memory   (RSS)
Thursday, September 17, 2009 3:08 PM

How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?

The ring buffer records (which can be sent to XEvent) for Resource Monitor and Memory Broker are the key aspects to understanding RM.  The record is produced when a change is detected in state monitored by RM.    CREATE EVENT SESSION RingBufferInfo
Posted by psssql | 0 Comments
Friday, September 11, 2009 8:40 PM

Fun with Locked Pages, AWE, Task Manager, and the Working Set…

I realize that the topic of “locked pages’ and AWE can be confusing. I don’t blame anyone for being confused on this. I also realize we have blogged and talked about this topic many times perhaps “beating it to death”. And I certainly know this is not
Posted by psssql | 1 Comments
Filed under:
Wednesday, August 26, 2009 8:45 PM

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

I recently saw a question the other day about some errors that indicate memory pressure for the SQL Server Engine and how it might be related to the infamous “MemToLeave” for SQL Server. The problem with this situation was that the errors were happening
Posted by psssql | 0 Comments
Filed under:
Friday, June 05, 2009 3:48 PM

SQL Server and Large Pages Explained….

I gave a presentation on “debugging memory” at the recent Europe PASS Summit in April. In the talk, I mentioned that Large Pages would be used by SQL Server if you used trace flag 834. At the conference, Christian Bolton, a well-known MVP from the UK,
Posted by psssql | 3 Comments
Filed under: ,
Tuesday, May 19, 2009 2:43 PM

An update for Standard SKU Support for Locked Pages….

Note this article has been updated to include an update for SQL Server 2005 I posted in April that we would be releasing cumulative updates for SQL Server 2008 and 2005 to support the concept of Locked Pages for SQL Server Standard. SQL Server 2008 Cumulative
Posted by psssql | 3 Comments
Tuesday, May 12, 2009 5:46 AM

SQL Server reports working set trim warning message during early startup phase

In the previous posts we have discussed the working set trim message “ A significant part of sql server process memory has been paged out ” that gets written to the SQL Server Error log. You can find the details about the various parameters that determine
Posted by psssql | 1 Comments
Thursday, May 07, 2009 3:08 PM

SSIS 2005 and the .NET Garbage Collector

I was troubleshooting an SSIS Out of Memory issue the other day which led us into how the .NET Garbage Collector (GC) works.  When debugging it, I found that we were using the Workstation GC with Concurrent GC On (this is the default for .NET applications). 
Posted by psssql | 1 Comments
Friday, April 24, 2009 12:14 PM

SQL Server, Locked Pages, and Standard SKU…

I made an announcement today while speaking at Europe PASS 2009 that we will be providing a method for customers using standard SKU for SQL Server 2005 and 2008 to use the ‘Locked Pages in Memory’ privilege to allow the server to use the AWE APIs. This
Posted by psssql | 10 Comments
Wednesday, January 07, 2009 8:04 PM

Installing SQL Server 2005 SP3 or SQL Server 2008 on builds prior to XP SP3 Can lead to Bug Check (0xF4, Blue screen, Critical Process Termination)

Due to a bug in Windows XP builds prior to the XP SP2 hot fix or XP SP3 release you may encounter one of the following bugs while attempting to install SQL Server 2008 or SQL Server 2005 SP3 based builds. An application that uses the Sxs.dll file crashes
Posted by psssql | 1 Comments
Monday, June 16, 2008 5:20 AM

Query Performance issues associated with a large sized security cache

In the past couple of months, SQL Server support team has come across some customers running into performance issues attributed to TokenAndPermUserStore in SQL Server 2005. This blog post attempts to compile all the information we have so far regarding
Posted by psssql | 4 Comments
Saturday, April 05, 2008 6:04 PM

SQL Server 2005 Memory Limits and Related Questions

I had a very nice conversation this week with one of the blog readers.   The question related to adding more memory to their server.   It lead to an exchange of various links that I think you might find handy.  We discussed the
Posted by psssql | 0 Comments
Monday, March 03, 2008 3:41 PM

SQL Server Working Set Trim Problems? - Consider...

Microsoft support continues to receive a steady flow of cases indicating poor, SQL Server performance symptoms.   When the issue is narrowed down we are finding that the working set of SQL Server and many of the processes on the computer have
Posted by psssql | 9 Comments
Filed under: , ,
Thursday, January 24, 2008 6:38 PM

How It Works: SQL Server 2005 NUMA Basics

The Senior Escalation Engineers do various training and mentoring activities.  As I do this I thought I would try to propagate some of this information on the blog. I have received several questions on the SQL Server NUMA implementation this week.
Posted by psssql | 1 Comments
Filed under: , , ,
Thursday, January 10, 2008 8:59 AM

SQL Server 2008 - Resource Governor Questions

A couple of common questions have surfaced related to the SQL Server 2008 Resource Governor feature. The SQL Server 2008 BOL has a lot of good information so start don't forget to review that as well. Metadata and Runtime Data A set of DMVs exist for
Posted by psssql | 1 Comments
Filed under: , ,
Thursday, October 18, 2007 3:46 PM

Do I have to assign the Lock Pages in Memory privilege for Local System?

IMPORTANT: The following KB article adds support for Locked Pages to SQL Server Standard Edition http://support.microsoft.com/kb/970070 NOTE: I've updated this because of some questions about 32bit systems. Some who attended one of my talks at the recent
Posted by psssql | 11 Comments
Filed under: ,
 
Page view tracker