February 23, 2018 at 1:31 pm
I was curious...are things like "lock pages in memory" and "perform volume level tasks" necessary for SQL Servers that are running on an EC2 instance in AWS? I turned them on out of habit, but was just wondering...is it even necessary? A quick Google search really didn't turn up anything so thought of checking here to see if anyone else has though wondered the same...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
February 27, 2018 at 4:35 pm
You have to look after the EC2 instance like any other virtual machine running SQL Server. So, depending on the version of SQL Server I would definitely set perform volume maintenance - for instant file initialization and if you set Lock pages in memory on other instances I would set it here too...
I would treat an EC2 instance like a normal server I was managing and maintaining.
Gethyn Elliswww.gethynellis.com
February 28, 2018 at 10:14 am
Thanks, this is what I thought but wanted to make sure I wasn't missing the obvious.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply