SAP/ MS SQL Server DBA in CCMS
Database Backup
Backup Strategy
Backup Types
Log Truncation
Recovery Models
Backup Device Management
Disk Configuration
Executing Backups
Backing Up with the SAP System
Monitoring Backups
Checking Individual Backups with the SAP System
Checking all Backups with the SAP System
Database Restore
Restoring the SAP Database after Disk Crash
Restoring the Database and Log Backups
Restoring After Executables Disk Crash
Database Server Checks
Checking Consistency of the Database
Checking Consistency of Individual Tables
Viewing the Error Log
Monitoring the SAP Data Disk
Monitoring the SAP Log Disk
Database Server Configuration
Increasing the Size of the Windows Page File
Optimizing the Virtual Memory Manager
Removing the Screen Saver
Database Management Tools
SQL Server Configuration Manager
Starting and Stopping the SQL Server
Setting SQL Server Startup Options
SQL Server Management Studio
Setting Authentication
Changing Passwords for SQL Server Logins
Changing Passwords of Windows Accounts
Registering a Server
Changing the Size of the Database Files
Configuring SQL Server
Configuring Databases
Setting Single-User Mode
Executing Queries
Moving SAP Database Files to New Disks
Displaying the SQL Server Version
Backing Up the SQL Server Database
Backing Up the Current Transaction Log
Checking Backups
Viewing the Error Log with SQL Server Management Studio
Increasing the Number of Error Log Files
Restoring a Database Backup
The DBA Cockpit
Central System Data
Monitoring of Remote Databases
Remote Monitoring Scenarios for Microsoft SQL Server
Database Multiconnect
Remote Enabled Functions (RFC)
Combination of RFC and DB Multiconnect
Required Steps to Set Up Remote Monitoring of an SQL Server Data
Creating SQL Server Logins on the Target Database Instance
Preparing the Database API on the Monitoring Application Server
SAP Role and User Management
Creating System Entries in the DBA Cockpit
Creating or Selecting DBCON Entries for All Remote Monitoring De
Creating and Populating an Object Source Schema
Additional Functions
Configuring Systems for Remote Monitoring Using the System Lands
Changing a System Entry
Deleting a System Entry
Changing a Database Connection
Testing a Database Connection
Deleting a Database Connection
Troubleshooting
Performance
Performance: Overview
Memory
Disk Space Usage
Dynamic Values in Current Activity Sub Screen
Database Processes
SQL Statements
I/O Performance
Locks
Wait Events
SAP/SQL Data Providers
History
Database Collector Data
Performance History
Blocking Lock History
Performance: Performance Warehouse
Performance Warehouse: Reporting
Performance Warehouse: Configuration
Indexes
Index Usage
Index Operational Statistics
Index Analysis
Performance: Additional Functions
Server Detail
Database Utilities
Space
Space: Overview
Single Table Analysis
Largest Tables
Fastest Growing Tables
History
Additional Functions
Backup and Recovery
Backup Overview
Scheduled SQLAgent Jobs
Backup Devices
SQL Agent Properties
Tapes Needed for Restore
Restore History
Backup History
SQL Agent Job History
Configuration
Configuration: Overview
Configuration Options
Database Options
SAP Configuration
SQL Server Setup Check
SQL Script Maintenance
SQL Script Execution
Jobs
Central Calendar
Using the Central Calendar
The DBA Planning Calendar (MS SQL Server)
Setting Up the DBA Planning Calendar (MS SQL Server)
Working with the DBA Planning Calendar
Scheduling an Action
Changing an Action
Executing an Action
Deleting an Action
Displaying the Status of a Days Actions
Displaying Scheduled Actions
Troubleshooting Scheduled Actions
RAW: Displaying the Volume (Tape Names) of Scheduled Backups
Storing a Backup on Multiple Tapes
Scheduling Database and Transaction Log Backups (Windows)
Scheduling Database Consistency Checks (Windows)
Third Party Backup Tools
The DBA Log
Diagnostics
Audit Log
Missing Tables and Indexes
Viewing the Error Log with the SAP System
SQL Command Editor
SQL Profiler
Deadlock Monitor
Disp+Work DLLs
Download
Download Selected Spreadsheets
Download All Spreadsheets
SQL Server Alert Monitor
Alerts for SQL Server
Viewing and Customizing Threshold Values