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 to YOURSQLNODE1NAME
Database Node 1-Fixed Disk;
Modify the node name is equal to YOURSQLNODE1NAME
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.
