3 licensing questions you should ask your SQL Server DBAs

We want to share a few insights into some of the things that drive unnecessary Software License Use. Sometimes all that is missing, is a dialogue.
Share on linkedin
Share on twitter
Share on email

Question #1: Which of these SQL Servers are running in a Active/Passive failover cluster?

In the fine print of the SQL Server licensing documentation, you can find, that if you are running an Active/Passive failover cluster, you need only license the active side of the cluster. Most Software Asset Management tools are unable to detect this, and without user input, will report the license requirement for both the active AND passive side of the cluster. Keeping in mind that each SQL Server Enterprise server drives Software Assurance costs of at least $8,000 a year, you don’t need to find a lot of these in order to reduce costs substantially.

Question #2: Which of these SQL Servers are Test or Development servers, only used by users with a Visual Studio Subscription (Formerly MSDN)?

Another thing that does not show up in SAM tools is the nature of the environment. Many development users and departments have Visual Studio Subscriptions. These include rights to use most Microsoft Software – including all versions of SQL Server – for test and development purposes. Non- Visual Studio Subscription end-users may access these systems as part of acceptance tests. Reviewing your list of SQL Servers with this perspective, we often find a number of test servers you shouldn’t be licensing separately.

Question #3: Could this database run on fewer, faster cores?

Looking at hardware utilization, we normally see nearly all SQL Servers being memory constrained. With the core-based licensing terms, having unused or underutilized CPU capacity is very, very expensive. Replacing existing multi-core CPUs with fewer-core CPUs, often with higher clock-frequencies, can reduce costs while boosting performance. Your DBA may balk – but 2-hour downtime to replace CPUs dwarfs compared to the multi-thousand dollars a year savings.

Kostner creates machine-based analytics software for optimizing license costs in Virtual Server environments. With our data analytics engine, it takes just 2 hours to get a complete picture of your current costs, and optimization potential. If you have any questions contact us at mn@kostner.com.

Interested to learn more? Subscribe to our blog or follow us on LinkedIn

Did you like this article? Please share with your friends

Related Posts

Uncategorized

Save money on Office 365

With all user-based software, you should do three things:
Make sure you only license the users you need to
See if you can use a smaller license package
Consider other options

Ready to Get Savings Done?

Have a short, free on-line meeting with one of our guides, who will explain everything and answer all your questions.