Problem
There is no way to fully uninstall the Performance Monitor Dashboard. The installer creates server-level objects that survive a database drop:
- 3 SQL Agent jobs (Collection, Data Retention, Hung Job Monitor)
- 2 Extended Events sessions (PerformanceMonitor_BlockedProcess, PerformanceMonitor_Deadlock)
- Server-side trace (LongQueries)
- The PerformanceMonitor database itself
Additionally, the existing clean install path only deletes 2 of 3 Agent jobs and doesn't clean up XE sessions.
Reported in #419.
Solution
- Standalone SQL script (
install/00_uninstall.sql) for SSMS users
- CLI flag (
--uninstall) on the existing installer
- GUI button (Uninstall) in the installer GUI
- Fix existing clean install to remove all 3 jobs + XE sessions
blocked process threshold (s) will NOT be reset (other tools may depend on it).
Problem
There is no way to fully uninstall the Performance Monitor Dashboard. The installer creates server-level objects that survive a database drop:
Additionally, the existing clean install path only deletes 2 of 3 Agent jobs and doesn't clean up XE sessions.
Reported in #419.
Solution
install/00_uninstall.sql) for SSMS users--uninstall) on the existing installerblocked process threshold (s)will NOT be reset (other tools may depend on it).