Resource Governor – Changing and Deleting a Resource Pool

Microsoft in the News

Data Storage

On March 21, 2018, Microsoft announced their proof of concept for the storage of data in manufactured DNA. Using a fully automated system, Microsoft was able to store the word “hello” in a manufactured DNA and retrieve it back into digital form.

The rate of data production is increasing exponentially world-wide. Storage for all that data does not come cheap. With DNA storage, Microsoft could conceivably store all the data from one enormous data center in DNA containers roughly the size of a few board game dice.

Before Microsoft announced this proof of concept, storage in DNA required considerable manual labor in a laboratory setting. So, this is a major step towards commercializing this storage process.

DNA is a robust storage vessel that can far outlast current storage technologies. Even in harsh conditions, DNA is known to survive for tens of thousands of years.

You can read the paper here: https://www.nature.com/articles/s41598-019-41228-8

Resource Governor – Changing and Deleting a Resource Pool

To change the settings on a Resource Pool or to delete it completely, you will need to have Control Server permissions. The same limitations that applied to creating a will apply when you are changing the settings.

1. Open Object Explorer in SQL Server Management Studio and expand the Management node to find Resource Pools.
2. Find the resource pool you want to modify and right-click on it.
3. Choose Properties.
4. Click the row representing the resource pool you are going to change.
5. Double-click any cell you want to change and enter the new parameters, keeping in mind the restrictions pertaining to min – max values and totals equaling 100%.
6. After each change, or when you have made all the changes you want to make, click OK to save the changes.

To delete a resource pool, you will have a new set of limitations and restrictions. The following resource pools cannot be deleted:

• Resource pools containing workload groups.
• The default resource pool.
• Internal resource pools.

To delete a resource pool that does not fall under one of the above restrictions:

1. Open Object Explorer in SQL Server Management Studio and expand the Management node to find Resource Pools.
2. Right-click the resource pool you want to delete and select Delete.
3. Click OK.
4. If the resource group fails to delete, check to ensure it does not contain a workload group.

If your resource pool contains a workload group:

1. Right-click the resource pool and choose Properties.
2. In the window labeled Workload groups for resource pool, choose the workload group to be deleted, then right-click the right arrow on the left side of the line and choose Delete.
3. Click OK.
4. If your workload group fails to delete, it likely contains active sessions. You will have to either wait for the active session to end or use the KILL command in Transact-SQL.