<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
High Availability Upgrades
15 posts, Page 1 of 2
1
2
»»
High Availability Upgrades
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, March 01, 2012 11:56 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 7:08 AM
Points: 31,539,
Visits: 13,870
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
crazy4sql
crazy4sql
Posted Friday, March 02, 2012 1:36 AM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 11:13 AM
Points: 876,
Visits: 3,742
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
Markus
Markus
Posted Friday, March 02, 2012 7:11 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 1,059,
Visits: 2,263
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
cfradenburg
cfradenburg
Posted Friday, March 02, 2012 7:41 AM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 10:51 AM
Points: 1,562,
Visits: 1,932
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
Markus
Markus
Posted Friday, March 02, 2012 7:47 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 8:39 AM
Points: 1,059,
Visits: 2,263
One we have right now has 16 cores..... now THAT would be expensive!
Post #1260816
TravisDBA
TravisDBA
Posted Friday, March 02, 2012 7:58 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 10:46 AM
Points: 1,290,
Visits: 3,001
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
crazy4sql
crazy4sql
Posted Friday, March 02, 2012 8:19 AM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 11:13 AM
Points: 876,
Visits: 3,742
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Friday, March 02, 2012 8:31 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 7:08 AM
Points: 31,539,
Visits: 13,870
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
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Friday, March 02, 2012 8:32 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 7:08 AM
Points: 31,539,
Visits: 13,870
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
cfradenburg
cfradenburg
Posted Friday, March 02, 2012 8:37 AM
SSCommitted
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 10:51 AM
Points: 1,562,
Visits: 1,932
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 »
15 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
