{"id":11139,"date":"2011-04-05T11:52:53","date_gmt":"2011-04-05T11:52:53","guid":{"rendered":"https:\/\/aidanfinn.com\/?p=11139"},"modified":"2011-04-05T11:52:53","modified_gmt":"2011-04-05T11:52:53","slug":"sql-server-and-hyper-v-dynamic-memory","status":"publish","type":"post","link":"https:\/\/aidanfinn.com\/?p=11139","title":{"rendered":"SQL Server and Hyper-V Dynamic Memory"},"content":{"rendered":"

Lots of us are accidential DBAs.\u00a0 In other words, we’re not DBAs officially, but SQL has made it’s way onto a large number of servers (or VMs) because of application requirements, e.g. System Center.<\/p>\n

SQL is one of those applications that\u00a0can be memory hungry and pretty damned hard to size.\u00a0 That might just make it a perfect case for enabling Dynamic Memory on Hyper-V hosts, a feature of W2008 R2 SP1.<\/p>\n

The SQLOS blog posted a series of 3 articles on Dynamic Memory and SQL.\u00a0 I strongly recommend you read it … even if you don’t count yourself as a DBA.<\/p>\n

    \n
  1. \u00a0<\/span>SQL Server and Hyper-V Dynamic Memory – Part 1<\/a>\u00a0– Understanding Dynamic Memory<\/li>\n
  2. \u00a0<\/span>SQL Server and Hyper-V Dynamic Memory Part 2<\/a>\u00a0– Understanding how SQL deals with memory<\/li>\n
  3. \u00a0<\/span>SQL Server and Hyper-V Dynamic Memory Part 3<\/a>\u00a0– Guidelines for configuring Dynamic Memory for SQL VMs<\/li>\n<\/ol>\n

    By the way, SQL 2005 and later Enterprise and Datacenter editions are required to take advantage of Dynamic Memory in SQL VMs.\u00a0 This is because the lower editions (Express, Standard, Web and Workgroup) don’t\u00a0support hot-add memory, something that was the domain of high end hardware prior to Dynamic Memory.\u00a0 That’s unfortunate\u00a0because those lower editions are likely what you have P2Vd from previous physical installs, and it isn’t uncommon to see SQL Web being deployed in a hosting environment (\u20ac11\/month VS \u20ac260\/month or more per CPU for a higher edition).<\/p>\n

    SQL vNext (codename Denali) is probably going to allow the Standard edition to support Dynamic Memory.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Lots of us are accidential DBAs.\u00a0 In other words, we’re not DBAs officially, but SQL has made it’s way onto a large number of servers (or VMs) because of application requirements, e.g. System Center. SQL is one of those applications that\u00a0can be memory hungry and pretty damned hard to size.\u00a0 That might just make it … Continue reading “SQL Server and Hyper-V Dynamic Memory”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_wpcom_ai_launchpad_first_post":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11139","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t