SQL Inventory Manager
Discover and Visualize your SQL Server Environment
SQL Inventory Manager lets you discover, track, and manage your SQL Server environment from a simple, lightweight web interface and is designed to be quick to install and easy to use.
• View your SQL Server inventory - know what you have where & who owns it
Discover all SQL Servers Across the Enterprise
Scan the network to find all your SQL Servers and databases. Scan by domain, IP address ranges, and/or import your own server lists from excel or CSV files. Flexibly schedule discoveries to locate newly added servers daily, by specific days of the week &/or at particular times of day.
Get Complete Visibility
See all those servers lurking that you may not have known existed including SQL Express instances. Servers discovered are immediately captured to the Inventory View with default options so you can see what actions might be needed to bring them up to maintenance.
Monitor and Manage Inventory
Go beyond Microsoft’s Assessment Planning (MAP) toolkit for SQL Server inventory tracking. Automatic discovery and a Global Dashboard provide high-level visibility of all server inventory. Learn what you have, which servers are improperly configured and what actions might need to be taken for instances competing for memory and resources.
Establish Tags to Group and Analyze Inventory
Create tags at the server, instance and database levels to organize by owner, location, function or other categories to suit different needs. You can even mark servers as “unmanaged” to revisit for follow-up later. A tag cloud displays on the Dashboard that groups the tags created to quickly visualize the size of those groups comparatively by prominence or importance.
Get Availability Alerts and Run Health Checks
Receive email alerts for key server indicators such as when servers are down, whether a database has ever been backed up or early warning when you are about to run out of space. Perform regular health checks on monitored servers to gage adherence to configuration best practices. Plus view the findings in a simple list with recommendations for improvement from SQL Server experts.
Deploy Quickly and Scale Out as Needed
Agentless, low impact design offers download, install and use in under 5 minutes with no other modules or installation necessary of anything on monitored servers. A stand-alone web application with no need for IIS provides a simple sign on to login and use remotely from anywhere. Plus it is designed to scale up as you grow, capable of monitoring and managing thousands of databases running on DEV, PROD, QA, TEST or SQL Express instances.
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 utilized. Create custom inventory fields or labels at the server, instance or database level to further categorize 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 utilized 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 organize 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 visualize 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 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 they contain. You can also export this list and give to 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.
Tech SpecsSystem Requirements
-Windows XP SP2+, Windows Server 2003 SP2, Windows Server 2008 SP2+, Windows Vista SP2+, Windows 7, Windows 2008 R2, Windows 8, Windows 2012, .Net 4.0+ and MDAC 2.8.
-SQL Server 2005 SP1+, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014.
Monitored SQL Servers
-SQL Server 2000, SQL Server 2005 SP1+, SQL Server 2008 SP1, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014.
-All Editions Including Express
Additional Platform Support
-Monitor and manage IaaS for Amazon RDS, SQL Azure.
-Internet Explorer IE 9.x+, Chrome, Firefox.
LicensingSQL Inventory Manager is offered per instance. A license is needed for each (per) SQL Server instance that is being monitored. First year of maintenance is included in price.
Alfasoft offer a price guarantee for the IDERA products. If you find an IDERA product at a lower price before your purchase somewhere else we will match it.