The SQLOpsDB data collection can help build an inventory of applications and their respective owners. For each database introduce the following extended properties on the user database.
- ApplicationName
- ApplicationOwner
Both are optional, if none are supplied, it will default to “Unknown.” However, if ApplicationOwner is specified then ApplicationName is expected, or again it default to “Unknown.”.
The applications landing page is simple:
For each application, it provides overview, of number of databases deployed by envionrment.
If you select the application you’ll be able to see granular view of database name, size, and SQL instances the application is supported on.
So next time an application is asking to restore a copy of database or spin up another instance? Quickly stop and assess, do you really need it? How much is the application costing your organization in SQL Server infrastructure?
SQL Canada (SQLCAN) 