cancel
Showing results for 
Search instead for 
Did you mean: 

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

avijish
Participant
0 Kudos

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!

Accepted Solutions (0)

Answers (3)

Answers (3)

Sriram2009
Active Contributor
0 Kudos

Hi Vijish.

Sorry for the delay. Check this SAP Note 1478133

BR

SS

avijish
Participant
0 Kudos

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

ImtiazKaredia
Active Contributor
0 Kudos

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


Sriram2009
Active Contributor
0 Kudos

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