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.
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