June 11, 2010 at 9:45 am
SQL Server 2005, SP 2, 64-bit, 14 GB RAM, Min Server Memory = 5632, Max Server Memory = 8192
When you configure Min Server Memory and Max Server Memory does that apply to all SQL Server 2005 services (SQL Server, Analysis Server, SSIS, SQL Agent etc.) or does it only apply to SQLServr.exe?
June 11, 2010 at 12:01 pm
No, this setting is for SQL Server only, not SSIS, SSRS, SSAS and other features.
You must configure "max server memory" to leave memory for these services the same way that you would to leave memory for IIS, OS and other applications that runs on the server.
June 11, 2010 at 2:43 pm
Thanks Nils
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply