Consolidating Your SQL Server Environment On-Premises


SQL Server’s broad popularity is in part driven by how easy it is to install, configure, and manage. But that can have a downside too – server sprawl. Consequently, many organizations find that there comes a time when it can be very beneficial to consolidate many smaller or older instances of SQL Servers into a fewer bigger or more powerful servers. Typical benefits range from reduced costs for software licenses and hardware components, but also for reduced management needs and organizational complexity.  

Every big and complex project deserves time and attention to planning for optimal outcomes, and a consolidation is no different. In this webinar, your speakers focus on consolidating SQL Server environments across on-premises environments, including topics like: 

  • Times and scenarios where consolidation is most appropriate 

  • How to identify your best consolidation candidates 

  • Tips on consolidation targets, whether that be a single large instance with added databases or multiple instances spread across many virtual machines 

  • Licensing costs and alternatives 

  • Practical tips and tricks when conducting the consolidation 

This session will help you advance your skills with managing an unruly and growing environment. By teaching you the major considerations when planning a consolidation project, you face less problems and enjoy a faster and more productive consolidation of your environment with less hardware to manage and even reducing your licensing requirements. 

Interested in additional SentryOne webinars?  Check our webinar library. 

Available On Demand

Kevin Kline

Kevin Kline

Principal Program Manager, SentryOne

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at blogs.sentryone.com/author/kevinkline. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Mike Walsh

Mike Walsh

Founder/Consultant, Straight Path Solutions

Mike started Straight Path Solutions in 2010 when he decided that after over a decade working with SQL Server in various roles, it was time to try and take his experience, passion, and knowledge to help clients of all shapes and sizes.Mike isa husband, father to fourgreat children. He’s a volunteer Firefighter and EMT in his small town in New Hampshire, and when he isn’t playing with his family, solving SQL Server issues or leading his great team at Straight Path, it seems like he has plenty to do with his family running a small farm in NH raising Beef Cattle, Chickens, pigs, and who knows what other animals have been added!

Mike loves working with SQL Server, Heloves data and is aSQL Server Consultant. He speaks at regional and national conferences, and blogs about SQL Server in his free time (when he has any!). Eight times so far since 2011, Microsoft saw fit to recognize himas a Microsoft MVP for SQL Server, or now the Data Platform.

Straight Path exists to serve clients by removing worry, confusion, and doubts around their databases and data estate through a relentless focus on their needs and dreams.

Companies with the highest demands for database performance choose SentryOne