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.
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.
See detailed information on instances. View configuration settings of hosted server hardware. Plus, view other instances hosted on that server.
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 tags to see more details about instances such as configuration, databases, and operating system versions.
The graphical explorer displays different server and database groups from tags in visual pie charts. Compare, filter, and navigate across different groups.
View list of builds, versions, and editions to adhere to Microsoft’s licensing compliance. See all servers, instances, databases, CPUs, and cores.
Mark instances and databases taken offline to decommissioned list to prevent erroneous alerting. Preserve asset and tagging information.
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 and manage up to 1,000 instances and 40,000 monitored databases across SQL Server editions and versions including on Always On Availability Groups.
Run recurring automatic scans to find newly added servers. Flexible scheduling options are available for both browser service and computer scans.
Specify alternate login credentials with appropriate privileges to use during discoveries when original credentials are not valid to expedite discovery process.
Automatically generate alert notifications to send via email covering a variety of server indicators as needed.
View daily health checks of the server environment to gauge adherence to best practices. See list of detailed results with actionable recommendations for improvement.
Built-in tips are provided, which are context sensitive, to assist in interpreting information exposed and remove any guesswork.
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.
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.
Access consolidated web-based dashboard console to quickly view and navigate between SQL Inventory Manager and other IDERA products.
Utilize predefined server inventory reports grouped and sorted for different purposes. Generate custom reports to compile information about the environment.
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.
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).
Manage SQL Server instances running on cloud virtual machines—such as Azure VM and Amazon EC2.
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.
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.
Everything you need to know, all in one downloadable PDF
See the main features and benefits of SQL Inventory Manage
Learn about features such as discovery, tracking, and managing SQL Servers.
Learn about the benefits of SQL Inventory Manager for you and your organization
Andy Warren walks through nine best practices tasks to deal with inherited SQL Servers
Learn about the concerns and considerations for managing a diverse SQL Server environment