SQL Server with Mr. Denny:

Windows Computing

1

February 11, 2008  8:00 AM

Getting those memory setting in SQL Server just right.



Posted by: Denny Cherry
Config, Microsoft Windows, RAM, SQL, Windows Computing

When using 64bit SQL Server getting the memory settings right is pretty easy.  Simply set the maximum to what you want and you are good to go. Getting them right in the 32bit versions of SQL Server is a bit harder.  You have to deal with the OS level of enabling the Physical Address Extensions...

October 17, 2007  5:46 PM

What does the min server memory setting actually mean?



Posted by: Denny Cherry
SQL, Windows Computing

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...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: