Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

High Availability Upgrades Expand / Collapse
Author
Message
Posted Thursday, March 1, 2012 11:56 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:10 AM
Points: 31,279, Visits: 15,738
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
Post #1260633
Posted Friday, March 2, 2012 1:36 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:34 AM
Points: 882, Visits: 4,125
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
Post #1260661
Posted Friday, March 2, 2012 7:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:57 PM
Points: 1,314, Visits: 2,897
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.



Post #1260779
Posted Friday, March 2, 2012 7:41 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 27, 2014 8:55 AM
Points: 1,639, Visits: 1,985
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.
Post #1260806
Posted Friday, March 2, 2012 7:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 12:57 PM
Points: 1,314, Visits: 2,897
One we have right now has 16 cores..... now THAT would be expensive!


Post #1260816
Posted Friday, March 2, 2012 7:58 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 2:03 PM
Points: 1,334, Visits: 3,069
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".

"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1260823
Posted Friday, March 2, 2012 8:19 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 17, 2014 2:34 AM
Points: 882, Visits: 4,125
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
Post #1260853
Posted Friday, March 2, 2012 8:31 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:10 AM
Points: 31,279, Visits: 15,738
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
Post #1260865
Posted Friday, March 2, 2012 8:32 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 11:10 AM
Points: 31,279, Visits: 15,738
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
Post #1260866
Posted Friday, March 2, 2012 8:37 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 27, 2014 8:55 AM
Points: 1,639, Visits: 1,985
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.
Post #1260873
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse