RSS

Tag Archives: DR

Disaster Recovery Rights and License Mobility

 April 2015 PUR

Fail-over server rights do not apply in the case of software moved to shared third party servers under License Mobility through Software Assurance.

Example

Let’s say an end customer purchased a license with software assurance that qualifies for license mobility.  Since SA allows failover rights, most service providers (if not all) are under the impression they would get the same benefit in their datacenter as they would on premise.  In this example, the end customer transfers a SQL license over to the hoster, the hoster spins up a secondary SQL fail-over server.  Given the statement above from the PUR, If they are enabling SQL fail-over they would need a second license under SPLA.

 Why is this important?

For starters, compliance.  If that secondary server is not properly licensed or your under the assumption that if it exists on premise it must also exist in the cloud you are mistaken.

What about Cold DR?

Doesn’t exist anymore.

What about SQL Failover for SPLA specifically?

SQL SPLA licenses have fail-over rights.  Read the SPUR

What about other products for disaster recovery?

The SPUR has specific language around DR, how long the server can be active (non-production), when Windows would need to be reported, etc.

Any workarounds?

SAL for SA – I think this would fit well for DR.  Customer can still run the software on premise and spin up a second server in the cloud.

Normal SALs- 1 user SAL license can access multiple servers.  Could be another option if the customer is against license mobility.

In the words of a famous hoster “it’s not how you license…it’s how long can you get away with not licensing that really matters”  He was audited immediately following that statement.

Thanks for reading,

SPLA Man

Advertisement
 
Leave a comment

Posted by on April 30, 2015 in Disaster Recovery

 

Tags: , , , , , , , , , , , , , , , , , , ,

SQL Enterprise – it’s more than virtualization

I sat in on a webinar this afternoon and was really impressed with the different capabilities within SQL Enterprise.  I always sold SQL based off virtualization needs.  What a goof. Although important, there are several other factors that go into licensing SQL Enterprise as to Standard or Web.

Let’s first break the different components down to better understand the differences.

SQL Web – Basic SKU.  Designed for hosting web apps and websites.  Many hosting providers try to license SQL Web to support line of business applications. (which you cannot do by the way) Think of line of business applications as applications to run your business.  (very poetic by the way).

SQL Standard – The most common reported SKU in SPLA but also the one that gets service providers in trouble; especially as it pertains to virtualization and mobility within server farms.  Offers some high availability, although not as complete as Enterprise.  Database size is also an issue as it only supports up to 64GB.  Sounds like a lot, but ask a SQL admin how much that really is.  Newer editions offer mobility rights, and can be licensed on a per VM basis.  Not a bad thing.

SQL Enterprise – Ahh…SQL Enterprise.  This cost a lot doesn’t it?  Man, how can someone afford this month end and month out?  Ask your reseller what’s the difference between Enterprise and Standard and the first thing they will say is virtualization. (that’s what I did too for the record) Although true, there’s more to this than just virtualization.  For starters, the size alone is more than Standard.  (See chart below).  High availability with Enterprise is truly high availability.  It’s always on (Failover cluster instances and availability groups).  Although costs seem high, if data is lost, how much will that cost you?

SQL BI – The in between SKU, meaning its similar to Standard, but not as robust as Enterprise. In the SPLA world, it is licensed by user only.  This “Jan Brady” of SQL has…..you guessed it….BI features.  This SKU is very rarely reported.  If I had to guess, she will be merged or have licensing changes with future releases. No basis or knowledge, just an educated guess.

So back to SQL Enterprise.  I think the service provider community should listen to what other hosters have to say about SQL. Let’s look at the real IT wizards  (also known as ISV’s – those that develop applications) do with SQL Enterprise.  If you look at the chart below, this illustrates the features they use within Enterprise the most (Source: Microsoft)

Picture1

You can see (kind of unclearly) that scale and performance outweighs everything else. “Scale and Performance” means data compression, table partitioning, etc.  Over 23% say HA/DR is the most important feature. (always on).  I like to listen to these guys (ISV’s) since their business (their application) is only as good as the technology it resides on.  If they rely on a certain product over the other, I would like to better understand…why?  From the chart, it’s no surprise that performance ranks #1.  Imagine if performance was bad?  How good will their application look then?  So if they trust SQL Enterprise based off performance and HA…maybe you should give it a second glance.

From Microsoft, here’s the top 10 reasons hoster’s should consider Enterprise.  Oddly enough, virtualization wasn’t one of them.

1.More than 64GB memory

2.Online Re-Indexing

3.In-Memory OLTP

4.Always On Availability Groups

5.Partition Switching

6.Columnstore Indexes

7.Resource Governor

8.Change Data Capture

9.Transparent Database Encryption

10.Data Compression

Here are some good links on the topic below.  Feel free to check out.

SQL 2014 Overview

http://technet.microsoft.com/en-us/sqlserver/dn135309.aspx

SQL under SPLA

https://splalicensing.com/category/sql-2012/

SQL throughout the years – downloadable documents

http://www.microsoft.com/en-us/search/Results.aspx?q=sql&form=DLC

