#sqlopsdb reports

SQLOpsDB Reports: Dashboard – Drill Through

As stated in previous reports, all the dashboard elements offer drill through. To investigate the additional details behind the summary data. The summary layout is saved in Snapshot.* tables and are only generated once at the end of DataCollection script. If you feel snapshot is incorrect or incomplete, execute Snapshot.CreateDatabaseSnapshot stored procedures. It will drop existing snapshots…

SQL Health, Configuration Health, and Disk Capacity Planning. Single Stop!

SQLOpsDB Dashboard is primary report where all investigation starts for data collection. The database dataset is generated at the end of execution of the SQLOpsDB_DataCollection.ps1 PowerShell script. If for some reason the dashboard is returning blank, it means the data collection script did not complete. Review the SQLOpDB Data Collection Logs to understand where it is stuck. The dashboard is…