SAP Library - The DBA Cockpit

Start Level 1 Node: The DBA Cockpit

The DBA Cockpit

End Level 1 Node: The DBA Cockpit

Start Level 2 Node: Central System Data

Central System Data

End Level 2 Node: Central System Data

Start Level 2 Node: Monitoring of Remote Databases

Monitoring of Remote Databases

End Level 2 Node: Monitoring of Remote Databases

Start Level 3 Node: Remote Monitoring Scenarios for Microsoft SQL Server

Remote Monitoring Scenarios for Microsoft SQL Server

End Level 3 Node: Remote Monitoring Scenarios for Microsoft SQL Server

Start Level 4 Node: Database Multiconnect

Database Multiconnect

End Level 4 Node: Database Multiconnect

Start Level 4 Node: Remote Enabled Functions (RFC)

Remote Enabled Functions (RFC)

End Level 4 Node: Remote Enabled Functions (RFC)

Start Level 4 Node: Combination of RFC and DB Multiconnect

Combination of RFC and DB Multiconnect

End Level 4 Node: Combination of RFC and DB Multiconnect

Start Level 3 Node: Required Steps to Set Up Remote Monitoring of an SQL Server Data

Required Steps to Set Up Remote Monitoring of an SQL Server Data

End Level 3 Node: Required Steps to Set Up Remote Monitoring of an SQL Server Data

Start Level 4 Node: Creating SQL Server Logins on the Target Database Instance

Creating SQL Server Logins on the Target Database Instance

End Level 4 Node: Creating SQL Server Logins on the Target Database Instance

Start Level 4 Node: Preparing the Database API on the Monitoring Application Server

Preparing the Database API on the Monitoring Application Server

End Level 4 Node: Preparing the Database API on the Monitoring Application Server

Start Level 4 Node: SAP Role and User Management

SAP Role and User Management

End Level 4 Node: SAP Role and User Management

Start Level 4 Node: Creating System Entries in the DBA Cockpit

Creating System Entries in the DBA Cockpit

End Level 4 Node: Creating System Entries in the DBA Cockpit

Start Level 4 Node: Creating or Selecting DBCON Entries for All Remote Monitoring De

Creating or Selecting DBCON Entries for All Remote Monitoring De

End Level 4 Node: Creating or Selecting DBCON Entries for All Remote Monitoring De

Start Level 4 Node: Creating and Populating an Object Source Schema

Creating and Populating an Object Source Schema

End Level 4 Node: Creating and Populating an Object Source Schema

Start Level 3 Node: Additional Functions

Additional Functions

End Level 3 Node: Additional Functions

Start Level 4 Node: Configuring Systems for Remote Monitoring Using the System Lands

Configuring Systems for Remote Monitoring Using the System Lands

End Level 4 Node: Configuring Systems for Remote Monitoring Using the System Lands

Start Level 4 Node: Changing a System Entry

Changing a System Entry

End Level 4 Node: Changing a System Entry

Start Level 4 Node: Deleting a System Entry

Deleting a System Entry

End Level 4 Node: Deleting a System Entry

Start Level 4 Node: Changing a Database Connection

Changing a Database Connection

End Level 4 Node: Changing a Database Connection

Start Level 4 Node: Testing a Database Connection

Testing a Database Connection

End Level 4 Node: Testing a Database Connection

Start Level 4 Node: Deleting a Database Connection

Deleting a Database Connection

End Level 4 Node: Deleting a Database Connection

Start Level 4 Node: Troubleshooting

Troubleshooting

End Level 4 Node: Troubleshooting

Start Level 2 Node: Performance

End Level 2 Node: Performance

Start Level 3 Node: Performance: Overview

Performance: Overview

End Level 3 Node: Performance: Overview

Start Level 4 Node: Memory

End Level 4 Node: Memory

Start Level 4 Node: Disk Space Usage

Disk Space Usage

End Level 4 Node: Disk Space Usage

Start Level 4 Node: Dynamic Values in Current Activity Sub Screen

Dynamic Values in Current Activity Sub Screen

End Level 4 Node: Dynamic Values in Current Activity Sub Screen

Start Level 3 Node: Database Processes

Database Processes

End Level 3 Node: Database Processes

Start Level 3 Node: SQL Statements

End Level 3 Node: SQL Statements

Start Level 3 Node: I/O Performance

I/O Performance

End Level 3 Node: I/O Performance

Start Level 3 Node: Locks

End Level 3 Node: Locks

Start Level 3 Node: Wait Events

End Level 3 Node: Wait Events

Start Level 3 Node: SAP/SQL Data Providers

SAP/SQL Data Providers

End Level 3 Node: SAP/SQL Data Providers

Start Level 3 Node: History

End Level 3 Node: History

Start Level 4 Node: Database Collector Data

Database Collector Data

End Level 4 Node: Database Collector Data

Start Level 4 Node: Performance History

Performance History

End Level 4 Node: Performance History

Start Level 4 Node: Blocking Lock History

Blocking Lock History

End Level 4 Node: Blocking Lock History

Start Level 3 Node: Performance: Performance Warehouse

Performance: Performance Warehouse

End Level 3 Node: Performance: Performance Warehouse

Start Level 4 Node: Performance Warehouse: Reporting

Performance Warehouse: Reporting

End Level 4 Node: Performance Warehouse: Reporting

Start Level 4 Node: Performance Warehouse: Configuration

Performance Warehouse: Configuration

End Level 4 Node: Performance Warehouse: Configuration

Start Level 3 Node: Indexes

End Level 3 Node: Indexes

Start Level 4 Node: Index Usage

End Level 4 Node: Index Usage

Start Level 4 Node: Index Operational Statistics

Index Operational Statistics

End Level 4 Node: Index Operational Statistics

Start Level 4 Node: Index Analysis

End Level 4 Node: Index Analysis

Start Level 3 Node: Performance: Additional Functions

Performance: Additional Functions

End Level 3 Node: Performance: Additional Functions

Start Level 4 Node: Server Detail

End Level 4 Node: Server Detail

Start Level 4 Node: SAP SQL Statistics

SAP SQL Statistics

End Level 4 Node: SAP SQL Statistics

Start Level 4 Node: Database Utilities

Database Utilities

End Level 4 Node: Database Utilities

Start Level 2 Node: Space

End Level 2 Node: Space

Start Level 3 Node: Space: Overview

Space: Overview

End Level 3 Node: Space: Overview

Start Level 3 Node: Single Table Analysis

Single Table Analysis

End Level 3 Node: Single Table Analysis

Start Level 3 Node: Largest Tables

End Level 3 Node: Largest Tables

Start Level 3 Node: Fastest Growing Tables

Fastest Growing Tables

End Level 3 Node: Fastest Growing Tables

Start Level 3 Node: History

End Level 3 Node: History

Start Level 3 Node: Additional Functions

Additional Functions

End Level 3 Node: Additional Functions

Start Level 2 Node: Backup and Recovery

Backup and Recovery

End Level 2 Node: Backup and Recovery

Start Level 3 Node: Backup Overview

Backup Overview

End Level 3 Node: Backup Overview

Start Level 3 Node: Scheduled SQLAgent Jobs

Scheduled SQLAgent Jobs

End Level 3 Node: Scheduled SQLAgent Jobs

Start Level 3 Node: Backup Devices

End Level 3 Node: Backup Devices

Start Level 3 Node: SQL Agent Properties

SQL Agent Properties

End Level 3 Node: SQL Agent Properties

Start Level 3 Node: Tapes Needed for Restore

Tapes Needed for Restore

End Level 3 Node: Tapes Needed for Restore

Start Level 3 Node: Restore History

Restore History

End Level 3 Node: Restore History

Start Level 3 Node: Backup History

End Level 3 Node: Backup History

Start Level 3 Node: SQL Agent Job History

SQL Agent Job History

End Level 3 Node: SQL Agent Job History

Start Level 2 Node: Configuration

End Level 2 Node: Configuration

Start Level 3 Node: Configuration Options

Configuration Options

End Level 3 Node: Configuration Options

Start Level 3 Node: SAP Configuration

SAP Configuration

End Level 3 Node: SAP Configuration

Start Level 3 Node: SQL Server Setup Check

SQL Server Setup Check

End Level 3 Node: SQL Server Setup Check

Start Level 3 Node: Database Options

Database Options

End Level 3 Node: Database Options

Start Level 3 Node: SQL Script Maintenance

SQL Script Maintenance

