Does anyone know how to create a report that shows the top 10 SQL Server statements for a specific database? I want to be able to email the report as well.
Does anyone know how to create a report that shows the top 10 SQL Server statements for a specific database? I want to be able to email the report as well.
Hello William,
currently, this report is missing in the out-of-the-box reports. There is an enhancement request for it - look at here:
As a workaround you can use the "Export to CSV" function to export the statement list in PI into a csv file:
Does that help?
Kind Regards
Nicola
Hi Nicola,
Thanks for the response and link to the enhancement request. I was just curious of anyone knew how to build a custom report to get this information in the mean time.