Sql server standard edition 2016 - alwayson

Question

Sql server standard edition 2016 - alwayson

senthil3801

Say Hey Kid

Points: 669
More actions
October 15, 2016 at 6:47 am

#331356

Please let me know how many database can be configured in the always on for SQL standard edition 2016.. Also please share the related msdn site link

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

Two nodes: https://msdn.microsoft.com/library/cc645993.aspx

MS seems to recommend no more than 10 dbs/AG, though this is based on testing of 10 Ags on an instance. More can result in memory issues and thread starvation.

https://msdn.microsoft.com/en-us/library/ff878487.aspx

senthil3801 Say Hey Kid Points: 669 More actions · Answer 2

Sql server standard edition 2016 - alwayson

This is common for the enterprise edition..but do we have any specific links for the SQL standard edition 2016..I know that it can support always on I.e. 1 AG'S...but in that how many databases can we configure?

senthil3801 Say Hey Kid Points: 669 More actions · Answer 3

Thanks for all your replies..finally i got in the msdn..here is the link

https://blogs.technet.microsoft.com/msftpietervanhove/2016/05/10/how-to-set-up-basic-availability-groups-in-sql-server-2016/

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

I got this from someone late last night. 1 database per AG, limited restrictions on how the secondary works.

You can have more than one AG, but each has a single db.

senthil3801 Say Hey Kid Points: 669 More actions · Answer 5

Multiple AG's on the Same SQL Instance?

or Single AG's on Multiple Instances ?

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Standard Edition AG has a single DB per AG, and two servers only. (same as database mirroring was)

If you have multiple DBs that you need to make highly available, you may set up multiple AGs, each with only one database in and two servers)

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

senthil3801 Say Hey Kid Points: 669 More actions · Answer 7

senthil3801

Say Hey Kid

Points: 669

October 18, 2016 at 6:36 am

#1907116

Thanks for the info