Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Instance count
  • Database count
  • Data size (MB)
  • Log size (MB)
  • Activity (transactions per second)
  • Database on Availability Group

Image Modified

Understanding the Databases on Availability Group view

...

  • Database Name
  • Listener
  • Primary Node
  • Secondary Node
  • Owner

Image Removed

If you not only want to receive static information about AlwaysOn Availability Group databases but also want to monitor health checks of all nodes or track statuses of databases that are not in the AlwaysOn Availability Group, you must add all of the nodes in which you are interested. Because the listener is simply a virtual network name that points to physical instance in a primary or secondary replica of an AlwaysOn Availability Group, you are responsible for the correct AlwaysOn Availability Group configuration.

...

  • Instance
  • Instance tag
  • Owner
  • Location
  • Minor server version
  • Major server version
  • Edition
  • Database (Type the name of the database. This field accepts wildcards.)
  • Database tag
  • Listener (Database and Listener filters allow you to filter for specific items when you are trying to get a list of databases on availability groups.)


Image Modified

As a result, you may be able to see information such as database count by instance, instance count by location, data size by owner, and other interesting information from your environment. Take into account that some options may only be available depending of what you choose in the View and By fields.

...

You can export the information available on the Explorer view, by clicking the Export option on the right-bottom side of your graphs and selecting your preferred format for Exporting: PDF, XLS, or XML.



You can set the number of instances you want IDERA SQL Inventory Manager to show per page, go to the bottom of the page, type the number you require, and then press Enter.

Excerpt
IDERA SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > >

...



Scroll Ignore

Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse