SQL Server with Mr. Denny


March 23, 2016  4:00 PM

How many NUMA nodes should I have if I have lots of RAM and just a few cores?

Denny Cherry Denny Cherry Profile: Denny Cherry
Database performance, NUMA, SQL Server

2894816411_01dc38281c_zThere 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 CPU sockets). We have a VM running in that machine which has a low CPU requirement, but a large working set. Because of this we have 4 cores and 360 Gigs of RAM presented to the VM.
Now the default configuration for this would be to have a single NUMA node. However this isn’t going to be the best configuration for the server. The reason that this isn’t the best possible configuration is because all the memory which is allocated to the VM can’t fit within a single NUMA node. Because of this fact we need to tell the hypervisor that we want to split the four cores into two separate NUMA nodes which will allow the hypervisor to split the memory across the two physical NUMA nodes evenly, presenting two NUMA nodes to the guest with 180 Gigs of RAM from each NUMA node. (How you do this depends on the hypervisor that you’re using.)

Once this is done SQL will now know which NUMA node the memory and CPUs are assigned to, and it will correctly place work onto the correct CPU based on the NUMA node which contains the data which the work (query) needs to access.
Now every machine should not be configured this way if there is a small number of cores. The only time this becomes an issue is when there is less physical RAM per NUMA node than we are presenting to the guest OS.
How do we know how much RAM there is per NUMA node? You’ll probably need to ask your server team. The general rule is RAM/CPU Sockets. In the example above we have 512 Gigs of RAM with two CPU Sockets. In modern servers each CPU socket is usually its own NUMA node, however this may not be the case in the servers you are working with. And the CPU sockets only count if there is a processor physically in the socket.

Hopefully this helps clear up some things on these servers with these odd configurations.

Denny

March 15, 2016  4:00 PM

Still Time To Register For Internals for Query Tuning

Denny Cherry Denny Cherry Profile: Denny Cherry
DBA training, SQL Server, SQL Server 2012, SQL Server 2014, SQL Server 2016

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 you’ll be able to better tune your SQL Servers reducing the need to upgrade the server hardware, allowing you to extend the life of your servers and reduce the need to purchase additional SQL Server licenses.  This can lead to a savings of tens of thousands of dollars per year.

All this for a small cost of $2225 for the class.  For those looking for a great investment in their career and their business, here it is.

We look forward to seeing you at the class April 4th-6th, 2016 in Orange County, CA.  So go get registered today.

Denny


March 8, 2016  12:33 AM

SQL Server on Linux?!?!?!

Denny Cherry Denny Cherry Profile: Denny Cherry
Linux, SQL Server

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 OS other than Windows. Keep in mind that originally Microsoft SQL Server ran on OS/2 (version 1.0 and 1.1), it didn’t run on Windows until 4.21, and it wasn’t built specifically for Windows until SQL Server 6.0 shipped.

Denny’s Thoughts

Personally I think this is a really interesting path for the product to take. Obviously Microsoft isn’t going to be dropping Windows support or anything. This is simply a new avenue for Microsoft to explore in order to gain access to the open source application developer. SQL Server running on Linux is actually something that I’ve thought about in the past, and at the same time both wondered why they didn’t do it, and knew exactly why they didn’t do it.

When I first heard that this was something that they were exploring I was hesitant, but I could see the possibilities for the product as well as for the development communities that currently rely on MySQL/Postgress/etc. as they can install them on Linux/Mac OS/etc. as a package when doing their software development. Developers working on software which is running on a single machine, where that machine isn’t running Windows, is a large market of people. These folks often just need a RDBMS behind their application, and they want something which they can simply install on their machine and get up and running quickly and easily so that they can deploy their software. Currently packages like MySQL and Progress make this very easy for them to do. But wouldn’t it be nice if these same software developers could use an RDBMS which is much more fully featured with things like ColumnStore and Hekaton (In Memory OLTP) and which comes with an Enterprise Class support team at the vendor (Microsoft). The developers could even leverage this level of support when deploying their application to their customers.

Joey’s Thoughts

