The most recent content from our members.
Hi team- I know DPA captures all queries and transactions. I do see the stored procedures ran manually or scheduled ones in DPA - Find SQL. However, not able to see the same SPs if ran as a batch. Any thoughts why? Or do we have limitations on transactions/query pulling from DPA?
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…
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…
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(*)…
Hey all, I've been running into an odd issue with APM and Windows Server 2008 R2 machines. I have some stored credentials in APM that are added to the servers during the build process. I have verified that the credentials work to log onto the machine and appropriate rights have been given to the user account (local…
It looks like you're new here. Sign in or register to get started.