Discover, Track and Manage Your SQL Server Inventory
SQL Inventory Manager
- View your SQL Server inventory – know what you have where & who owns it
- Auto-discover any new servers installed, to better manage server sprawl
- Get alerts when a server goes down, or space is running low
- Set tags to better organize servers and databases across the enterprise
- Quickly deploy and access from anywhere via web-based and agentless UI
Discover all SQL Servers Across the Enterprise
Scan the network to find all your SQL Servers and databases including databases on AlwaysOn Availability Groups. 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. In addition users can discover BI services (SSRS, SSIS, SSAS) running in their environment.
Get Complete Visibility
See all those servers lurking that you may not have known existed including SQL Express instances. Users can manually add or set auto-registration to add discovered instances to SIM for monitoring and get recommendations to bring the instances 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. Also compare your current SQL Server builds with the latest build from Microsoft to determine if you have the latest patches or versions.
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 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 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.
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 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.
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.
Specify a series of alternate login credentials with admin 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.
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
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.
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.
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 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
Utilize 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.
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 to internal licensing team to take action for upgrade or consolidation as needed.
Specify different levels of user access including administrator, modify only and read-only. Plus establish a series of either domain only or a list of alternate login credentials with admin privileges to use during the discovery process to limit exposure to unauthorized users.
- 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 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016.
Monitored SQL Servers
- SQL Server 2000, SQL Server 2005 SP1+, SQL Server 2008 SP1, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016.
- All Editions Including Express
Additional Platform Support
- Monitor and manage IaaS for Amazon RDS, SQL Azure.
- Internet Explorer IE 9.x+, Chrome, Firefox, Safari.