I'm a little obtuse sometimes so when following the install instructions I didn't see where this was installed on my PC.
SQL Server 2005 Performance Dashboard Reports
So searching my entire PC here is the script that now needs to be run on each instance of SQL 2005 you want to monitor.
C :\Program Files\SQL Server DBA Dashboard
Here are some highlights from the script that may concern you.
CREATE ASSEMBLY DBA_Dashboard
FROM 'C:\Program Files\SQL Server DBA Dashboard\DBA_Dashboard.dll'
WITH PERMISSION_SET = SAFE
GO
and
DECLARE @jobId BINARY(16)
So I guess we'll be using SQL Agent, or not with SQLEXPRESS on my PC …
EXEC @ReturnCode = msdb.dbo.sp_add_job @job_name=N'SS_DBA_DASHBOARD_GATHER_STATS',
...
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Ole Automation Procedures' changed from 1 to 1. Run the RECONFIGURE statement to install.
SQLServerAgent is not currently running so it cannot be notified of this action.
SQLServerAgent is not currently running so it cannot be notified of this action.