Page History
...
- Use SQL Server Enterprise Manager or Management Studio to close any open connections to the Repository database.
- Use SQL Server Enterprise Manager or Management Studio to take the Repository database offline. If you cannot take the Repository database offline, stop the Collection Service.
- Use a tool such as IDERA SQLsafe SQL Safe to restore the Repository database on the target server using the appropriate backup archive file.
...
- Select Start > Administrative Tools > Services on the current computer.
- Scroll down and right-click SQLdm SQLDM Collection Service in the list, and select Properties.
- In the Startup Type drop-down list, select Disabled.
- Click OK.
- Scroll down and right click SQLdm SQLDM Management Services in the list, and select Properties.
- In the Startup Type drop-down list, select Disabled.
- Click OK.
...
- Open the SQL Diagnostic Manager Console.
- Enter your new SQL Diagnostic Manager license key.
- Add the SQL Server instances you want to monitor.
- Open the System Diagnostics utility by selecting Help > System Diagnostics.
- Click Test.
- Verify that all the tests are successful.
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |