Microsoft SQL Database

This page explains how to prepare a Microsoft SQL database for the connectivity to SAP Focused Run.

Currently the following monitoring application are supported for Microsoft SQL databases:

Preparations in the Managed Database

TaskActions
Install Database
Install MS-SQL 2008 or higher
You need at least MS-SQL 2008, optionally install the latest MS SQL DB and latest Patches from support.sap.com/swdc -> Databases -> MS SQL Server

Create DB monitoring user and provide connection credentials

SAP Focused Run uses SAP Host Agent Web methods to get DB monitoring data. For MSSQL DB, the connection credentials are part of windows authorizations.

Check that your MSSQL installation follows the recommendations in SAP Note 1877727 and SAP Note 1564275.

Be aware the hostname interpreted as DB Hostname by Outside Discovery discovery is the hostname as set in Windows registry as BackConnectionHostNames described in SAP Note 1564275 and should be the same as SLDSYSTEMHOME set in SAP NetWeaver ABAP or j2ee/dbhost in SAP NetWeaver JAVA (see also SAP Note 1052122).

Note: Can be automated by os script.

Run Outside Discovery on the HostAs prerequisites, you shall install the SAP Host Agent and run Outside Discovery as described in page Preparing Outside Discovery.
Get DB metrics from the OS

Optional operation to test the metric collection on OS level:

/usr/sap/hostctrl/exe/saphostctrl -function ListDatabaseMetrics -dbname <DBname> -dbinstance <Instname> -dbtype mss