So I was on a plane, and a little secret, we had hints that this was coming. I’ve been perusing Twitter and seeing a lot of people thinking this is a big shot across the bow at Oracle, and it really isn’t. I’m not going to discuss Oracle’s recent financials (hint—they haven’t been selling a lot of net new RDBMS licenses). Like Denny mentioned above, a lot of development work is on Macbooks (I’m writing this post on one right now), and a lot of devs are more used to Linux rather than Windows. If I were writing this post in 2002, I would think this move would be targeted at large enterprises because UNIX > Windows. Frankly, since 2008 Windows has mostly been on par with Linux and is better in several areas. This is all about giving developers a full robust RDBMS platform with good support. Will it be a full featured enterprise RDBMS tomorrow? Probably not, but the core engine will be there, and features will come over time.

My favorite part of SQL Server on Linux? My Bash scripts for automation work again.

Our Thoughts

Now there are clearly going to be a lot of questions that need to be answered. But this is going to be a very exciting time for those in the SQL Server community who are willing to learn about a new OS, embrace the command line (there’s almost never a GUI for Linux Servers), and not be afraid of a little change in the ecosystem.

Denny and Joey

 


March 2, 2016  4:00 PM

Now is time to upgrade your SQL 2005 Servers

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server, SQL Server 2005

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 next PCI audit.  One of the requirements of PCI compliance is that the system be supported by the vendor.  Because support has ended for these older system from Microsoft they are no longer qualified to host systems which are PCI compliant.  Because of this you’ll want to start planning your upgrade project now.

If you need assistance with your upgrade project, reach out to our team.  We’d love to talk to you about your upgrade projects and how we can help get your systems onto supported version of Microsoft SQL Server.

Denny


February 24, 2016  7:00 PM

How to make SSMS beep when a query is done?

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server, SQL Server Management Studio

The other day I’m sitting at my computer, and this comes across Twitter. ssms

Well the good news is that there’s no need to develop anything. SQL Server Management Studio can already do this for you. Simply open SSMS, then click on Tools > Options. In the Options window open Query Results > SQL Server and check the check box next to “Play the Windows default been when a query batch completes” and click OK.

ssms2

The next time you run a query (you might need to close all your query windows or restart SSMS, you usually do with this sort of change in SSMS) it’ll beep when the query is done.

Personally I’ve actually used this as an alarm clock when doing long running overnight deployments so that I’d get woken up when the script was done so I could start the next step. It’s also handy when you want to leave the room / your desk while queries are running.

Don’t forget to turn up the volume when leaving and turn it back down when you are done.

If you were wondering how long this feature has been in SSMS, I was first using it in Enterprise Manager, in SQL 2000.

Denny


February 16, 2016  7:47 AM

SQL Performance Tuning and Optimization Precon at Boston SQL Saturday

Denny Cherry Denny Cherry Profile: Denny Cherry
Database optimization, Performance tunning, SQL Server

FastAre you looking for some SQL Server Performance Tuning and Optimization training?  Are you planning on attending the Boston SQL Saturday on March 19th, 2016?

Have I got a deal for you.  I’ll be presenting my precon SQL Performance Tuning and Optimization on Friday March 18th, 2016.  For just $249 you can attend this full day training event and learn how to use everything that you get for free with SQL Server to help you tune your system to get more performance from the SQL Servers that you have today.

This is a great session, at a great price. And I hope that I’ll see you there.

So go get registered before time runs out.

Denny


February 8, 2016  7:40 PM

Would you like Microsoft to pay for you to move to Azure?

Denny Cherry Denny Cherry Profile: Denny Cherry
Cloud azure, Cloud migration, SQL Azure, SQL Server, SQL Server migration, Windows Azure

Have you been wanting to move some of your services up to Azure, but you don’t have the budget to move them up to thCloude cloud? Microsoft has an excellent deal for you. Microsoft will pay for (at least part) of the consulting time needed to get you migrated into Azure.  These funds can be used to help you plan your migration so that all of the “i”s are dotted and the “t”s are crossed before you start to implement your Azure migration.

Planning a Migration from on-premises to Azure is key to ensuring that you have a successful migration.  An unsuccessful migration is costly, and painful and is something that we want to avoid at all possible cost.

Getting Microsoft to pay for planning your Azure Migrations is surprisingly easy, there is only one major requirement, that you currently have Software Assurance on your systems, somewhere.  As a customer with Software Assurance you have various benefits that come with your Software Assurance, one of which is consulting hours to assist you with migrations to the Microsoft Azure platform.

