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.

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.

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)

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.

Note: By filling and submitting this form you understand and agree that the use of IDERA’s website is subject to the General Website Terms of Use. Additional details regarding IDERA’s collection and use of your personal information, including information about access, retention, rectification, deletion, security, cross-border transfers and other topics, is available in the Privacy Policy.

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