PASS Summit Speaker Idol 2016 Is a Go!
If you have attended the PASS Summit for the last couple of years you probably heard about the PASS Summit Speaker Idol competition that has happened for the last couple of years. If you haven’t, you are now. For those that haven’t been to the PASS Summit before its a great conference to learn a…
The post PASS Summit Speaker Idol 2016 Is a Go! appeared first on SQL Server with Mr. Denny.
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.