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:
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:
Task | Actions |
---|---|
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 Host | As 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 |
Support of MSSQL Always On scenario | Prerequisites:
Configuration steps on OS:
|