SQL Sentry & SIOS iQ: The Integration Begins

Brian Davis

Published On: June 15, 2016

Categories: Advisory Conditions, Custom Conditions 0

With the latest release of SIOS iQ and a few simple steps you can now integrate SQL Sentry and have your Custom Conditions show up within SIOS iQ! For those of you who may not have heard about it yet, SIOS iQ is a machine learning analytics software platform. This simple, intelligent solution learns infrastructure behaviors and provides answers to difficult problems in complex VMware IT environments.

If you're interested in learning more about this technology, please check out this webinar, Thursday, June 16th:

Announcing Extraordinary SQL Optimization : Advanced Machine Learning Analytics Meets SQL Server Domain Insight

To enable this integration, we've added some additional tags to Custom Conditions. These tags are specific to SIOS iQ and are named as such: SIOS iQ Compute, SIOS iQ Network, SIOS iQ Storage, and SIOS iQ Application. When a Custom Condition is tagged with a "SIOS iQ" tag, it will be pulled into SIOS iQ and correlated with other appropriate events. While we've set the SIOS tag defaults accordingly for the default Custom Conditions we provide, you can modify the settings to your own environment as well as use the SIOS iQ tags for any Custom Conditions you've created. Adding the SIOS iQ tags to your own Custom Conditions will allow those to be pulled into SIOS iQ too.

The rest of this blog post will detail the steps currently required to make the integration work until we release all the components in an upcoming maintenance build.

Assuming you have the latest build of SQL Sentry along with SIOS iQ installed and running in your environment, the following steps are needed to enable the integration:

Step 1

Download the SIOSiQ.zip file and extract the 4 SQL scripts.

Step 2

Open the "01 - SIOS Schema Creation.sql" script in SSMS and execute it against your SQL Sentry repository. This script simply creates a schema named "SIOS" in the repository.

Step 3

Open the "02 - SIOS.ArchiveLog.sql" script in SSMS and execute it against your SQL Sentry repository. This script creates a table in the SIOS schema named "ArchiveLog".

Step 4

Open the "03 - SISO.iQ_Export.sql" script in SSMS and execute it against your SQL Sentry repository. This script creates a stored procedure in the SIOS schema named iQ_Export. This stored procedure is what SIOS iQ uses to pull Custom Condition event data from SQL Sentry.

Step 5

Open the "04 - Update CC Tags.sql" script in SSMS and execute it against your SQL Sentry repository. This script will update the latest version of each Custom Condition with additional tags specific to SIOS iQ. It will also set the SIOS iQ tags appropriately for the Custom Conditions SQL Sentry provides. You can see the new SIOS iQ tags in the following screenshot.

SIOS iQ Tags

Step 6

Once you've run these scripts, you'll need to setup the SQL Sentry adapter within SIOS iQ. The adapter will ask for an account to access the SQL Sentry repository database. This account only requires read permissions to the database.

That's it! You're good to go!

This is the fist round of integration between SQL Sentry and SIOS iQ. As I mentioned earlier, the steps listed above will not be necessary after a future build, but we wanted to get this exciting new integration out there as soon as possible instead of waiting on a maintenance release. We are continuing to work with SIOS on a deeper integration between SQL Sentry and SIOS iQ and will keep you informed about any new developments. If you try out this integration, please feel free to give us any feedback you have - either via the comments below, or via email.

Brian (@brian78) is a Product Integration Engineer at SentryOne, where he is responsible for a multitude of projects as they relate to strategic partners. He manages multiple environments and is responsible for the automation of the SentryOne platform, as well as cloud projects, including migration and deployment. Brian also analyzes the processes and tools for the development and delivery of our products and makes recommendations on how they can be improved. Having spent over 15 years in the IT industry serving in a multitude of roles from Support to Application Developer, DBA, SQL Developer, and Consultant, Brian is well suited to such a position that crosses many boundaries. Brian is also a Regional Mentor for PASS as well an active member of the Ohio North SQL Server User Group.