Bob Ward of Microsoft has written an excellent blog about the lock pages is memory right over on the PSS blog.Contact the Author | Contact DCAC
|Published On: 2007-10-18||By: Denny Cherry|
|Published On: 2007-10-17||By: Denny Cherry|
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 up. What it controls is a low watermark as to how much memory SQL will keep.
For example if you have 2 Gigs of memory installed, and a min memory setting on 1024 MB and a max memory setting of 1536 MB and Windows starts telling SQL that it needs more memory SQL will give the memory back until it hits the 1024 MB lower limit. Once it hits that limit it will no longer give memory back to Windows.
DennyContact the Author | Contact DCAC
|Published On: 2007-10-15||By: Denny Cherry|
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.Contact the Author | Contact DCAC
|Published On: 2007-10-11||By: Denny Cherry|
While waiting for an index to be created I ran across this little beauty over at http://xkcd.com. I just had to share it.
Contact the Author | Contact DCAC