Manageability

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

  • What's New in SQL Server 2012 Manageability
    SQL Server 2012: What's New in Manageability
  • Quick Tour Through New SQL Server Migration Assistant

    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.

    Related Solutions

    "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

    White Papers

    Dig deeper into the capabilities of SQL Server through white papers written by top experts.

    Resources