Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

New and Improved Features in SQL Inventory Manager


By:   |   Last Updated: 2016-09-29   |   Comments   |   Related Tips: More > Monitoring

Problem

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.

Solution

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.

sql inventory manager overview page

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.

sql inventory manager bi services

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.

sql inventory manager patches

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.

sql inventory manager available 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.

Discovery Enhancements

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:

  1. The SQL Discovery Center in SQL Inventory Manager lays out many different options and allows you to customize scans for your unique environment.
  2. 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. 

sql inventory manager health checks

Recommendation

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. 

Next Steps

MSSQLTips.com Product Editorial sponsored by IDERA makers of SQL Inventory Manager.



Last Updated: 2016-09-29


get scripts

next tip button



About the author
MSSQLTips author Greg Robidoux Greg Robidoux is the President of Edgewood Solutions and a co-founder of MSSQLTips.com.

View all my tips
Related Resources




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools