By: Greg Robidoux | Last Updated: 2016-09-29 | Comments | Monitoring
Keeping track of your SQL Servers is time consuming to maintain a list of instances, versions, services that are installed, patch levels and other administrative details. The data is stored in so many different places, so it's quite rare that a DBA has a fully up to date listing of the entire SQL Server infrastructure. Also, every time a change is made in your environment your data becomes out of date. This is where a tool like SQL Inventory Manager comes into play. In a previous article we looked at how SQL Inventory Manager can track all of this information for you. In the latest release of SQL Inventory Manager, new features have been added to help further simplify the management of your environment.
In the previous article, we took a look at the different features available in SQL Inventory Manager and how this can simplify managing your SQL Server environment. In this update we will take a look at some of the new features in version 2.3 that offer additional functionality like:
- Discovery of BI Services
- Patch and Version List
- AlwaysOn Availability Groups
- Discovery Enhancements
- Configurable Health Checks
SQL Inventory Manager Version 2.3
The overall interface is similar to previous versions, but there has been improved integration with the IDERA dashboard as well as with other IDERA products to give you a consistent experience when moving from tool to tool. Below is the Overview landing page for SQL Inventory Manager which gives you a quick synopsis of your environment including any issues that should be addressed.
Discovery of BI Services
As more and more environments roll out SSAS, SSIS and SSRS the importance of making sure these services are running as well as up to date is as critical as the database engine itself. In addition, for some installations all services get automatically installed even though they are not being used. With SQL Inventory Manager you get a quick overview of these services, so you can take control of your implementations.
Patch and Version List
Another big management headache for DBAs is making sure SQL Servers have been patched to the latest release. It is very easy for the same version and edition of SQL Server to be at different patch levels across your environment and this is where SQL Inventory Manager helps. To manually check each instance and research available patches and/or hotfixes takes a lot of time. SQL Inventory Manager simplifies this task by showing the current version that is running as well providing information about available updates.
If you click on the Updates Available link it will open a new window that shows all of the available updates for this version of SQL Server. There are also links directly to the Microsoft site for further research and to download the updates.
AlwaysOn Availability Groups
AlwaysOn Availability Groups continues to become a standard for protecting SQL Server databases. Because this is a critical aspect of making sure your databases stay online, SQL Inventory Manager gives you insight for all of your Availability Groups. On this one page you can see an overview of all of the servers that are participating in Availability Groups.
Knowing what installations of SQL Server exist in your environment is a critical step in taking a proactive approach to managing SQL Server. We all know it is not easy to find every single installation, but SQL Inventory Manager continues to add new methods to find all of these hidden / unknown installations. Having full knowledge of what servers exists is important to make sure machines are patched, backed up and maintained. If it exists in your environment, SQL Inventory Manager can find it.
A couple of these enhancements include:
- The SQL Discovery Center in SQL Inventory Manager lays out many different options and allows you to customize scans for your unique environment.
- After several releases which were focused on adding breadth to discovery, in SIM 2.3 there are new options to exclude domains or to narrow discovery to individual OUs, which can prevent unnecessary scans on machines such as user workstations.
Configurable Health Checks
As discussed in this previous article, SQL Inventory Manager offers several health checks that are performed on your instances to give you peace of mind that certain issues won't occur. Some of these include databases without backups, databases running out of space, disk drives running out of space, etc. To further meet the different requirements for your environment, SQL Inventory Manager offers the ability to configure some of the health checks to match your specific needs.
Maintaining a list of all of the SQL Servers in your environment is a tough task unless you have strict rules as to what gets documented every time a new instance is deployed or updates have been applied. As mentioned, each time a change is made your documentation is now out of date. Take a look at SQL Inventory Manager to automatically discover SQL Server instances in your environment as well as always have a complete up to date list for all of your SQL Servers.
- Take some time and discover what SQL Inventory Manager can do to help you discover servers in your SQL Server environment. Download a 14 day free trial of SQL Inventory Manager
- Learn more about SQL Inventory Manager on the IDERA website
- Read the previous article to get a more in-depth look at SQL Inventory Manager.
MSSQLTips.com Product Editorial sponsored by IDERA makers of SQL Inventory Manager.
Last Updated: 2016-09-29
About the author
View all my tips