May 7, 2014 at 10:04 pm
I'm currently setting up a 2012 AoHA cluster in Windows Azure and looking for advice/recommendations around Lock Pages in Memory.
Is there any recommendation out there regarding assigning this to the SQL Service Account? If not what is the general opinion?
Leo
Nothing is ever so complex that with a little bit of work it can't be made more complex.
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
May 8, 2014 at 3:05 am
Jonathan's advice here [/url]would still be completely applicable to virtual machines, whether they're running in the cloud or not.
"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
May 14, 2014 at 9:38 pm
Grant Fritchey (5/8/2014)
Jonathan's advice here [/url]would still be completely applicable to virtual machines, whether they're running in the cloud or not.
Within reason this is true however the virtualised environment Jonathan's article covers allows for some control over things like the Balloon driver and over allocation of RAM. In the Cloud we have no control over this. In principle I would say this increases the requirements to set LPIM, but also makes it more important to monitor memory usage, particularly the OS space.
What I was hoping was that someone would actually have played in this space, or there might be a Microsoft article covering this. So far nothing has come to light.
Jonathan's article is very good, but I noticed it was written pre Windows 2012 and SQL Server 2012, and it would be good to have current examples and information on which to base a decision.
For now LPIM is enabled. We'll see how this goes.
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply