MSSQLTips Webinar with SIOS - Thursday 1p Eastern

Come join SIOS and Heraflux for an exciting webinar discussing the inherent challenges with infrastructure problems, database performance, and bridging the silos within the IT organization.

  • Learn why legacy tools fall short in helping you fully solve SQL Server problems
  • Comparison: Step through how to troubleshoot the cause of a SQL Server problem vs. using Machine Learning
  • Get answers you need to help prevent future SQL Server performance challenges

Attend this webinar to learn more.

Webcast Date

Thursday, November 16, 2017
6:00 PM UTC | 1:00 PM EST

Register for this webinar here.


VMworld 2017 Recap

Heraflux was proud to participate in both VMworld USA and EMEA over the last month, and our enterprise SQL Server content stole the show!

Our VMworld USA experience was simply amazing.

First, David Klee from Heraflux, along with Deji Akomolafe from VMware Corp. presented an all-day boot camp the Saturday before VMworld on SQL Server virtualization, where we presented an incredible amount of tips and tricks on SQL Server-on-VMware performance, availability, and scalability topics.

Both of our general session presentations made the VMworld USA best-of-the-day list for Tuesday, August 29th! They are now available for you to watch and learn from out on YouTube.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right [VIRT1309BU] with Michael Corey

Performance Tuning and Monitoring for Virtualized Database Servers [VIRT1430BU] with Thomas LaRock

Our panel session with Argenis Fernandez from Pure Storage, Thomas LaRock from Solarwinds, Allan Hirt from SQLHA, and Niran Even-chen from VMware Corp. was also a smash hit.

Thanks Argenis for the great photo!

Special thanks goes to Don Sullivan from VMware Corp. for championing the enterprise database content at these conferences!

Heraflux also announced a partnership with SIOS Corporation for an upcoming add-on for the SIOS iQ product for advanced SQL Server state collection into the iQ machine-learning platform to boost the advanced performance anomaly detection into the application layer in a virtual environment. Stay tuned for more details regarding this exciting development!

David Klee and Sergey Razin, PhD., from SIOS Corporation demonstrating the SQL Server enhancements in SIOS iQ

David Klee and Jon Shields at the SIOS booth in the exhibition hall

David also presented with Argenis Fernandez from Pure Storage in the Pure booth in the exhibition hall on SQL Server storage benchmarking fallacies.

Heraflux also met with our good friends at Rubrik to discuss the impressive state of their SQL Server-integrated backup platform, who won both the VMworld 2017 Best of Show and Gold awards for their incredible platform.

Argenis Fernandez of Pure Storage, David Klee of Heraflux, Biswaroop Palit from Rubrik

Argenis and David also presented in the Intel booth on modern CPU architectures and VMware vNUMA for enterprise SQL Server workloads.

As you can see, our VMworld USA conference was quite the show.

Just one week later, Heraflux participated in VMworld EMEA in Barcelona, Spain.

Just like in Las Vegas, all of our SQL Server content made the featured videos list! They are now available for you to watch and learn from out on the VMworld EMEA featured videos list.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right [VIRT1309BU] with Michael Corey

Performance Tuning and Monitoring for Virtualized Database Servers [VIRT1430BU] with Thomas LaRock

David also presented a session for the vBrownBag TechTalks series called vNUMA and You.

We even held an impromptu SQL Server architect open Q&A in the VMvillage to help folks successfully improve their SQL Server virtualization experience.

The announcements from VMware at both of these shows were a bit mixed, in our opinion. The announcement of the general availability for VMware Cloud on Amazon AWS is an interesting shift in strategy. Pivotal Container Service shows VMware’s commitment to containers and workload portability, which to us is a sign of the direction of VMware Corp. On-premises virtualization is generally seen as the new beige at this point, and the unified direction of VMware, based on the messaging from these shows, demonstrates that VMware is shifting to attempt to be the conduit between the various platforms for on-prem virtualization and public cloud providers. The jury is still out on how well the industry will adopt and embrace this shift, but we at Heraflux are quite interested to know your thoughts!

We’ll see you at the next one!


Q&A Session with SQL Server on VMware Experts at VMworld EMEA

Greetings everyone! We had so many people stay after our SQL Server on VMware sessions at VMworld USA to ask great questions, I thought I’d extend an offer to everyone at the European show coming up in a week! Let’s talk SQL Server! We are going to crash the VMvillage hang space on Tuesday, September 12 at 3pm local time to hold an open-ended SQL Server on VMware Q&A session. This unscripted and unofficial session is for you, has no official agenda, and marketing is strictly off-limits.

Our illustrious experts include:


Michael Corey, Founder – Corey and Associates

Thomas LaRock, Head Geek – Solarwinds

Argenis Fernandez, Principal Architect – Pure Storage

Niran Even Chen, Double VCDX, VMware Corp.

… and me!

Mark your calendars, and bring your questions, specific challenges, or discussion points, and let’s do this! Anything goes – performance, availability, setup and configuration, conflicts between best practices for SQL Server and VMware, anything!


SQL Server on VMware VMworld USA Videos Now On YouTube

