Expert Advice on High Availability SQL Server and Machine Learning Analytics – Blogs, Webinars and Live Events

SIOS experts in high availability SQL Server cluster protection routinely share their knowledge and provide expert advice through webinars, blogs, and live events.

Blog Post: Step-by-Step Guide to High Availability SQL Server v.Next Linux High Availability
Click here to learn how to deploy a Linux VM in Azure running SQL Server and how to configure a 2-node failover cluster to make it highly available without the need for shared storage.

Blog Post:  Deploying a Highly Available File Server in Azure IAAS (ARM) with SIOS DataKeeper This blog is a step-by-step guide to deploying a two-node File Server Failover Cluster in a single region of Azure using Azure Resource Manager.

Live Webinar: December 15, 2016 –  Webinar: Keeping the Peace with Your Sys Admins while Providing High Availability SQL Server. Join SQL Server MVP Dave Bermingham as he walks through common use cases that cause conflict between SQL DB Admins and VM Admins when SQL Server HA is involved. He will also describe a simple, conflict-free way for SQL Server admins to get what they need for a successful implementation of SQL Server. Register here.

Live Webinar: December 8, 2016 – Understanding vSphere Analytics: Machine Learning vs Threshold-basedJoin David Davis, 8-time vExpert and Partner at ActualTechMedia and Experts from SIOS Technology in this real-world, practical, hands-on webinar! Find out the differences between different vSphere analytics approaches and how to choose a solution that’s best for you. Register here.

Recorded Webinar – VMware Guest Based SQL Server High Availability Clusters – Ways to Protect SQL and Maintain Flexibility. Watch this recorded webinar and hear Dave Bermingham, Microsoft Clustering and Datacenter MVP and Tony Tomarchio, Director of Field Engineering at SIOS discuss ways to create a high availability cluster to protect SQL in a VMware environment without sacrificing IT flexibility or important VMware features, and whether you can have a cluster and multi-site replication with VMware. Register here.

IT Analytics for VMware: 5 Ways to Learn More About What Machine Learning Based Analytics Can Do for You

1. See Machine Learning IT Analytics in Action: Visit the SIOS Booth #307 at the 2016 PASS Summit Conference October 25-28th at
Washington Convention Center, Seattle, WA. Experience the power of SIOS iQ Machine Learning IT Analytics through an interactive demonstration using a Hololens augmented
reality headset. Learn more.

IT analytics with SIOS iQ machine learning based analytics

 2.  Attend the PASS the Bacon Breakfast panel discussion at PASS Summit on Thurs, October 25 at 6:50 AM. Hear experts David Klee, Founder Heraflux Technologies, Denny Cherry, principle, DC&AC, SQL expert Geoff Hiten, and others discussing techniques for improving SQL performance in VMware environments. and Registration required: click here for tickets.

3.  Visit the SIOS booth at VMUG Boston on November 3 at the Boston Hynes Convention Center, 900 Boylston Street, Boston, MA 02115. See SIOS iQ in action and enter to win our raffle. Learn more here.

4.  Attend our upcoming webinar: Save Big by Right Sizing Your SQL Server VMware Environment
October 20, 2016 at 1:00 PM ET, 10 AM PT
According to leading analysts, companies are overprovisioning VMware environments by as much as 80%, wasting tens of thousands of dollars annually in unnecessary server and storage acceleration hardware, VMware and application licenses, and capacity. Under-provisioning is equally problematic – causing performance issues and, putting failovers (and critical applications that rely on them) at risk. Join this webinar to learn simple techniques for ensuring you have the performance and capacity your business needs without over provisioning. Find out how to quickly determine how to strike the perfect balance to right size your VMware environment while optimizing SQL Server performance. Learn about new machine learning based analytics tools that can provide you with a clear breakdown of your current environment (vMem, vCPU, hosts, and more) and recommendations for a fully optimized environment with a detailed calculation of the savings.
Click here for more information and to register

5.  Attend All Things Open (October 25-27th) at Raleigh Convention Center, Raleigh, NC.
Hear SIOS CTO, Sergey Razin, Ph.D., present “Open Source: Transforming Machine Learning and AI” at 11:30 AM on October 26th. Learn more here


Optimize SQL Server Performance and 5 Other Things to Do at VMworld 2016

