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.