Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Memory   (RSS)
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 | 3 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 | 2 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?

NOTE: I've updated this because of some questions about 32bit systems. Some who attended one of my talks at the recent PASS conference asked me the following question "Do I need to use the Group Policy Editor to assign the Lock Pages in Memory privilege
Posted by psssql | 8 Comments
 
Page view tracker