Our client wanted to determine active vs. dormant databases, their overall performance and utilization, and any consolidation/decommissioning opportunities. Our analysts reviewed the entire environment using network listeners for a high-level preliminary analysis before diving into details of each database instance.
The following attributes were defined for output and visualization in Tableau: versions, configurations, software available per server, named SQL instances, types of instances, number of databases per, applications, compatibility levels, creation dates, size, long-running queries and indices.
Tools Used: Microsoft Stack, Tableau