Activating this benefit can even be done without having to talk to anyone from Microsoft.  You just need to log into your Microsoft Licensing Service Center and activate the benefit from there.  We can even help walk you though the benefit setup and getting your vouchers.

The good news here is that Denny Cherry & Associates Consulting is setup to accept those vouchers, so you can have Microsoft pay for your migrations into Azure.

If you having been thinking about moving into Azure, and you are looking for some help in getting that done contact us.  We’ll walk you though the process of getting your vouchers and use those to help you have a successful migration from your current environment to the Microsoft Azure Cloud Platform.

Denny


February 5, 2016  7:19 PM

DCAC Now Has 2 VMware vExperts

Denny Cherry Denny Cherry Profile: Denny Cherry
SQL Server, VMware

I’m thrilled to report that Denny Cherry & Associates Consulting now has not 1, but 2 VMware vExperts in our ranks.  No we didn’t go off and hire another consultant.  VMware has decided that this year they will recognize both Myself (Denny Cherry) and Joey D’Antoni for all the community work that we’ve done with Virtualization by awarding us the VMware vExpert award for 2016.

You can see the list of 2016 vExperts on VMware’s blog or in the vExpert directory (won’t be updated for a couple of weeks).

I know that I can safely speak for Joey when I say that we are both honored to receive this award from VMware.  While there are a decent number of vExperts each year, the number of vExperts that are SQL Server Professionals is very small.  Looking though that list I can see only a couple of people besides myself who have deep knowledge of SQL Server, so it’s pretty exciting that we make up somewhere around 1/2 of the SQL Server expertise within the VMware vExpert program.

Thank you to VMware for recognizing myself and Joey. And thank you to the members of the community who attend our sessions and read the content we post about VMware and SQL Server.

Denny


February 3, 2016  7:00 AM

Fixing a storage pool that doesn’t have an read-write server

Denny Cherry Denny Cherry Profile: Denny Cherry
Cluster, SQL Server, Storage space

Recently I was working on a clients file server cluster and while doing some troubleshooting with Microsoft Support one of Storagethe clustered disks wouldn’t respond correctly. Now this file server cluster is setup in Azure so it is using SIOS Data Keeper to replicate the data between the nodes of the cluster.

The state that the cluster was in looked something like this.

sios

In this configuration the cluster has two nodes FILESERVER01a and FILESERVER01b. The cluster is named FILESERVER01 and the name that users access files through is FILESERVER01V01.  The top three drives were working exactly as expected, but the last one wasn’t working at all.  Nothing could talk to it, nothing could manage it.

Thanks to Dave Bermingham (Clustering MVP, SIOS Employee and all around good guy) we found a forum thread that talked about this same problem and that the root cause was that the pool was registered as a cluster object within Failover Cluster manager.

Once I went into the failover cluster admin and remove the failed object for that pool I could attach the virtual disk again.  Then I just needed to configure the disks to automatically attach on reboot.  That’s easy enough to fix with a little PowerShell.

get-virtualdisk {DiskName} | set-VirtualDisk -IsManualAttach $False

Then into computer management to bring the disk online (or reboot, but this is easier).  Then resetup the SIOS software to replicate and away the data went.

Thankfully it’s fixed, and I can get back to the problem at hand of figuring out the EFS problem on the cluster.

Denny


January 25, 2016  4:00 PM

Feed Monsters now supports Two Factor Authentication

Denny Cherry Denny Cherry Profile: Denny Cherry
RSS, SQL Server, Two factor authentication

In case you missed the big announcement last week, Feed Monsters was released to the public so that you can now do most6878554296_4c8918c9a9_m of what Yahoo Pipes allowed you to do with your RSS feeds back before it was shut down.

While the service has only been available for about a week now there have actually been several enhancements that have been made live.  The most important of these is two factor authentication, which includes support for emailing the two factor codes to you as well as supporting 3rd party applications for code generation on your phone like Google Authenticator, Duo Mobile, etc.  Having two factor authentication enabled for your account will help to ensure that no one but you can possibly make changes to your monsters or see what the settings for your monsters are.  Enabling two factor authentication is done via the settings page.  While it does take a couple of steps to get setup, it shouldn’t take more than 30 seconds to enable and begin using.

Denny


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: