What this Query Store bug tells me?
You may have heard that there’s a bug in SQL Server 2016 related to the query store in non-Enterprise editions. This is a less than dangerous bug, in that in editions of SQL Server 2016 other than Enterprise Edition when the space allocated to the query store fills it stops collecting data. Nothing more dangerous…
The post What this Query Store bug tells me? appeared first on SQL Server with Mr. Denny.
Rise Services: Time Slice DBA and Disaster Recovery
With headquarters in Arizona, Rise is a nonprofit organization that specializes in home and community-based support services for children and adults with developmental and other disabilities, children with mental health challenges, aging adults and children and families with foster care and adoption needs. For 25 years their purpose has remained constant. They create opportunities for […]
How is performance impacted by having too many NUMA nodes?
Having too many NUMA nodes can lead to some really strange CPU behavior. What you’ll probably see is that the CPU workload of the machine isn’t evenly balanced across the CPUs. If for example you have 32 cores on the VM, and you have 16 NUMA nodes, with two cores per NUMA node you’ll probably…
The post How is performance impacted by having too many NUMA nodes? appeared first on SQL Server with Mr. Denny.
I’ll be speaking at PASS Summit 2016
I’m thrilled and honored to have been selected to speak at the PASS Summit again. This year I’ll be presenting a session titled Database Security in SQL Server 2016 and beyond. In this session we will review the new enhancements to SQL Server security available in SQL Server 2016 and Azure SQL DB, including Always…
The post I’ll be speaking at PASS Summit 2016 appeared first on SQL Server with Mr. Denny.