All the report files are accessible directly or indirectly from the primary report “SQLOpDB Dashboard.” I would recommend after deployment to hide all the reports
Category: SQLOpDB
SQL Server Policies for SQLOpsDB
The SQL Server policies are part of collection from Microsoft default best practice policies plus additional policies I have written over the year. The policies
Central Management Server (CMS) for SQLOpsDB
The CMS is the driver of all the data collection needs. When registering a server in CMS, follow these best practices. Register only the replicas,
SQLOpsDB Requirements
As stated in SQLOpDB Architecture, there are three components to configure, collect data, and do reporting. The requirements are briefly discussed on the GitHub page.
SQLOpsDB Architecture
Over the years I have tried to minimize number of moving parts in the architecture. The overall architecture can be broken down into three primary
Deploying SQL Server Operational Dashboard
I have tried to automate parts of the deployment. When deploying the current version, there is no way to upgrade from an existing deployment. In
SQL Canada (SQLCAN) 