March 12, 2014 at 10:13 am
I have a sql server 2008 r2 server, its min server memory is set to 0, should I change it to at least 1 GB? Thanks.
March 12, 2014 at 10:17 am
Not just for the sake of changing it, no.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 12, 2014 at 10:31 am
Other SQL Servers (same version) all have the min server memory setting changed to 1 GB, that's why I wonder if I should change mine too.
One more question, this is 64-bit server and have 64 GB of RAM, I configure max server memory to 50 GB, but on the task manager, it shows sqlservr.exe use more than 50 GB of RAM. How Do I know if where else the memory is used? Thank you.
March 12, 2014 at 12:30 pm
Grace09 (3/12/2014)
Other SQL Servers (same version) all have the min server memory setting changed to 1 GB, that's why I wonder if I should change mine too.
Maybe find out why the other servers had their settings changed?
One more question, this is 64-bit server and have 64 GB of RAM, I configure max server memory to 50 GB, but on the task manager, it shows sqlservr.exe use more than 50 GB of RAM. How Do I know if where else the memory is used? Thank you.
Don't use Task Manager for SQL's memory.
50GB is the buffer pool. There is additional non-buffer memory for things like the thread stacks, CLR, backup buffers and a few other things
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply