SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


High Availability Upgrades


High Availability Upgrades

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)

Group: Administrators
Points: 250274 Visits: 19813
Comments posted to this topic are about the item High Availability Upgrades

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
crazy4sql
crazy4sql
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8143 Visits: 4514
I have read it somewhere that it will work with cluster only.
And the cluster is windows 2008 cluster which is domain independent and can be configured as global domain.

I might be wrong.....

----------
Ashish
Summer90
Summer90
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13003 Visits: 3899
I have to say I don't know all of the details of all of the new features as of yet. However, for the common, basic SQL Server install that doesn't need to scale I really don't see any gotta have features in 2012. The one big difference is the cost will go up based on cores. We have fast tracked three systems to upgrade to SQL2008R2 and are in progress right now simply because of the price increase coming for SQL2012.

Maybe I am wrong though.
chrisfradenburg
chrisfradenburg
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4382 Visits: 2084
Markus (3/2/2012)
The one big difference is the cost will go up based on cores.


That depends on the number of cores. They priced it so that if each proc has four cores then the price will be the same.

Based on the fact that I can't count the number of SQL 2000 boxes we still have on two hands I don't think we'll be making much of a drive for SQL 2012. I'll request that we upgrade our monitoring box to it and outside of that I don't expect to see many others until vendors start supporting it when we upgrade. And even then we may only upgrade certain servers.
Summer90
Summer90
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13003 Visits: 3899
One we have right now has 16 cores..... now THAT would be expensive!
TravisDBA
TravisDBA
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4904 Visits: 3069
It's a feature that I am looking forward to, but am I in a big rush to get to it? No. We have a pretty good high-availbility setup now, so this is not a feature I see as something I am waiting for with abated breath. Actually, I am more interested in going to 2012 for the "Contained Databases' feature than the "AlwaysOn" feature because remapping logins/users and permissions has always been a pain when moving databases around from server to server, or from Production to DEV, or to QA in the past. Also, I am looking forward to the "Restore Database with Timeline" feature as well. These two features are much more important to me right now than "AlwaysOn". :-D

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ...:-D"
crazy4sql
crazy4sql
SSCrazy Eights
SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)SSCrazy Eights (8.1K reputation)

Group: General Forum Members
Points: 8143 Visits: 4514
Just sharing whatever I read online about 2012 features:-

1) contained database
Need to enable this at server level using sp_configure
This database as of now have option to be configured with 2 option. Null and partial. Third option "Full" will be in future release.

2) restore database with timeline
This one is going to be best as now its fully graphical and you can scroll till the point you want to restore.

3) alwayson
Cant remember the exact word I read somewhere, but the meaning was somewhat similar to this:-
Alwayson is the first child of successful marriage of Cluster and mirroring.

4) one good t-sql functionality I liked is "Format". this is really helpful in converting the datetime to local format.

5) Server Level role can be created but the permissions are pre-defined which you have to select from the list. You cant have your own customized permission in this customized role.

I am sure there are lots. Just sharing whatever I know about 2012 and trying to correct and add more in my 2012 KB.

----------
Ashish
Steve Jones
Steve Jones
SSC Guru
SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)

Group: Administrators
Points: 250274 Visits: 19813
Markus (3/2/2012)
One we have right now has 16 cores..... now THAT would be expensive!


16 cores meaning a 4x4 or are they more dense than quad cores? If you have more than 4 cores/CPU, then definitely fast track those upgrades now. I think if you do the math, you'll find that you will be much better off.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Steve Jones
Steve Jones
SSC Guru
SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)SSC Guru (250K reputation)

Group: Administrators
Points: 250274 Visits: 19813
TravisDBA (3/2/2012)
...
Actually, I am more interested in going to 2012 for the "Contained Databases' feature than the "AlwaysOn" feature because remapping logins/users and permissions has always been a pain when moving databases around from server to server, or from Production to DEV, or to QA in the past.


Contained databases look good, but they're only partially working. The user thing should be better, though I'm not sure I'd pay for an upgrade for that.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
chrisfradenburg
chrisfradenburg
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4382 Visits: 2084
The thing I'm most looking forward to with contained DBs is mirroring. I'm worried that we'll hit a failover and a SQL job will have been updated on one server but not the other. I'm not as concerned about users since all requests should go through the DBA team and we can sync the SIDs but we have vendors and app owners that maintain their own jobs.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search