#1. Experience an Augmented Reality Guided Tour of SIOS iQ Machine Learning Analytics Solution for SQL Server Performance

Root cause of SQL Server performance issues with SIOS iQ machine learning analytics
SIOS iQ machine learning analytics with enhanced reality headset.

Try to improve your SQL Server performance in this fun augmented reality demo. See how you can save money by solving performance issues in one click. Identify wasted virtual resources.  Optimize your VMware application environment.

#2. Attend Breakout Session

SIOS CTO Sergey Razin, Ph.D., and SQL Sentry’s Brian Davis present – Use Cases in Performance Root Cause Resolution for SQL Server. They show you how to use vRealize Operations Manager, SIOS iQ Analytics, and SQL Sentry Performance Advisor. Learn best practices for identifying and resolving application performance issues in SQL Server. Identify SQL Server performance issues using VMware vRealize Operations Manager, characterize infrastructure root causes and recommended solutions with SIOS iQ machine learning analytics solutions, and define application-specific root causes with SQL Sentry Performance Advisor.  9/1/2016 for Use Cases in SQL Server Performance Root Cause Resolution.

#3.  Stop by SIOS Speaking Session in Tegile Booth #2057 to Learn Keys for Implementing Cost-Efficient Storage Accelerationtegile performance

SIOS Director of Field Engineering will be a guest presenter in the
Tegile booth #2057. He will talk about using machine learning analytics for a successful storage acceleration strategy. He will show how to use it to accelerate SQL Server performance.

#4.  Stop by Book Signing with vExpert Michael Corey in SIOS Booth #2361corey book

VMware vExpert and noted author Michael Corey will be in the SIOS booth on August 30 to sign his book Virtualizing SQL Server with VMware: Doing IT Right. The first 10 attendees to arrive at the book signing will receive a free copy. The book is also available in the show bookstore.

#5. Join Guest Presenter: SQL Sentry in SIOS Booth #2361 for Demo of Integration of SIOS iQ and SQL Sentry Performance Advisor


Stop by SIOS Booth #2361 on Monday, August 29 at 2:00 PM-3:00 PM and Tuesday, August 30 at 11:00 AM to noon to see a demonstration by SQL Sentry’s Brian Davis for a live demonstration of integration of SIOS iQ with SQL Sentry Performance Advisor. Learn how this integration bridges a critical gap between IT infrastructure administrators and SQL Server administrators. See how easy it is to find and resolve SQL Server performance issues with SIOS iQ and SQL Sentry.

SIOS: Essential for Mission-Critical VMware Environments

jason-96Guest Blog: Jason Bloomberg, Intellyx

Virtualization has unquestionably become a critical and ubiquitous feature of the enterprise operational environment, and VMware clearly predominates. Enterprises rely upon their VMware technology to support mission-critical infrastructure, including the systems of record that run the business.

Avoiding VMware-related performance issues – especially when such issues may lead to downtime – has thus become a mission-critical priority. And yet, finding the root cause of application performance issues in VMware vSphere environments can be difficult and costly.

The interrelated nature of infrastructure and applications – particularly for systems of record like Microsoft SQL Server – can obscure the root cause of performance issues. As a result, SQL database administrators, VMware infrastructure managers, network managers and perhaps other domain experts have to collaborate to find the real cause and devise a solution.

Implementing a solution in such complex, distributed VMware installations, however, is itself difficult to achieve in practice. Such solutions often take an expert – but such experts can be hard to find, and many shops find themselves making do with less skilled VMware professionals.

In other cases, VMware shops turn to third-party consultants for the proper configuration. Even assuming the consultants do their job properly, once they hand over the environment to their customer then maintaining it once again requires skills that may be in scant supply.

For today’s enterprises that depend upon VMware, however, there are rarely any viable alternatives. Their environments continue to grow in size and complexity, and their businesses increasingly depend upon them as the mission-critical infrastructure they are.

SIOS: Addressing VMware Complexity

This growth in complexity combined with scarce expert VMware skills is the challenge that SIOS addresses with their SIOS iQ product. SIOS fills this gap in the existing VMware management tools used to address infrastructure problems in complex, dynamic virtualized environments.

SIOS continues to enhance the capabilities of SIOS iQ since launching the product in 2015, helping its customers understand complex IT operations and resolve issues in dynamic VMware environments.

SIOS focuses on the needs of IT Operations Managers and application administrators to address the root causes of performance problems, identify underused resources, and optimize configurations to help them get the most value from their virtualized environment.

SIOS was among the first in the industry to integrate machine learning into its infrastructure analytics as well as deep database performance analytics. It uses advanced machine learning to eliminate false positives and alert storms, thus providing customers with the information they need in an easy to use, graphical interface.

SIOS iQ can also provide instantaneous root cause analytics and recommendations with deep database performance monitoring and optimization. In essence, SIOS iQ is a system that is able to learn about an organization’s virtual infrastructure and how it operates on a day-to-day basis. It can identify anomalies before they become serious issues, thus the chance of false alarms without human intervention.

New Capabilities from SIOS iQ

SIOS is now announcing additional capabilities for predicting and forecasting performance and capacity utilization in complex VMware environments. In addition, SIOS iQ users can now more clearly define Microsoft SQL Server application-specific root causes of performance issues by leveraging SQL Sentry Performance Advisor.

SIOS iQ supports the integration and correlation of Performance Advisor’s custom and standard events out of the box. As a result, users can immediately know where a problem started and whether it is infrastructure or application-specific. Instead of spending time gathering and reviewing data or arguing between departments, users can now directly take action to correct the problem before it becomes critical.

SQL Server is among the most popular databases that run on the VMware platform, explaining why SIOS leveraged its partnership with SQL Sentry to implement SQL Server-specific performance analysis. In addition, SIOS is planning on supporting a variety of systems of record, as the diagram below illustrates.

SIOS iQ Application-Specific Performance Monitoring and Root Cause Analysis (Source: SIOS)

The new capabilities from SIOS iQ directly correlate observed performance anomalies with intelligent performance-related events from deep within the SQL Server platform. It is now possible to link from a SQL performance alert within SIOS iQ to SQL Sentry in context.

Furthermore, SQL Sentry users can create their own events with description and appropriate tags for correlation with SIOS iQ, thus correlating events from the applications down to the infrastructure.

In addition to its newly added support for SQL Server, SIOS iQ also filters for selective analysis across vSphere Clusters. SIOS iQ shows the environment by each cluster, enabling users to select which cluster to view in the SIOS Dashboard. As a result, they can observe all environments together or isolate the view to individual cluster – even to specific events taking place within the cluster.

The Intellyx Take

The more complex the VMware environment, the more important it becomes to have a platform like SIOS iQ in place – and many of today’s enterprise VMware deployments are extraordinarily complex.

The fact that many enterprise systems of record now run on VMware environments ups the stakes for VMware performance. Systems of record are mission critical – and as organizations become increasingly software-driven, digitally transformed enterprises, this mission criticality only becomes more central to the viability of the business itself.

Complexity, however, is the enemy of mission criticality. Whether it be gaps in high availability, misconfigured VM instances, or other issues with capacity, performance, or availability, the list of things that can go wrong continues to explode. And as is particularly true in virtualized operational environments, what can go wrong eventually will.

With SIOS iQ, SIOS is bringing together all the elements that make up a monitoring and root cause analysis platform that modern enterprises with such complex, important VMware investments require. And in spite of the challenges with VMware’s complexity, it’s not going anywhere any time soon – and neither is SIOS.

Copyright © Intellyx LLC. SIOS is an Intellyx client. At the time of writing, none of the other organizations mentioned in this paper are Intellyx clients. Intellyx retains full editorial control over the content of this paper.

August 18, 2015: SIOS is Proud to Sponsor PASSMN’s August SQL Server User Group Meeting

SIOS is proud to sponsor the PASSMN’s August 18th SQL Server User Group meeting. If you are anywhere near St. Paul, MN, I highly recommend joining! Visit the PASSMN Calendar for the latest meeting details.

Register Now

August 18, 2015 at 4:00 PM
Microsoft (Suite 600)
3601 West 76th Street
Edina, MN 55437
This is a free event – Food and Drinks will also be provided at no cost.

August 15, 2015: SIOS is Proud to be a Platinum Sponsor and Speak at SQLSaturday Omaha

Register Now for SQLSaturday Omaha
When: August 15, 2015
Where: UNO Mammel Hall, 6708 Pine Street, Omaha, NE 68106
Cost: $10 to cover the cost of lunch, the event itself is free

