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
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