Solution : https://service.sap.com/sap/support/notes/1388700 (SAP Service marketplace login required)
Summary :
This SAP Note provides steps for setting up a DBA Cockpit to monitor remote Microsoft SQL Server databases using SAP Solution Manager. Key steps include checking technical requirements, obtaining necessary software, software installation, and database connection setup. Technical prerequisites demand access to the server on which the SAP Solution Devices Manager and SQL Server are running, SQL Server login with sysadmin rights, and proper network configuration. Installation of the Database Shared Library and SQL Native Client is needed for non-SQL Server-based SAP Solution Manager systems. The document also addresses site limitations and provides troubleshooting guidelines.
Key words :
choosing performance -> history -> database collector data -> time series, sql agent job titled sap_<monitor schema>_prd_mssql_collector, management -> sql server logs -> current log section, microsoft sql server 2008 r2 native client, <sapsid>gosetuser '<monitoring schema>'gothen truncate, microsoft sql server 2008 r2 feature pack, microsoft sql server snac client library, external microsoft sql server database system, ms sql server snac client software, jobs -> back end configuration action
Related Notes :
| 1561326 | MSS: PPMS Mapping for MS SQL Server 2008 R2 |
| 1507730 | DBACOCKPIT: Removing Ownership of Data Warehouse Extractors |
| 1474806 | MSS: PPMS Mapping for MS SQL Server 2008 |
| 1453217 | CCMS-based Monitoring for SAP Convergent Charging |
| 1389738 | sap_tf_version error in Solution Manager DB Monitoring Setup |
| 1265134 | DBA Cockpit: Connecting a remote database |
| 1124987 | DB6: Availability of administration functions |
| 1027512 | MSSQL: DBA cockpit for basis release 7.00 and later |
| 1027146 | Database administration and monitoring using the DBA Cockpit |
| 151603 | Copying an SQL Server database |