Cause I found for example some query from sys.spt_columns_view, I don`t want that to be displayed in the Top SQL report, how to achieve that purpose?
Thanx
Hany
Here's a great article showing how to exclude things from collection:
SolarWinds Knowledge Base :: Excluding a SQL Statement from DPA Data Collection
Note: please use with caution as sometimes things can start impacting you from a performance perspective that now you won't see because of the exclusion...
Thanx!
Unfortunately, there's no way I know of to exclude just a user in the pre-defined (canned) reports in DPA.
Here's a link for SQL reports which are really just queries against the repo. You could take these and edit accordingly.
Database Performance Analyzer
Are you looking for a specific report? Or was this just more of a general how to question?
Also, if you start excluding things from collections, they won't show in the reports any longer (moving forward).
No, I need to see only queries executed against user DB`s not the system db`s, how to do that?
Note that there is a major difference from excluding from a chart or report and excluding from collection!
Great point!
Well I followed what is mentioned in the KB article, I successfully ran this code: INSERT INTO con_qp_exclude (dbid, type, value, origin) VALUES (5, 'H', '2800065850', 'U'); as 2800065850 is the id of the SQL statement needs to be excluded (sys.sp_columns_rowset).
See, for me I have no issue with that, but the problem is that my manager is recievieng this report on daily basis, and he doesn`t want to see any system queries.
It will probably take some time now for the system queries to get flushed out of the report...
Thank you, could you please identify "sometime"? like it will take 1 week or forever , cause the system query still coming untill now
