Installing VSPerf in a server environment

Troubleshooting code issues in production is always a challenge, without affecting the performance of the application. Usually we are tied to application logging or tools like the ones from Sysinternals to have a quick pick under the hood. In this article I am going to introduce VSPerf, a component from Visual Studio with which you are able to profile applications on Windows 2012/Windows 8 or later.

SPN's deleted during cluster failover

This article is describing SPN’s disappearing while failing over a clustered instance. But this behavior can be applicable also to other services.

NUMA configuration issues on VMs running SQL Server

Non-uniform memory access (NUMA) is a computer memory design used in multiprocessing, where the memory access time depends on the memory location relative to the processor. Under NUMA, a processor can access its own local memory faster than non-local memory (memory local to another processor or memory shared between processors) ¹

While configuring a SQL Server environments, it is very important to understand the underlying NUMA architecture. SQL Server has its own scheduling system, the User Mode Scheduler (UMS) which is NUMA aware.