benjamin.reyes (11/23/2015)
Grant Fritchey (11/23/2015)
I'm pretty much with Gail. Just because it says it's using 98% of memory doesn't mean there's anything approaching a problem.If you do know that the batch is a problem, then you need to address the batch. Flipping memory settings is unlikely to do anything about the batch issues.
Unless the setting is allocating 200+ more GB of ram. 😀
Well, you got me there. That's a cool setting to have.
"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