SQLOpsDB Reports: Application

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?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.