Welcome to MSDN Blogs Sign in | Join | Help

July 2009 - Posts

SQL Server 2005 performance problems due grow of TokenAndPermUserStore cache
TokenAndPermUserStore is one of the many caches present in the SQL Server 2005 memory architecture. As the name implies, this cache stores various security related information used by the SQL Server Engine. To find out the amount of memory consumed by Read More...
How to reduce paging of buffer pool memory in the 64-bit SQL Server 2005 Standard version of SQL Server
SQL Server 2005 SP2 introduces a new warning message that indicate that working set (RAM resident portion of SQL Server) has been paged out. This is a common problem that points to excessive paging that leads to potential severe performance problems. Read More...
Page view tracker