End Level 3 Node: SQL Script Maintenance

Start Level 3 Node: SQL Script Execution

SQL Script Execution

End Level 3 Node: SQL Script Execution

Start Level 2 Node: Jobs

End Level 2 Node: Jobs

Start Level 3 Node: Central Calendar

Central Calendar

End Level 3 Node: Central Calendar

Start Level 4 Node: Using the Central Calendar

Using the Central Calendar

End Level 4 Node: Using the Central Calendar

Start Level 3 Node: The DBA Planning Calendar (MS SQL Server)

The DBA Planning Calendar (MS SQL Server)

End Level 3 Node: The DBA Planning Calendar (MS SQL Server)

Start Level 4 Node: Setting Up the DBA Planning Calendar (MS SQL Server)

Setting Up the DBA Planning Calendar (MS SQL Server)

End Level 4 Node: Setting Up the DBA Planning Calendar (MS SQL Server)

Start Level 4 Node: Working with the DBA Planning Calendar

Working with the DBA Planning Calendar

End Level 4 Node: Working with the DBA Planning Calendar

Start Level 5 Node: Scheduling an Action

Scheduling an Action

End Level 5 Node: Scheduling an Action

Start Level 5 Node: Changing an Action

Changing an Action

End Level 5 Node: Changing an Action

Start Level 5 Node: Executing an Action

Executing an Action

End Level 5 Node: Executing an Action

Start Level 5 Node: Deleting an Action

Deleting an Action

End Level 5 Node: Deleting an Action

Start Level 5 Node: Displaying the Status of a Day’s Actions

Displaying the Status of a Day’s Actions

End Level 5 Node: Displaying the Status of a Day’s Actions

Start Level 5 Node: Displaying Scheduled Actions

Displaying Scheduled Actions

End Level 5 Node: Displaying Scheduled Actions

Start Level 5 Node: Troubleshooting Scheduled Actions

Troubleshooting Scheduled Actions

End Level 5 Node: Troubleshooting Scheduled Actions

Start Level 5 Node: Displaying the Volume (Tape Names) of Scheduled Backups

Displaying the Volume (Tape Names) of Scheduled Backups

End Level 5 Node: Displaying the Volume (Tape Names) of Scheduled Backups

Start Level 6 Node: Storing a Backup on Multiple Tapes

Storing a Backup on Multiple Tapes

End Level 6 Node: Storing a Backup on Multiple Tapes

Start Level 5 Node: Scheduling Database and Transaction Log Backups (Windows)

Scheduling Database and Transaction Log Backups (Windows)

End Level 5 Node: Scheduling Database and Transaction Log Backups (Windows)

Start Level 5 Node: Scheduling Database Consistency Checks (Windows)

Scheduling Database Consistency Checks (Windows)

End Level 5 Node: Scheduling Database Consistency Checks (Windows)

Start Level 5 Node: Third Party Backup Tools

Third Party Backup Tools

End Level 5 Node: Third Party Backup Tools

Start Level 3 Node: The DBA Log

End Level 3 Node: The DBA Log

Start Level 2 Node: Diagnostics

End Level 2 Node: Diagnostics

Start Level 3 Node: Missing Tables and Indexes

Missing Tables and Indexes

End Level 3 Node: Missing Tables and Indexes

Start Level 3 Node: Viewing the Error Log with the SAP System

Viewing the Error Log with the SAP System

End Level 3 Node: Viewing the Error Log with the SAP System

Start Level 3 Node: SQL Command Editor

SQL Command Editor

End Level 3 Node: SQL Command Editor

Start Level 3 Node: SQL Profiler

End Level 3 Node: SQL Profiler

Start Level 3 Node: Deadlock Monitor

Deadlock Monitor

End Level 3 Node: Deadlock Monitor

Start Level 3 Node: Disp+Work DLLs

End Level 3 Node: Disp+Work DLLs

Start Level 2 Node: SQL Server Alert Monitor

SQL Server Alert Monitor

End Level 2 Node: SQL Server Alert Monitor

Start Level 3 Node: Alerts for SQL Server

Alerts for SQL Server

End Level 3 Node: Alerts for SQL Server

Start Level 3 Node: Viewing and Customizing Threshold Values

Viewing and Customizing Threshold Values

End Level 3 Node: Viewing and Customizing Threshold Values