I'll cover each of these steps in detail. Run the SSIS package to populate the database.Ĭustomize the tool with your own reports. To use the consolidated monitoring tool, follow these steps:Ĭreate the database for the consolidated monitoring tool. A SQL Server Reporting Services (SSRS) package consolidates the dashboard reports, DBA repository reports, and several new reports and provides a single interface from which to run them. This tool uses a SQL Server Integration Services (SSIS) package to collect performance data from SQL Server instances, then stores that data in a database. To achieve these goals, I combined and modified the DBA repository solution and dashboard reports to create a consolidated monitoring tool. Run all the dashboard reports and the DBA repository reports from one interface I needed a tool that would alsoĬreate reports that show historical trendsĮasily connect to any SQL Server instance and display its dashboard report
However, I wanted to expand on these solutions. (See the Learning Path box at the end of this article.) These solutions basically gave me a way to view live performance data as well as create snapshots of it. Two of my favorites were Microsoft's SQL Server 2005 Performance Dashboard Reports and Rodney Landrum's DBA Repository, which was introduced in SQL Server Magazine. Over time I've accumulated several performance monitoring tools.
0 kommentar(er)
