How SQL decides how much procedure cache and how much buffer cache to use.
There are two main types of cache which SQL Server deals with, the buffer cache and the procedure cache. The procedure cache is where the execution plans for procedures and queries are storred. The buffer cache is where the actual data is cached so that SQL Server doesn’t have to go to disk to get often accessed data.
Excellent Lock Pages in Memory Blog
Bob Ward of Microsoft has written an excellent blog about the lock pages is memory right over on the PSS blog.
What does the min server memory setting actually mean?
I know that there is some confusion about what exactly the minimum server memory setting in sp_configure actually does. When I was at PASS I was able to ask the Microsoft guys this very question and here is what they told me. The setting does not control how much memory SQL takes when it starts […]
Better Error Reporting for Service Broker
I’ve submitted a request to Microsoft (via the Connect site) to have them improve the error reporting which the Service Broker does to the error log. If everyone could vote for that submission (https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=304785) it would go a long way towards getting it included in a future build of SQL Server.