Phone - Australia: 1300 553 313
Hotline - New Zealand: 0800 450 168

SQL Inventory Manager

Discover, Track and Manage Your SQL Server Inventory

  • View your SQL Server inventory - know what you have where & who owns it
  • Auto-discover any new servers installed, to better manage server sprawl
  • Set tags to better organise servers and databases across the enterprise
  • Perform health checks to monitor server operation and capacity
  • Quickly deploy and access from anywhere via web-based and agentless UI

sql diagnostic managerSQL Inventory Manager provides fundamental information on your SQL Servers to help you track, report on, and manage your database environment from a web-based dashboard. It gives a broad enterprise-wide view of all of your SQL Server inventory through automated discovery as well as simple, actionable information about the state of the environment. View core information such as how many databases exist, at what location they reside, how they are configured and more so you can stay organised and better manage the server inventory as the organisation grows.


Inventory Management

Views & Topology – Server & Database

The Dashboard View provides high-level visibility of all inventory. Filter down on individual servers and databases to get insights on what they are being used for and what resources are being utilised. Create custom inventory fields or labels at the server, instance or database level to further categorise assets such as owners to call if that server goes down. Then, Easily export the list to PDF, Excel, or XML format if desired. Some examples of information captured include:

  • Top databases by growth
  • Databases with the most activity (transactions)
  • Number of instances owned by a particular group or department
  • Total number of databases by data size or log size
  • Amount of space utilised by development vs. production
  • Applications running on an instance

Views & Topology – Instance

See detailed information on a SQL instance such as SQL Server version, memory, number of databases, data size or log size. View configuration settings of the hosted server hardware such as OS version, hard disk size or if the server is virtual. Plus, view the other instances hosted on that server to see how these instances might be competing for memory and resources.

Tags & Annotation

Create tags to organise SQL Servers by owner, location, function or other categories to suit different needs. You can also set tags at the instance and database level for further filtering and exploration. A tag cloud on the Dashboard groups the tags created to quickly visualise the size of those groups comparatively by prominence or importance.

Drilldown Tag Details

Drill down into any given tag to see more details on the most common groups in your environment. You can also see a list of the instances contained in a tagged group to drill-down to view more information such as configuration settings, number of databases or OS versions and more to better manage the SQL Server environment.

Graphical Inventory Explorer

The graphical Explorer displays the different server and database groups from the tags created into a visual pie chart. Compare, filter and navigate across different groups to better understand your whole environment. Slice and dice the filters to get a better sense of the inventory you have, who owns the servers or databases and where they reside. Some examples of information to see from these filters include:

  • Locations with the largest number of servers or databases
  • Servers with the most business critical databases
  • Server or database groups with the most activity in transactions

SQL Server License Tracking

View a list of SQL Servers Builds, Versions and Editions to ensure adherence to Microsoft licensing compliance. See all SQL Servers, which versions they are running, the number of instances they host and how many CPUs and cores they contain. You can also export this list or create a report, and give the information to your internal licensing team to take action for upgrade or consolidation as needed.

Server & Database Decommissioning

Mark any instances and databases taken offline to a Decommissioned list to prevent erroneous alerting. Those servers will preserve asset and tagging information to view the data and in the event you need to re-commission later.

Enterprise Management

Web-based, Agentless, Low Impact Design

Download, install and use SQL Inventory Manager in under 5 minutes. As a stand-alone web application, there is no need for IIS and users can sign on and use it remotely from anywhere. Discover servers automatically with no other modules, plug-ins or professional services needed to get started. SQL Inventory Manager is agentless so there is no need to install anything on monitored servers.

Scalable for Future Growth

SQL Inventory Manager is designed to support the entire SQL environment with thousands of monitored databases. Users can discover and manage Development, QA, Production and even SQL Express instances and manually add or remove instances and databases on the fly as needed. There is no need to know exactly how many SQL Servers you have, simply buy by groups of servers and move up to the next band group as your environment grows.

Integration with IDERA Dashboard

Access a consolidated dashboard console to quickly view and navigate between SQL Inventory Manager and the other products you may use from IDERA. SQL Inventory Manager will show key indicators in the dashboard view including:

  • Top Databases by Size
  • Top Databases by Activity
  • Tags cloud
  • SQL Server Licensing Info


Utilise a pre-defined set of server inventory reports grouped and sorted for different purposes, such as OS patch version or application usage. View inventory reports grouped by server attributes and annotations and export and print as needed. Generate customisable reports to compile information about the SQL Server environment, including SQL licensing, inventory summary, chargebacks, and health checks.

Additionally, view a list of SQL Servers to meet Microsoft licensing compliance. See a list of all SQL Servers, which versions they are running, the number of instances they host and how many CPUs they contain. You can also export this list and give it to your internal licensing team to take action for upgrade or consolidation as needed.

Role-based Security

Specify different levels of user access including administrator, modify only and read-only. View a list of users and security profiles at the database and instance levels to determine the types of users that have privileges. Plus establish a series of either domain-only permissions or a list of alternate login credentials with appropriate privileges to use during the discovery process to limit exposure to unauthorised users.

Alerting & Health Checks

Top Alerts

Alert notifications are generated automatically in-product and can be sent via email covering a variety of server indicators as needed. Indicator notifications include:

  • SQL Server instance down
  • SQL Server instance slow to respond
  • Database down
  • Drive at risk of becoming full
  • Database at risk of becoming full

Health Checks

View daily health checks of the server environment to gauge adherence to best practices. If a SQL Server is operating with poor configuration practices, see a list of detailed results with actionable recommendations for improvement from SQL Server experts in easy to understand language. Some examples of misconfigurations and poor practices might include:

  • Databases not being backed up
  • Integrity checks not being run regularly
  • Database autoshrink enabled
  • Insecure xp_cmdshell functionality enabled

Users can set threshold values at risk warning alerts for databases volume, Data, and Data logs.

Help Tips

Built-in Tips are provided, which are context sensitive, to assist in interpreting the information exposed and remove any guesswork. Explanations provided are straightforward and free of "jargon" so users don't have to be an expert to interpret what to do next to speed up server management tasks.


Discovery & Monitoring

Server Discovery Methods

Specify the discovery methods you wish to use to scan the network for servers and SQL instances via domains, IP address ranges, both standard and custom TCP ports &/or imported server lists from excel or CSV files. Discovery collection criteria are like that of Microsoft's Assessment and Planning (MAP) toolkit including SQL Server Resolution Service, WMI, TCP Probe, Service Control Manager and Windows Registry.

Monitor Everything

Monitor and manage up to 1000 SQL instances and 40000 monitored databases across the spectrum of SQL editions including SQL Server 2000, 2005, 2008, 20008R2, 2012, 2014, 2016, and SQL Express. You can also monitor database instances on AlwaysOn Availability Groups and add instances from the cloud on both IaaS for Amazon RDS and SQL Azure.

Schedule Auto-scans

Run recurring automatic scans to find newly added servers which you did not know about. Flexible scheduling options are available for both browser service and computer scans which can be set to recur daily or on particular days of the week including time of day. Set defaults to automatically register all newly added instances discovered for immediate monitoring or set filters for particular SQL Server editions.

Expedite Discovery

Specify a series of alternate login credentials with appropriate privileges to use during the discovery process in case the original credentials are not valid to expedite the discovery process and remove limitations of domain admin credential only.





For more information please contact the MicroWay sales team: buynow
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz

International: call +61 3 9580 1333, fax +61 3 9580 8995

© 1995-2019 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.