tonyfountain

Or a hyperlink to a script in another location. For example, for organizations that store their scripts in a central repository, source control, or ticketing system.

Parameters and values are already stored in the cached plan in most cases. While this doesn't give you parameters for every execution I have found this is enough to assist me in testing / diagnosing performance issues.

Is this going to hit the radar anytime soon? This is becoming more and more of an issue that DPA does not support SMTP email through O365. With governance controls clamping down, organizations simply are shutting off their internal SMTP servers or blocking relays. When will DPA be able to support sending mails over O365?

Why? Because essentially it is not needed. You can determine if it is an indexing issue by looking at the execution plan, and running something like sp_BlitzIndex to see what indexes exist for a table *AND* what's in the missing index DMVs. Not to mention, the larger the query (i.e. more tables / views), I think it's…

I agree, I voted this down too. I'd prefer to look at the execution plan and the query to see if I need to add an index, or alternatively refactor the query.

I *always* go back to the developer when they use SELECT * to confirm the queries cannot be "tuned down" first.

!The ability to report over this is an invaluable feature. Please consider this request.

Hey Robert, I know this is an old thread, but I am just now getting to this one. When I use Orion to export out the metrics "Blocked SQL Statements", "Impact of Root Blockers", or any "Wait Time" report i.e. "...by Wait Type, Database, DB user, etc..." I get a csv with the columns "Entity", "Metric", "Date/Time", Value…

Not to hijack this thread, and knowing it's old... can monitoring the repository with Solarwinds DPA be done without an extra license or cost?

Thanks for the info cpriddy I'll dig into this tomorrow!

Thanks, I'll go post the request!

cpriddy​ when I navigate to the 2nd URL (https://thwack.solarwinds.com/docs/DOC-172886) I get a message stating "Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here. "