SIOS is proud to be a Platinum sponsor at SQLSaturday Omaha. Be sure to visit the SIOS table for your chance to learn more about our SAN and #SANLess solutions, enjoy some candy, and drop off your raffle ticket for your chance to enter our end of day $100 Amex raffle.

We will also be sponsoring a-one-of-a-kind lunch session all about enabling “Clusters Your Way.” As an added bonus you will also have a second chance to win $100 just by joining in.

There are a number of great tracks so be sure to plan your schedule well in advance (schedule).

It’s Time To Demystify Quorums

As I read through the SQL Server forums and field questions from IT pros, it surprises me how many are simply off-put by the mention of the word quorum. It’s a six-letter word treated like a part of our collective four letter vocabulary.

Quorum Defined: A voting mechanism to ensure correct ownership of cluster resources.A “quorum” in an IT-sense is simply a voting mechanism to ensure the correct ownership of a cluster. Most commonly, it’s used in conjunction with Always On (both Failover Cluster Instances and Availability Groups), Hyper-V Clusters and all Windows Server Failover Clusters.

The key isn’t to know where to use them it’s how to use them. I put together a short 30 minute webcast that dives into the a variety of quorum types most commonly used — including the pros, cons, and illustrations to demystify quorums and, dare I say, make them easy to understand. I also suggest tuning in after the 30 minute mark — we had some great questions come in as part of the Q&A.

View the webinar now

Additional Resources

August, 5 2015: SIOS Sponsors South Florida SQL Server User Group – Fort Lauderdale

SIOS is proud to sponsor the South Florida SQL Server User Group’s August 5th meeting in Fort Lauderdale. If you’re in the area, I highly recommend joining!

Register Now

August 5, 2015 at 6:00 PM
Microsoft (Map)
6750 North Andrews Ave. Suite #400
Ft. Lauderdale, FL
This is a free event – Food and Drinks will also be provided at no cost.

This groups meeting registration is managed through If you are not a member of the group, just click the join group button. This group is open and everyone is welcome. You will need to be a member of the group to see additional meeting and group details.

July 21, 2015: SIOS Is Proud To Sponsor IndyPASS — Indianapolis SQL Server User Group

SIOS is proud to sponsor IndyPASS’ July 21st SQL Server User Group Meetup in Indianapolis. If you’re in the area, I highly recommend joining. Production Support DBA, David Maxwell will be presenting “Turbo-Charged Transaction Logs.”

Register Now

July 21, 2015 at 5:30 PM

Location: Apparatus (Map) | 1401 North Meridian Street | Indianapolis, IN, 46202
Cost: This is a free event – Food and Drinks will also be provided at no cost.

Topic of the Evening: Turbo-Charged Transaction Logs
Presented by: David Maxwell (@dmmaxwell)

The transaction log is one of the most critical, yet often misunderstood components of SQL Server. From out of control log growth to very long startup times, problems with the transaction log can cause a lot of pain. In this session, we’ll look at how the transaction log works and how to optimize it’s performance. You’ll learn how to determine the right settings for maximum throughput, and what to do when things get out of control.

This groups meeting registration is managed through If you are not a member of the group, just click the join group button. This group is open and everyone is welcome. You will need to be a member of the group to see additional meeting and group details.

July 25, 2015: SIOS is Proud to Sponsor SQLSaturday Manchester

Register Now for SQLSaturday Manchester (UK)
June 25, 2015
Location: Mechanics Institute in Manchester | 103 Princess Street, Manchester M1 6DD, UK (Map)
Cost: There may be a small fee to cover the cost of lunch, the event itself is free. Please contact the organizers for more information.

SIOS is proud to sponsor at SQLSaturday Manchester. Be sure to visit the SIOS table for your chance to learn more about our SAN and #SANLess solutions, enjoy some candy, and drop off your raffle ticket for your chance to enter our end of day raffle. There are a number of great tracks, so be sure to plan your schedule well in advance (schedule).

If you are interested in additional training, SQLSaturday Manchester is holding Pre-Cons on the 24th of July. Pre-cons are paid events that include a full additional day of training from Microsoft, Redgate, and other industry leaders and experts. Pre-Con session details can be found at