I have been asked to show all queries a particular user has executed over the past 3 months. In particular against one instance of MS SQL and a single database on that instance.
Can this be achieved through DPA? If so how do I do it? I am an extreme novice when it comes to DPA so any help or guidance would be much appreciated.
Here is a custom report that might help: https://thwack.solarwinds.com/t5/DPA-Documents/Custom-Report-Top-SQL-for-Database/ta-p/529535
The report is fairly old, I'm not sure if it will still work as expected. If it does not work, drop an email to support and ask for help in creating the exact report you need.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.