DX Infrastructure Manager

Expand all | Collapse all

UIM SQL Prob

  • 1.  UIM SQL Prob

    Posted 05-04-2015 10:23 AM

    Hi,  Can we monitor DB user activities with UIM Sql probe?  Thanks,  Waqar



  • 2.  Re: UIM SQL Prob

    Posted 05-04-2015 12:47 PM

    Waqar, are you asking if you can monitor UCM DB users activity with UIM Sql Probe or is this a general UIM SQL Probe question?

     

    I believe you may have posted this in the wrong forum and want to confirm so we can have it moved to the correct section to best assist you.



  • 3.  Re: UIM SQL Prob

    Posted 05-04-2015 03:12 PM

    Hi Charles,

     

     

    My question is :

     

     

    Does Microsoft SQL prob monitor user activity in Microsoft SQL DB, for

    example which user deleted DB table, which user created DB table in MS SQL.



  • 4.  Re: UIM SQL Prob

    Posted 05-04-2015 04:44 PM

    Hello Waqar,

    It looks like this was incorrectly opened in the wrong forum, this is the Unified Communications Monitor (UCM) section and you need the Unified Infrastructure Management (UIM) forum.

    I will have them move this over there for you.

    I also did some quick research and it doesn't look like it monitors user activity.

    Here is a link to the release notes from the probe:

     

    https://wiki.ca.com/display/UIMPGA/sqlserver+%28SQL+Server+Monitoring%29+Release+Notes



  • 5.  Re: UIM SQL Prob

    Posted 05-05-2015 03:00 AM

    Thanks a lot dear.



  • 6.  Re: UIM SQL Prob

    Posted 05-05-2015 03:31 AM

    Hi Waqar,

     

    SQL probe will not do what exactly you are looking for,

    From user point of view it can do response time monitoring, also it provides you the facility to write your own query in case you feel that can give you desire result and run it on regular interval.

     

    Regards

    Ajit C



  • 7.  Re: UIM SQL Prob

    Posted 05-05-2015 12:42 AM

    I don't believe any probe does that out of the box. You could use sql_response to examine the transaction log of a database and alert on that, but you'll need to come up with the query yourself.

     

    -jon