Welcome to TechNet Blogs Sign in | Join | Help

September 2007 - Posts

Monday, September 24, 2007 11:16 PM

Plan Cache Analysis in SQL Server 2005

Plan Cache: The portion of the memory pool allocated to store Query execution Plan For how much memory is allocated for Plan Cache in different version of SQL server, please refer to my blog: - Understanding Query Plan Cache in SQL 2005 SP2 - why it's
Posted by vishah | 1 Comments
Monday, September 24, 2007 3:18 PM

Understanding Query Plan Cache in SQL 2005 SP2 - why it's changed from SQL 2005 RTM/SP1?

Query execution plan gets stored in Plan Cache - the portion of the memory pool allocated for storing execution plans. There is a very good blog written by SQL Programmability team on why Query Plan Cache behavior changed in SQL 2005 SP2 vs. SQL 2000
Posted by vishah | 1 Comments
Friday, September 14, 2007 3:14 PM

Maximum Capacity Specification for SQL Server 2005 and 2008

I came across this link - http://technet.microsoft.com/en-us/library/ms143432(SQL.100).aspx .  Its amazing to see the max capacity specification for SQL Server.    These are for SQL Server 2008, but they haven't changed from SQL Server
Posted by vishah | 0 Comments
 
Page view tracker