Skip to Content
0

How to configure Database free space monitor alert in SOLUTION MANAGER 7.1

Feb 07, 2017 at 09:24 AM

131

avatar image

Hi Gurus,

We have Solution Manager 7.1 SP11 in our landscape and my requirement is to monitor the overall database free space of a managed ABAP system with Database MSSQL 2008 and Windows 2008 R2

eg. The ABAP Database is of 1 TB and when it grows to 900GB there is an alert email generated.

There is a metric under host template through which we can monitor the filesystems free space and receive alerts if these becomes full.

So please share if there is a way to achieve this or any links/documents for the same.

I've tried searching under various documents but no help yet.

Thanks in advance!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

S Sriram Feb 08, 2017 at 12:21 PM
0

Hi Vijish.

Kindly refer the SAP Notes

1027146 - Database administration and monitoring using the DBA Cockpit

1388700 - SolMan 7.0 EHP1 Database Warehouse for MSSQL

BR

SS

Share
10 |10000 characters needed characters left characters exceeded
Vijish AN Mar 20, 2017 at 12:05 PM
0

Hi Sriram,

Sorry for the delayed response.

Thanks for your answer. I had followed below note as my SOLMAN is 7.1 SP11

1458291 - SolMan 7.1 Database Warehouse & Alerting for MSSQL

As per below note I have created a user with sysadmin access on the SQL Server of managed database and entered the same on SOLMAN_SETUP --> Managed System --> SID of Managed System --> (New Window Opens) --> Managed System Configuration --> Tab "Enter System Parameters" --> DB Parameters section --> Enter Administrator Login/pwd --> Setup DBA Cockpit connection. It sets up correctly however after some time it gets red and the below error comes

.

Can you please suggest the reason?

Thanks in advance!

Regards,

Vijish


solman-error.jpg (35.3 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

In our experience we faced the connection termination when firewall was blocking execution of scripts. Check if that's a case.


0
S Sriram Apr 03, 2017 at 07:28 AM
0

Hi Vijish.

Sorry for the delay. Check this SAP Note 1478133

BR

SS

Share
10 |10000 characters needed characters left characters exceeded