October 11, 2013 at 5:10 am
Hi Experts,
In my environment we are hosting a new projects which is DW and also a very bulky DBs in TBs.
> what type of HADR solution is available for fasttrack databases in MS SQL Server 2012?
>what type of HADR is available for SQL serevr 2012 for this heavy DBs?
PLease advice.
"More Green More Oxygen !! Plant a tree today"
October 11, 2013 at 8:25 am
Minaz (10/11/2013)
Hi Experts,In my environment we are hosting a new projects which is DW and also a very bulky DBs in TBs.
> what type of HADR solution is available for fasttrack databases in MS SQL Server 2012?
>what type of HADR is available for SQL serevr 2012 for this heavy DBs?
PLease advice.
There are NUMEROUS options for HADR, but you MUST first determine what you NEED is for each of those two things (HA and DR are VERY different things). Here are some options that may be available to you:
1) tlog shipping
2) database mirroring
3) "Always On"
4) simple backup and restore
5) SAN snapshot
6) SAN replication
7) VM snapshot
9) SQL Server replication
Each of those (that your system provides) comes with all kinds of benefits, detractors, costs, overhead, admin needs, etc, etc. HA/DR are CRITICAL to a company's viability, so please do NOT simply slap something together. You will literally be putting your company's very existence at risk (and yes, I do know of companies that have suffered significantly and even gone out of business because they screwed up HA/DR)!!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 13, 2013 at 8:56 pm
Thanks Kevin , If I consider only HA solution , is fasttrack databases support all the features of MS SQL Server 2012 ( Always ON) ?
If yes, do the fasttrack databases HW have any kind of HA for the storage?
"More Green More Oxygen !! Plant a tree today"
October 14, 2013 at 4:47 am
Each option has its own merits.
For example Always on supports active secondaries so you can support read\write operations on one instance and read operation only on others allowing you to offload some processing to other SQL instances, but this also means that you require a copy of the databases on each server which in turns means lots of storage and inevitably the time it will take to setup the mirroing between each.
Clustering would give you a high percentage time wise for availability but there is only 1 copy of your data on shared storage, meaning potentially one point of failure and under utilised servers as the passive node(s) are doing nothing while the active node is servicing all requests.
You really need to understand what you want to achieve , rather than looking at the technologies available first.
MCITP SQL 2005, MCSA SQL 2012
October 14, 2013 at 1:22 pm
Minaz (10/13/2013)
Thanks Kevin , If I consider only HA solution , is fasttrack databases support all the features of MS SQL Server 2012 ( Always ON) ?If yes, do the fasttrack databases HW have any kind of HA for the storage?
FastTrack is just SQL Server, with some requirements about how you setup, load and manage your EDW. Note that if you DO enable AG, you are stepping outside the prescribed construct of FTDW. But as long as your load window isn't stretched out too far due to having to sync up the ETL load to the secondary(s), then it shouldn't matter. If you are frequently adding new data, such as hourly, then the mirroring of the data over to a secondary could start to have an effect.
IIRC the storage for FTDW is usually boxes of disks set up in RAID1 pairs with a hot spare and also with redundant power supplies and IO ports, so it does have HA facets.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
October 24, 2013 at 6:47 am
Thanks Kevin for the wouderfull explanation.
"More Green More Oxygen !! Plant a tree today"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply