Database Inventory Management
for SQL Server, Azure SQL Database, and Amazon RDS for SQL Server

SQL Inventory Manager

Discover, track, and manage database inventory

Database administrators need a simple, efficient way to discover, document, and manage their SQL Server environment as the organization changes. It is important to have a way to inventory and determine which SQL Servers need oversight and maintenance. SQL Inventory Manager offers an organized web-based dashboard that captures core information about the entire inventory of SQL Servers across the environment.

 Discover, track, and manage database inventory
  • View all SQL Servers: Know what you have where and who owns it.
  • Automatically discover new servers installed to better manage sprawl.
  • Create tags and custom fields to organize servers and databases.
  • Perform health checks to monitor server operation and capacity.
open-quote

We reduced the effort to discover, track, and manage our entire SQL Server inventory by more than 80%.

IT Director

(medium enterprise, healthcare, USA)

We use IDERA’s tool to discover SQL Server instances and take inventory of our databases.

Database Administrator

(large enterprise, industrial manufacturing, USA)

IDERA’s comprehensive inventory management tool with automatic discovery and health checks is best in class

IT Director

(medium enterprise, healthcare, USA)
close-quote_dark
  • View servers and databases and their topology

    The dashboard view provides high-level visibility of all inventory. Filter down on servers and databases see what they are being used for and what resources are being utilized.

  • View instances and their topology

    See detailed information on instances. View configuration settings of hosted server hardware. Plus, view other instances hosted on that server.

  • Tag and annotate

    Create tags to organize servers by owner, location, function, and other categories. Set tags at instance and database level for further filtering and exploration.

  • Drill down into tag details

    Drill down into tags to see more details about instances such as configuration, databases, and operating system versions.

  • Explore graphically

    The graphical explorer displays different server and database groups from tags in visual pie charts. Compare, filter, and navigate across different groups.

  • Track licenses

    View list of builds, versions, and editions to adhere to Microsoft’s licensing compliance. See all servers, instances, databases, CPUs, and cores.

  • Decommission servers and databases

    Mark instances and databases taken offline to decommissioned list to prevent erroneous alerting. Preserve asset and tagging information.

  • Select discovery methods

    Specify discovery methods to use to scan networks for servers and instances via domains, IP address ranges, both TCP ports, and imported server lists.

  • Monitor everything

    Monitor and manage up to 1,000 instances and 40,000 monitored databases across SQL Server editions and versions including on Always On Availability Groups.

  • Schedule automatic scans

    Run recurring automatic scans to find newly added servers. Flexible scheduling options are available for both browser service and computer scans.

  • Expedite discovery

    Specify alternate login credentials with appropriate privileges to use during discoveries when original credentials are not valid to expedite discovery process.

  • Receive top alerts

    Automatically generate alert notifications to send via email covering a variety of server indicators as needed.

  • Health checks

    View daily health checks of the server environment to gauge adherence to best practices. See list of detailed results with actionable recommendations for improvement.

  • View help tips

    Built-in tips are provided, which are context sensitive, to assist in interpreting information exposed and remove any guesswork.

  • Deploy easily

    Download, install and use SQL Inventory Manager in minutes. Users can sign on and use the web console from anywhere. Monitor SQL Servers without installing agents.

  • Scale for future growth

    Support the entire environment with tens of thousands of monitored databases. Discover and manage all instances, and manually add or remove instances and databases as needed.

  • Integrate with IDERA Dashboard

    Access consolidated web-based dashboard console to quickly view and navigate between SQL Inventory Manager and other IDERA products.

  • Report comprehensively

    Utilize predefined server inventory reports grouped and sorted for different purposes. Generate custom reports to compile information about the environment.

  • Set up role-based security

    Specify different levels of user access including administrator, modify only and read-only. View list of users and security profiles at database and instance levels.

  • Install on cloud virtual machines

    Unify control by running SQL Inventory Manager on cloud virtual machines with Windows—such as Azure Virtual Machine (VM) and Amazon Elastic Compute Cloud (EC2).

  • Monitor SQL Server on cloud virtual machines

    Manage SQL Server instances running on cloud virtual machines—such as Azure VM and Amazon EC2.

  • Monitor hybrid environments with single tool

    Save time by using the same inventory tool for SQL Server databases on physical and virtual machines on-premises; and on virtual machines in private, public, and government cloud.

  • Access mapped cloud drives

    Map cloud storage as network drives or removable drives on Windows. For example, map storage to Amazon Simple Storage Service (S3) and Azure Blob Storage.

Let’s get started.

Start your 14-day trial, no credit card required (but all fields are).

Commercial licenses are not supported with this trial download. To update to the latest version, please access IDERA’s customer support portal.

If you would like to speak with a representative, then please call +1 (713) 523-4433.

Ready to see how SQL Inventory Manager can help you discover and manage SQL Servers on-premises and in the cloud?

Datasheet

SQL Inventory Manager
Datasheet

Everything you need to know, all in one downloadable PDF

Case Study

SQL Inventory Manager
Overview

See the main features and benefits of SQL Inventory Manage

Infographic

Why Use SQL
Inventory Manager?

Learn about features such as discovery, tracking, and managing SQL Servers.

Play

Value of
SQL Inventory Manager

Learn about the benefits of SQL Inventory Manager for you and your organization

White Paper

How To Deal With
Inherited SQL Servers

Andy Warren walks through nine best practices tasks to deal with inherited SQL Servers

Webcast

Do You Know Where
Your Databases Are?

Daniel Janik shares tips and techniques for how to monitor SQL Server performance

You can view the list of all resources for SQL Inventory Manager in the Resource Center.