SQL running on an AWS EC2 instance

  • 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

  • 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

  • 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