March 13, 2014 at 4:26 pm
How much memory is too much memory? Will that cause bad performance? I want to check how much max memory can be allocated on sql server 2008/2005.How can you check that?
Thanks
March 13, 2014 at 4:56 pm
All the memory is not too much. SQL Server has limits to the amount of memory it can use. You can see that here in the documentation. You'll want to set the max memory for the instance so that you leave memory for the operating system. There are a number of settings in and around memory you'll want to look at, again, the documentation. For actual recommendations on setting memory configurations, here's a good article [/url]by Jonathan Kehayias.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply