Educational Episodes: Hyperconverged Infrastructure (HCI)

Some time ago, while looking through what SQL server Basic Availability Groups (BAG) can do, I found an awesome article by Pieter Vanhove: https://blogs.technet.microsoft.com/msftpietervanhove/2017/03/14/top-5-questions-about-basic-availability-groups/. There was nothing about performance, though, so I thought: “Hey, why not write an article about BAG performance?” Later, I realized that you need to compare this performance to something else, right? So, I decided to add SQL Server Failover Cluster Instance (FCI) performance measurements. Maybe, I’ll add some SQL Server Availability Groups (AG) measurements at the end; but, let’s see first whether SQL Server FCI can run twice as fast as SQL Server BAG. In this study, I measured BAG performance alone. Now, as we know the scope of the article, let’s move on!

This post will be pretty handy for those who rely on their memory too much because it discusses how to reset vCenter Server Appliance root password.

Whether you’re new to the idea of a CI/CD pipeline or have tried this development practice before and are simply looking for ways to optimize the process, this article is for you.

In this post, I am going to take a closer look at the impact of read-only routing on SQL Server Availability Groups performance. I measured SQL Server Availability Groups (AG) performance before (https://www.starwindsoftware.com/blog/hyper-v/can-sql-server-failover-cluster-instance-run-s2d-twice-fast-sql-server-availability-groups-storage-spaces-part-1-studying-ag-performance/). And, a guy from Reddit  recommended enabling read-only routing to achieve higher performance (find more about this policy here: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-read-only-routing-for-an-availability-group-sql-server?view=sql-server-2017). Thanks for your comment, man! I highly appreciate your efforts. This article will shed light on how read-only routing affects SQL Server AG performance.

Microsoft released in February 2019 a new service called Azure Lab service. With Azure Lab Services, you can easily set up and provide on-demand access to preconfigured virtual machines. Thanks to a dashboard, you can also keep your budget in check by controlling exactly how many hours your lab users can use the virtual machines.

Some time ago, discussing how cool VMware vSphere 6.7 Update 1 is, I briefly mentioned content libraries. That article was just an overview, so I decided not to go into details, saying that some features need their own posts. In today’s article, I’d like to share my hands-on experience with content libraries and help you to decide whether this feature can make your life any easier.

Admins shut down their hosts for servicing from time to time. After closing for maintenance one node, vSAN cluster resources are to be re-distributed, and here Maintenance Mode comes into play. Today, I’d like to discuss the whole idea of maintenance mode and its options.

Having actual physical resources today as a foundation of IT infrastructure starts to look like an extravagant decision, to say the least. Why bother with extra resources, if you can make things happen faster, better, with less hardware footprint? However, virtualization development is far from the end. The latest idea on the horizon is the concept of composable infrastructures, which is more complicated than it sounds.

Anyone who has ever heard of virtualization technology has heard of VMware. This company is one of the industry leaders, and instead of resting on its laurels continues to develop flagship projects such as vRealize Operations Manager (vROPS). The latest update of this product introduces quite a few new features and enhancements. You can not only find out about the pros and cons of vROPS 7.5 but how to deploy and configure it in the VMware environment!