We just saw that our two SQL Server on VMware sessions that David Klee co-presented on Tuesday at VMworld USA, both of which made the top 10 sessions of the day list at the conference, are now on YouTube! They are free to watch for everyone!

For those of you with virtualized SQL Servers, regardless of platform and cloud or on-premises, we urge you to watch these two sessions at your convenience.

Monster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right (VIRT1309BU) (co-presented with Michael Corey)

Performance Tuning and Monitoring for Virtualized Database Servers (VIRT1430BU) (co-presented with Thomas LaRock)


VMworld EMEA SQL Server Sessions

This trip to Barcelona for Heraflux to the next VMworld EMEA conference next week will be our second trip to this conference in two years. David Klee from Heraflux is presenting on SQL Server performance, scalability, and monitoring in three sessions at this conference.

Tuesday 11amMonster VMs (Database Virtualization) with vSphere 6.5: Doing IT Right (VIRT1309BU) with Michael Corey

Wednesday 12:30pmPerformance Tuning and Monitoring for Virtualized Database Servers (VIRT1430BE) with Thomas LaRock

Wednesday 5:30pmvBrownBag session – vNUMA and You (VMTN6680E)

We are also going to hold at least one impromptu SQL Server experts open Q&A session in the VMvillage at some point early in the week, so stay tuned to this blog for when and where to meet up!

If you want to schedule some time to meet, please contact us and schedule some time. We look forward to meeting with all of you at the show!


New Whitepaper - Capture Production Error States

System administrators of the world, if a VM experiences a problem that takes down business-critical application, your job is to get minimize the impact to the business. You are caught in a difficult decision.

Do you repair the VM as quickly as possible, but possibly lose traces of what went wrong. In doing so, that loss of evidence might mean that this outage returns at a future point in time.

…or…

Do you prolong the outage and continue to impact to the business to investigate and get to the root cause of what actually happened so that it does not happen again?

The business almost always pushes you to perform the former, which puts you in a bad position if the VM issue returns.

Now you can do both.

For those of you on VMware vSphere platforms, the latest revision of VMware’s PowerCLI PowerShell extensions contain a little publicized feature that allows you to capture the production server’s error state and preserve it for later investigation so that you can repair the VM as fast as possible to minimize the impact to the business.

Read more about this exciting new feature and how you can leverage the power of this feature to capture the production error state in our new free whitepaper!


SQL Server on Linux Series: Additional Drives

One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if we saw a SQL Server with just one drive (C:) and everything piled on it. The same goes for any other operating system, including Linux. But, how do we get the additional drives added and configured properly? It’s (not) the easiest, but it’s straightforward! Let’s walk through it.

Read more


24 Hours of PASS Session Slides Uploaded

David’s slide deck from the recent webinar series 24 Hours of PASS, Summit Preview session, where he presented a session called Virtual CPUs: Right to Ludicrous Speed, are now available for you to view up at SlideShare. Let us know if you have any questions! I hope to see you all at the PASS Summit later this year!


Upcoming SQL Server User Group Presentations

Coming up in the next week David Klee be speaking at two New England area SQL Server user groups in the next few days! First, on Monday, July 24th, he will be at the Portsmouth, NH, SQL Server Users Group speaking on the newly announced SQL Server on Linux. It’s going to be a blast showing folks that SQL Server on Linux is a viable alternative for businesses out there.

Next, Tuesday, July 25th, he will be at the downtown Boston SQL Server Users Group tomorrow night for a session on Performance Tuning for SQL Server VMs. This session gets a little free-form, as we encourage all attendees to bring your specific questions, challenges, (mis)conceptions, opinions, etc. to the table and let it all out.

RSVP for these events if you’re in the area, and if not, ping us and let us know if your user group would like a presentation on these topics!


24 Hours of PASS, Summit Preview Session

Heraflux is proud to announce that David Klee has been selected to present a session in this year’s 24 Hours of PASS: Summit Preview webinar series entitled Virtual CPUs: Right to Ludicrous Speed. This session is scheduled for July 20th, 2017, at 03:00 GMT, or July 19th at 11pm Eastern.

These webinar series are a sneak peek at some of the sessions to be presented at this year’s PASS Summit in Seattle the last week of October. These sessions are from world class speakers and authors who we have all been studying under for years, and now you can see them live!

Session abstract: One of the largest points of contention with virtual SQL Servers and the VM administrators is how to configure the CPUs. Experience says more CPUs are better for performance. VM admins say less is better. Third-party vendors say you need all of them (and it doesn’t matter how many your hosts have either). Can over-provisioning virtual machine CPUs speed things up, or does it slow things down? What is the right methodology to determine the correct number of virtual CPUs? How does this configuration align with the physical servers? From sampling and analyzing performance data, to “right-sizing’ your SQL Server virtual machine CPU count, to properly aligning the VM with the physical server NUMA topology, you will gain the understanding of how to properly manage and validate your virtual SQL Server vCPU configuration in this insightful session. Valuable tips and tricks will be shared that you can take back to your virtual SQL Servers and immediately apply to your own environments.

Register today to watch these sessions!