Manageability

Organizations today need the right product tools to manage the entire database lifecycle, as well as services and support, across the enterprise.

Microsoft is always looking for ways to deliver greater peace of mind with built-in manageability tools. With SQL Server 2012, you gain a wealth of product improvements and planning tools to help your with the ever-changing organization.

What's New in SQL Server 2012

  • Multiple enhancements in SQL Server Management Studio for ease of use and rich manageability of SQL Server databases.
  • Simulate workload traffic in test environments to simplify deployments and help reduce error rates.
  • Gain insights when troubleshooting and proactively identify issues that help improve performance and reduce downtime using System Center Advisor.
  • Minimize risks and automate database deployment using SQL Server PowerShell.

Key Capabilities

  • Experience Increased Performance

    Simulate what a live data environment looks like using Distributed Replay, in order to accurately assess realistic data traffic and load that happens during real-world testing.

    Proactive Management Capabilities
    • Perform application updates and seamlessly implement configuration changes and upgrades.
    • Access server configurations and prevent problems with System Center Advisor, a secure cloud service that helps reduce server downtime.
    • Monitor SQL Server deployments with the System Center Operations Manager Management Pack.
  • Build Free Planning Tools

    Find out how to deploy SQL Server 2012 across the enterprise using detailed guidance to implement upgrades and migrations.

    Peace of Mind Before Deployment
    • Minimize risks and unexpected results by analyzing installed components from earlier versions with the SQL Server Upgrade Advisor.
    • Greatly reduce the time, cost, and risks associated with migrating to SQL Server with Microsoft SQL Server Migration Assistant (SSMA).
    • Securely assess IT environments for platform migrations with Microsoft Assessment and Planning (MAP) Toolkit, a free, downloadable tool.
  • Meet Mission-Critical Needs

    Implement a dedicated solution that supports a range of services that is flexible depending upon the mission-critical nature of the organizational needs.

    Multi-Server Management and Comprehensive Support
    • Single console for centrally managing SQL Server instances with SQL Server Management Studio.
    • End-to-end SQL Server monitoring with System Center Operations Manager.
    • Intentionally manage SQL Server instances using standardization with Policy-Based Management.
    • Accelerate troubleshooting of SQL Server databases with Performance Data Collector, SQL Server Profiler, XEvents, and Database Engine Tuning Advisor.
    • Back your business with direct Microsoft 24/7 service with Microsoft Premier Support with access to scalable service and support program from solution validation to architectural reviews.

"SQL Server 2012 has provided a robust management platform for our massive data volumes…. By using AlwaysOn, we no longer worry about availability during peak periods."

Yu Ke
Chief Engineer, Shenzhen Institute of Standards and Technology