Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions
• What's Changed

1 Microsoft SQL Server Plug-in Overview and Prerequisites

• 1.1 Microsoft SQL Server Plug-in Overview and Feature Summary
• 1.2 What's New in This Release
  • 1.2.1 Added Support for Microsoft SQL Server 2016
  • 1.2.2 Business Intelligence Publisher Reports
  • 1.2.3 Query Performance Historical Playback
  • 1.2.4 Added Support for Microsoft SQL Server Full Recovery Model
• 1.3 Supported Versions
• 1.4 Microsoft SQL Server Plug-in Prerequisites
• 1.5 Downloading the Plug-in
• 1.6 Deploying the Plug-in
• 1.7 Upgrading the Plug-in
• 1.8 Undeploying the Plug-in

2 Configure Microsoft SQL Server for Authentication

• 2.1 Enabling and Finding TCP/IP Port Information
  • 2.1.1 Enabling TCP/IP Port
  • 2.1.2 Finding the TCP/IP Port
• 2.2 Modifying the Permissions for Database Authentication
• 2.3 Enabling SQL Authentication or Mixed Authentication
• 2.4 Authentication Configuration Scenarios
  • 2.4.1 Example 1: Local Monitoring with SQL Authentication
  • 2.4.2 Example 2: Local Monitoring with Windows Integrated Authentication (WIA)
  • 2.4.3 Example 3: Remote Monitoring with SQL Authentication
  • 2.4.4 Example 4: Remote Monitoring with Windows Integrated Authentication (WIA)
  • 2.4.5 Example 5: Cluster Remote Monitoring with SQL Authentication
  • 2.4.6 Example 6: Cluster remote monitoring with Windows Integrated Authentication

3 Discovery of the Microsoft SQL Server Target

• 3.1 Discovering Targets
• 3.2 Adding Targets with EMCLI
• 3.3 Verifying and Validating the Plug-in

4 Configuring Connections

• 4.1 Configuring Remote Connections to Monitor Targets
• 4.2 Configuring Connections to Execute Jobs

5 Inventory and Usage Details

• 5.1 Inventory and Usage Details Page Feature Summary
• 5.2 Accessing the Inventory and Usage Details Page
• 5.3 Additional Information

6 Creating, Editing, and Using Jobs

• 6.1 Creating and Editing Jobs
• 6.2 Using the Backup and Restore Jobs

7 Using Reports and Monitoring Templates

• 7.1 Using the Microsoft SQL Server Plug-in Reports
• 7.2 Deploying Reports After BI Publisher is Configured
• 7.3 Using the Microsoft SQL Server Plug-in Monitoring Templates

8 Chargeback Functionality

• 8.1 About Chargeback
• 8.2 Chargeback Plug-in Deployment
• 8.3 Configuring Global Settings for Chargeback
• 8.4 Configuring a Charge Plan
• 8.5 Revising Extended Charge Plans
• 8.6 Configuring a Cost Center
• 8.7 Configuring an Entity
• 8.8 Generating and Distributing Chargeback Reports
• 8.9 Additional Information for Chargeback

9 Compliance Management

• 9.1 About Compliance Management
• 9.2 Managing Compliance Framework
• 9.3 Configuring the SQL Server Configuration Compliance Standard
• 9.4 "Create Like" Compliance Standard
• 9.5 Editing a Compliance Standard
• 9.6 Evaluating Compliance
• 9.7 Using Trend Overview
• 9.8 Using Compliance Reports
• 9.9 Managing Compliance Violations
• 9.10 Additional Information

Index