sqlrus.com // dba // bat whisperer
Sometimes what you have just isn’t enough to get the job done. In certain workloads, having additional CPU might be beneficial for the immediate workload, especially when discussing SQL Server. In the old days, dynamcially adding more CPU horsepower wasn’t an option unless you magically had another physical server with […]
In today’s modern world, virtualization is often used to help mitigate cost as well as to provide flexibility in scaling for performance workloads. It’s very easy to scale a virtual machine with a few mouse clicks and a brief outage while it reboots. If you are running VMWare on-premises, this […]
Synology has a wide range of capabilities but sometimes it still falls short. In a previous post, I mentioned moving existing virtual machines to my Synology DS920+. The movement of the virtual machines required configuring the virtual machine locally on my laptop and then subsequently moving the “bundle” to the […]
One of the reasons that I enjoy having a Synology DS920+ around is that that I can use it to experiment with virtualization. In this experiment, I’m going to move a virtual machine that I configured through VMWare’s Fusion which is running on my Mac laptop. This is just a […]
What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows for increased CPU & memory performance. This is because a memory bank is physically adjacent to a CPU socket on the motherboard of the server. Each combination of memory and […]
No, not that kind of volume! Over the past couple of blog posts, I have been talking about the versatility of deploying SQL Server with Docker. This combination is a great way to quickly and easily spin up local SQL Server instances. In the most recent post, I talked about […]
Last month I blogged about using Docker to run SQL Server as a quick and easy way to get SQL Server up and running. While it continues to be immensely useful, there aren’t any user databases running on it. The only databases present are the system databases. Yes, I could […]