Does anyone have a set of queries that can be used to pull information regarding a session, total blocking time, total waiting time etc. I need to provide some stats but the current reporting does not satisify it.
dkoceja There are a handful of custom reports available here: https://thwack.solarwinds.com/t5/DPA-Documents/tkb-p/dpa-documents/label-name/sql%20server%20custom%20reports
One of those should get you close. If you can't find what you are looking for, contact support and one of our SEs should be able to help you get what 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.