Introduction


While VM initially provisioned resources could be a good fit for the application, those could change due to requirements or human error by the admin.

Problem

Check for required VM resources based on CPU and RAM values in DBA.Maintenance.Configuration table

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_check_server_required_resources.sql.sql

Example