Understanding Server 2012r2 Clustering
-
@Carnival-Boy said:
Maybe I missed it, but it seems there is a huge amount of discussion are HA and SANs on Spiceworks, but relatively little on application clustering and DAGs or SQL Server resilience. So this thread is something of an eye-opener for me.
I'm on a good percentage of those discussions (I think) and DAG does not come up too often. Very often the people considering SANs are not actually listing their workloads and only, so they say, trying to get the platform to HA and not really considering if that fixes the workloads or not. But for SMBs, applications that have DAG available to them are few. Exchange tends to be hosted. SQL Server tends to be the Express (no DAG) edition.
But lots of workloads are similar, even without DAG. Active Directory Domain Controllers don't use DAG but have their own application layer failover. Same for MySQL and other databases.
-
@Carnival-Boy said:
If you work on the premise that databases aren't a good fit for VMware HA and shouldn't be installed on a (non-redundant) SAN then I believe you rule out nearly every mission critical system an SMB is likely to use.
Absolutely. This is what I've been saying to SMB - SAN is for one purpose only scale. Spiceworks even had me give a webinar in February about that. SMBs look to enterprises for "what to do" but enterprises all have scale (by definition) and SAN is about cost savings for them. SMBs tend to look at SAN not understanding its purpose and being confused by enterprise storage consolidation and thinking that that somehow applies to them, which it does not. Not that no SMB should have SAN, but it is few and far between and always for the purpose of storage consolidation at scale. SAN does not provide reliability, SAN hurts reliability but can be beneficial for other reasons and made (at cost) to overcome the inherent reliability concerns.
HA is not as much a "never for SMBs" thing as SANs, but it should be rare. SMBs often think that they need HA far beyond the needs of huge enterprises like investment banks (think Canary Wharf) and other enormous, big money loss outage companies. Some need HA and some get HA for cheap which changes the equation (Active Directory HA is super cheap) but going after platform HA (what VMware offers) rarely does what they think and almost never makes sense. It's really focused on technology like web servers where load balancers have not been implemented.
-
@Carnival-Boy said:
Thinking of my own environment, I have ERP, Sharepoint, EDM, Exchange and AD, all of which are databases. It's only really the file server that isn't (and a lot of that is moving to the Sharepoint and EDM servers). The other servers aren't really mission critical and/or are fairly static, like print servers, so can be fired up from a backup very easily without significant loss of data.
File servers are typically "good" HA workloads. Minor risk for data loss and data loss is typically really tiny (like one file or two that you can restore as a single file from backup rather than the whole system). There are other solutions to consider. DFS on Windows, for example, and full fault tolerance with DRBD on Linux or HAST on FreeBSD. These can be complicated to implement, but are all free. In cases where you might spend a lot of money on VMware's HA offering, you could go beyond HA to complete fault tolerance without using VMware, for free (but with some effort.)
So in that case, it is a trade off depending on your needs.
-
@Carnival-Boy said:
So protecting and managing databases becomes the key. And the resellers I've dealt seem to have very little knowledge or experience of SQL Server. Possibly because they're from a hardware background, or possibly because there isn't much money in SQL Server in the SMB marketplace. So they're pushing a hardware solution when a software solution is what SMBs really need (I guess).
The profit margin and "not my fault, call the vendor" benefits of a SAN are enormous. A single sale might set up a salesman for a month or two without needing to make another sale. And the "blame the vendor" benefits are huge. It's very hard to complain to your salesman when a SAN fails, they have another throat to give you to choke. Whereas if they recommend something else, the only throat to choke might be theirs, and they don't want to deal with that even if it is in your interest.
You are correct, there is very little call and very little money in SQL reliability for the SMB. It would be rather surprising that any salesman have been trained on and often might not even be aware of how databases really work. Database skills tend to be more enterprise leaning.
-
@scottalanmiller said:
But for SMBs, applications that have DAG available to them are few. Exchange tends to be hosted. SQL Server tends to be the Express (no DAG) edition.
Oh really? What's the definition of SMB? I don't have a lot of experience. Most of the companies I've worked for have around 100 users. In Europe we use the term SME which I think is generally up to 250 employees. I'd have thought anything over 50 users and you would be avoiding Express for mission critical applications and anything over 150 users and you'd be giving serious consideration to database availability and using Enterprise licencing and features.
-
@Carnival-Boy said:
Oh really? What's the definition of SMB? I don't have a lot of experience. Most of the companies I've worked for have around 100 users. In Europe we use the term SME which I think is generally up to 250 employees. I'd have thought anything over 50 users and you would be avoiding Express for mission critical applications and anything over 150 users and you'd be giving serious consideration to database availability and using Enterprise licencing and features.
There is no hard and fast rule, but pretty typically SMB is 20 - 500 users (but lots of people disagree, many say 1 - 200, IBM says 2,000 - 5,000, etc. IBM considers anything under 2,000 to not be a business.) SME, in the US, is the category above SMB. Sort of. But the names, of course, make no sense at all. But SME is generally used to refer to larger, maybe 250 - 1,000, person companies.
But regardless of those murky definitions, most companies under 500 users that I see tend to use Express. That doesn't mean that lots don't, but most tend to try to go for free. Database needs for SMBs tend to be pretty light and only so many workloads use SQL Server.
At 100 users I'm not sure I've seen enterprise licensing in more than one or two companies. It's decently rare there, I think.
Now what really tends to make sense for companies in that range is to often not have SQL Server at all since it is extremely expensive and the prices really only tend to make sense for larger businesses where the benefits of SQL Server can be leveraged. You can get the high end features of SQL Server for free from players like PostgreSQL.
-
If you think about SQL Server availability cost, getting an HA SQL Server setup is very costly. In a typical (what's typical?!?!) 100 person company, the cost can be brutal. Data loss might be of serious concern, but generally uptime is not (is four years once a decade worth tens of thousands of dollars to protect against?) A good, single server setup for database with good RAID and good backup can reduce the risk of data loss to extremely low levels while keeping availability to perfectly acceptable levels (for most companies.)
It takes a bit of risk analysis and every business (and workload) is unique. But pretty often, HA is not needed. Even for 1,000 person companies for nearly all workloads.
-
@scottalanmiller said:
most companies under 500 users that I see tend to use Express.
Gosh. Obviously 500 users doesn't mean 500 concurrent users, but still, I wouldn't want 500 users accessing Express. That performance can't be great.
For ERP systems where a new system can run into hundreds of thousands of dollars, the cost of SQL Server Standard is pretty trivial in my opinion. It's less than $10k for a basic 2 core licence.
-
@Carnival-Boy said:
Gosh. Obviously 500 users doesn't mean 500 concurrent users, but still, I wouldn't want 500 users accessing Express. That performance can't be great.
Well keep in mind that most applications that would be talking to a database would not be being used by 500 users in a 500 user company. There are cases where that would happen, but many where it would not.
Think about an accounting system. That might use SQL Server. In a 500 person company, maybe 20 would access that particular system. Lots of systems are like that.
ERP is a heavy one, typically, and often used by many people. But most companies don't use ERP.
-
@Carnival-Boy said:
For ERP systems where a new system can run into hundreds of thousands of dollars, the cost of SQL Server Standard is pretty trivial in my opinion. It's less than $10k for a basic 2 core licence.
You don't get DAG with Standard, though.
-
@scottalanmiller said:
But most companies don't use ERP.
Ah, right. That'll explain it then. I work in ERP so in my world *every *company uses ERP.
