Exclude specific databases from instance monitoring?

rllefebv

Hi all,

We have an instance with about 60 databases running. One of these databases has the majority of long running queries that do not necessarily impact the performance of the other databases, yet continuously show in the top executions, resulting in clutter. This hampers some of our troubleshooting on the other databases. Is there an easy way within DPA to exclude the "nuisance" database?

Thanks in advance,

Robert

mandevil

Yes, but be careful. See this post from earlier.

There are a couple ways to "clean up" DPA trending charts...

Re: SQL Server Monitoring