CPU Affinity Mask & TF8002

January 13, 2023

Setting CPU affinity in SQL Server is not a task you do every day. Rarely are there use cases when you need to do that. I had a recent requirement to do it. We plan to replace a physical server with half of its current CPU. Primarily due to faster CPU and workload moved off of […]

Capital Area SQL Server User Group

January 9, 2023

View Event: What the heck is a checkpoint, and why should I care?An 8K page is the fundamental unit of data storage in SQL Server. SQL Server performs every data modification operation in memory (buffer pool) for performance reasons and does not immediately write it back to disk. This is where checkpoint comes into play. […]

profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook