Standalone SQL Server monitoring with Solution Manager

[Former Member]

Hi,

We have a Solman 3.1 instance monitoring all of our SAP and non-SAP Infrastructure. We have several SQL Server systems we would like to monitor.

Currently we have installed saposcol and sapccms agents on the servers and are getting the OS alerts and additionally have also configured Process and Log file monitoring. We would now like to get SQL Server specific alerts like Log full alerts and other db specific alert situations. Since this is a standalone db, how can we configure this db to report these type of alerts?

thanks,

binoy.

[Former Member]

Additionally, I have already defined it in Solman for access via ST04RFC. However I do want to automate SQL Server alerts for these databases.

thanks,

binoy.

[Former Member]

Binoy,

If I remember correctly I had this setup @ Sharp for oracle. You can use the same step to monitor the SQL DB liek transaction logs, backup etc's. If you can run the report RSDBMON0 this will build the <DB monitoring Tree> on the solman. So you can setup the autoreaction for the respective monitoring segment which you wanted.

Let me know if any questions.

Ashwin