Thanks for reading,

SPLA Man

 

 

 

 
Leave a comment

Posted by on October 28, 2014 in SQL 2012

 

Tags: , , , , , , , ,

Disaster Recovery Rights for SPLA

Spring.  The time of year in which flowers bloom but storms loom. (I will not quit my day job by the way).  Those reading this article that live in the middle of the United States, you would probably agree with that statement.  Sometimes it may take a storm for organizations to start thinking about their own disaster recovery plans.  Maybe it’s time to get ahead of the storm; that’s why I thought I would spend time reviewing DR, industry best practices, and licensing scenarios.

In previous editions of the SPUR, you were allowed to temporarily run a backup instance on a server dedicated for DR with the following exceptions:  The server must be turned off except for limited testing and DR, may not be in the same cluster, and you may only run the backup instances and production instances at the same time only while recovering from a disaster.

I never understood the rule “the server must be turned off.”  If it’s turned off, how is backing up anything?  Secondly, what is meant by “limited testing?” How much time does it allow you test? Two days…a week…a month?

In the new SPUR, it brings clarity to some of those questions.  From the April SPUR:

“The disaster recovery server can run only during the following exception periods:

  • For brief periods of disaster recovery testing within one week every 90 days
  • During a disaster, while the production server being recovered is down
  • Around the time of a disaster, for a brief period, to assist in the transfer between the primary production server and the disaster recovery server

In order to use the software under disaster recovery rights, you must comply with the following terms:

  • The disaster recovery server must not be running at any other times except as above.
  • The disaster recovery server may not be in the same cluster as the production server.
  • Windows Server licenses are not required for the disaster recovery server if the following conditions are met:
  • The Hyper-V role within Windows Server is used to replicate virtual OSEs from the production server at a primary site to a disaster recovery server.
  • The disaster recovery server may be used only to
  • run hardware virtualization software, such as Hyper-V,
  • provide hardware virtualization services,
  • run software agents to manage the hardware virtualization software,
  • serve as a destination for replication,
  • receive replicated virtual OSEs, test failover, and
  • Await failover of the virtual OSEs.
  • run disaster recovery workloads as described above
  • The disaster recovery server may not be used as a production server.
  • Use of the software on the disaster recovery server should comply with the license terms for the software.
  • Once the disaster recovery process is complete and the production server is recovered, the disaster recovery server must not be running at any other times except those times allowed here.”

If I had a hosting company that specializes in DR solutions, I would have my customers purchase their licenses outright with Software Assurance from their reseller (like SoftwareONE).  I would make sure they deploy it on premise and I would set up a secondary server in my datacenter. Now comes the fun part – how to license the solution!

Let me provide an example.   Let’s say your customer is a law firm and email is extremely important to their business.  They cannot lose email for one minute, let a lone a day.    The customer would like the greatest discount long term but very concerned that if a disaster does happen, they won’t be prepared.  (this is when you come to the rescue).  You have a solution that will allow them to run their Exchange on premise by purchasing Exchange with Software Assurance from volume licensing (greater discount over SPLA long term), and you as the service provider can run Exchange in your datacenter using the SAL for SA SKU.  Never heard of the SAL for SA SKU?  You’re not alone.  This SKU is available for certain applications (Lync, SharePoint, Exchange – check SPUR for availability) and allows the service provider to host the application in a shared (virtual & physical) environment.  More importantly, the cost is extremely attractive AND your customer can still run it on premise.  This is NOT license mobility.  License mobility allows you to run it in a shared hardware but dedicated VM.  It also requires the customer to transfer those licenses out of your datacenter only (not on premise).

Here’s the criteria for reporting SAL for SA for those home gamers.

SALs for SA

“SALs for SA may be acquired and assigned to users who have also been assigned a qualifying Client Access License (“CAL”) with active Software Assurance (“SA”) acquired under a Microsoft Volume Licensing Program or who uses a device to which a qualifying Device CAL with active Software Assurance coverage has been assigned. You may not acquire SALs for SA for more than one user for any given qualifying CAL. Use rights for SALs for SA are identical to their corresponding SALs, as defined in this document. The right to assign a SAL for SA to a user or device expires when the Software Assurance coverage for the qualifying CAL expires.”

Be careful if you decide to go down this route. You have to ensure when reporting SAL for SA that the customer has active SA for the licenses you are reporting.  If they don’t, both you and your customer are out of compliant.  This comes up all the time during audits.  “I swear they own these licenses Mr. Auditor!”  Secondly, make sure the products are SAL for SA eligible when discussing with your client.

In summary, pay attention to the new DR rights mentioned above; consider SAL for SA as an alternative; and last but certainly not least, maybe reconsider your vacation to the Midwest until the Fall – flowers bloom, storms loom.  Hit me up at blaforge@splalicensing.com  if you want to learn more about SAL for SA or anything hosting related.

Thanks for reading,

SPLA Man

 
4 Comments

Posted by on April 30, 2014 in Disaster Recovery

 

Tags: , , , , , , , , , ,

 
%d bloggers like this: