The most recent content from our members.
We're getting into formalizing all of our policies and procedures and would like to keep everything in Samanage if possible. Right now, I'm thinking that I'd use solutions and a "Policy" category. As for Procedures, I feel like those would just be a standard Solution and/or Service Catalog Item. I'd be really interested to…
Want to know what kind of aggregate impact specific stored procs have on your end users? Now you can know. Steps: * Bring up DPA in your browser. * Click on "Reports" in the upper right of the interface. * Select the instance you are interested in within the Database Instance dropdown. * Select "Top SQLs" within the Report…
Hi team, I have a client that requested 1. the procedures and guidelines on how the review of these audit logs should be conducted 2. the criteria for defining and prioritizing critical audit logs to be reviewed such as the usage of privilege IDs, changes to policies settings / configurations, invalid user login to Windows…
Description This procedure will return a list of stored procedures for the given date range ordered by wait time. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. Stored Procedure IF (SELECT COUNT(*) FROM…
I am trying to input a stored procedure in the SQL query. I know the procedure works, and the querry works since I tested them in SSMS. I know that my user permissions are fine and i checked with event viewer on the SQL i don't have issues login in. My stored procedure should return 0 or 1 so it fulfills the requirements.…
If there anyway in DPA to see the actual Stored Procedure Call Request Statement of a long waiting query?
Description This procedure will return all SQL statements for the given date range and stored procedure ordered by wait time. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. Stored Procedure IF (SELECT COUNT(*)…
DESCRIPTION This alert will calculate the average Procedure Cache Hit Ratio in the last X minutes based on the Ignite Procedure Cache Hit Ratio resource metric data. The number of minutes the alert uses is based on the Execution Interval field. The example below uses the "Procedure Cache Hit Ratio" metric, but a very…
are there any manuals on how to do this. thanks
It looks like you're new here. Sign in or register to get started.