Maximize your SQL Server Resources with Application and Multi-Server Management
Play Maximize your SQL Server Resources with Application and Multi-Server Management
Investments in application and multi-server management help organizations manage database environments efficiently at scale, through clearer centralized monitoring of resource utilization. Such investments can help streamline consolidation and upgrade initiatives across the application lifecycle. This session introduces new management tools for SQL Server 2008 R2 that will help improve IT efficiency and productivity. We will look at the new SQL Server Utility Control Point (UCP) and demonstrate how to register existing SQL Server instances with a UCP and start data collection. You will learn how to use the new Utility Explorer, a new capability in SQL Server 2008 R2 Management Studio, to navigate the utilization data collected from managed SQL Server instances and applications, and hear about the road map for future AMM improvements.