Given budgeting and licensing constraints, database servers have seen dramatic amounts of database consolidation. Managing performance in densely consolidated environments is always a challenge because you will have some users who are trying to run reports while other users are trying to execute OLTP workloads. What if there was a way to do load balancing between these workloads while putting your feet up on your desk? Well, there is and it's called the Resource Governor.
Watch the on demand webinar to learn the different ways to make your job easier through the utilization of SQL Server Resource Governor.
Speaker: Joseph D'Antoni is a Senior Consultant and SQL Server MVP with over a decade of experience working in both Fortune 500 and smaller firms. He is a Principal Architect for Denny Cherry and Associates and lives in Malvern, PA. He is a frequent speaker at major tech events, and blogger about all topics technology. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft white paper "Using Power BI in a Hybrid Environment".
Topics: Database Performance, Database Diagnostics Products: SQL Server Tools for Better Performance