Weekly SQL Database Reports

Version 1

    Hello,

     

    One of my customer's DBA team had a requirement for weekly Database reports. Most of them were running with 2 nodes and have SQL App insight enabled. They would like to see the node utilization reports along with some stats from App insight.

     

    Please download and import the report and make the necessary changes,

     

    I have added the below datasources,

    Database node 1;

    Database Node 1-Fixed Disk;

    Database node 2;

    Database node 2-Fixed Disk;

    HPOPENVIEW on SQL01;

    ClusteredIndexesByFragmentationDatasource-SQL01;

    NonclusteredIndexbyFragementaion

     

    Database node 1;

    Modify the node name is equal toYOURSQLNODE1NAME

     

    Database Node 1-Fixed Disk;

    Modify the node name is equal toYOURSQLNODE1NAME

     

    Replace node name in  Database Node 2 source with YOURSQLNODE2NAME

     

    Replace the SQL Database for the below datasources as well,

    HPOPENVIEW on SQL01;

    ClusteredIndexesByFragmentationDatasource-SQL01;

    NonclusteredIndexbyFragementaion

     

     

    Kindly suggest what additional details can we add in this.