Resources on using Windows System Resource Manager to manage multiple instances of SQL Server

Question

question

keithwiggans asked Feb 1, '16

Resources on using Windows System Resource Manager to manage multiple instances of SQL Server

Apparently you can configure Windows System Resource Manager to manage the allocation of resources between different SQL Server instances on a server, but I have not run across any detailed instructions on the steps involved, or any examples videos of someone doing this. We'll be working on Windows Server 2012, so any information on Windows Server 2008 R2 and above would work fine. Could someone point me to one or more resources for this?

sql-server windows-server-2008-r2 resources manager

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Feb 08, 2016 at 08:01 PM

You have some good answers below. This web site runs by you voting and marking the best answers. For each helpful answer below, indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer. This helps indicate your solution for anyone else with the same question.

0 ·

Answer 1 · 2016-02-01T14:32:40Z

perrywhittle answered Feb 1, '16

this may be a good place to start https://technet.microsoft.com/en-us/library/cc755056.aspx

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2016-02-01T14:39:23Z

perrywhittle answered Feb 1, '16

in fact checking this link, https://technet.microsoft.com/en-gb/library/hh997019.aspx the feature is deprecated in Windows 2012. Running Get-WindowsFeature does not show any installable feature

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question