How many NUMA nodes should I have if I have lots of RAM and just a few cores?
There are some systems out there which have a lot of RAM, but only a few processors and these machines may need a non-standard NUMA configuration in order to be properly setup. For this example, let’s assume that we have a physical server with 512 Gigs of RAM and two physical NUMA nodes (and two…
The post How many NUMA nodes should I have if I have lots of RAM and just a few cores? appeared first on SQL Server with Mr. Denny.
Still Time To Register For Internals for Query Tuning
There is still time to register for the fantastic class Internals for Query Tuning Class with Kalen Delaney. This fantastic three day class will teach what you need to know in order to better understand how SQL Server uses indexes, and how SQL Server uses indexes in order to process queries. After taking this class…
The post Still Time To Register For Internals for Query Tuning appeared first on SQL Server with Mr. Denny.
SQL Server on Linux?!?!?!
In case you missed the announcement today, Microsoft SQL Server is going to be running on Linux soonish (mid 2017). This is some pretty big and interesting news. The first thing to keep in mind is that this isn’t wholly unprecedented. This will be the second time that Microsoft SQL Server has run on an…
The post SQL Server on Linux?!?!?! appeared first on SQL Server with Mr. Denny.
Now is time to upgrade your SQL 2005 Servers
Time is running out for your SQL Server 2005 instances. In just a few short weeks SQL Server 2005 support from Microsoft will be ending. This means that it’s time to get those servers upgraded to something newer. If you are working on a PCI compliant system, you’ll need to get this fixed before your…
The post Now is time to upgrade your SQL 2005 Servers appeared first on SQL Server with Mr. Denny.