Hello,
I would like to know if it is possible with DPA to obtain the list of queries which have been executed on an SQL database within a defined period of time? I saw "Find SQL", but I am missing the chronology of events.
Thank you
Custom software development process creates user-friendly, extensible and secure applications and web services. The development process ensures the presence of a uniform, repeatable and manageable software design. The software development process involves designing and implementing the core functionality and creating a test driven and documentation-friendly code base. The process also includes writing user stories, developing database abstraction, documenting and testing the application design and resulting functional requirements. Users receive applications that work as expected. I recommend hire developers in ukraine.
I contacted DPA support who informed me that there was no possibility to create custom reports and that DPA was not a monitoring tool, that requests of less than one second were not were not recorded, etc. So We have to find another solution
I wonder if this is something SQL Sentry will gather - assuming that you are talking about MS SQL of course. I've only just scratched the surface on what Sentry can do, but I think I recall seeing something like this.
I don't think so. https://support.sentryone.com/s/question/0D54N00003Ttq2g/how-do-you-navigate-to-see-what-queries-are-running-on-a-database
- There is a possibility to create custom reports, as can be seen if you query in the DPA Blog forum for "Custom Report" or "Custom Reports". It is tricky because the schema is dynamic and the dimensions and facts are setup so that DPA can capture statistics for all queries every second. You may want to refer to this Thwack Discussion on Custom Reports and Metrics "DPA tables and how to query DPA data" which has examples and also references to the schema architecture in the replies.
- DPA is a monitoring tool and primarily a query performance analysis utility. It is not however, intended to be an audit tool to capture every individual SQL statement execution of the same query. It aggregates the wait time across all the executions of the same query for each time period so that you can analyze a query's typical or tending performance changes.
- You can use FindSQL to filter the set of queries that were executed by specific users, applications, client machines, etc. as well as both simple and advanced (i.e. Boolean and Regex expressions) compound queries against the SQL statement content.
- DPA captures wait statistics on all queries every second (much more frequent than almost all competitors) - including sub-second queries. However, if a sub-second query starts/stops in between each second collection, DPA will not capture/add those. But if those queries are executed frequently, DPA will capture a good subset of those active during its second collections making it suitable for performance analysis of those queries.
As mentioned here, I think a custom report is your best bet.
HTH!
Thanks for this solution! I also have the same case.
