Managing 'Noisy Neighbors' in SQL Server
If you've been managing databases for any length of time, you've probably had to contend with the "noisy neighbors" scenario. In this scenario, you have several applications, each with their own database residing on a single instance of SQL Server, which don't share the resources of the server nicely. To deal with this issue, you might want to investigate Resource Governor as an alternative.
Originally Posted June 09, 2015
You may also enjoy this video recording featuring me, Jason Hall, and David Klee - Strategies and Best Practices for Virtualizing SQL Server.