July 24, 2017 at 10:02 am
Hi guys sure you can help
We have many MYSQL Servers 100 + in a datacentre UK each belonging to a differemt t client. I want to do a linked server to all or most of the them. either through an instance or multiple ones if needed Am I allowed to do that with a single license? How many Instances can a 2016 standard/enterprise support these days if so?
July 24, 2017 at 10:24 am
sqlmatt 1398 - Monday, July 24, 2017 10:02 AMHi guys sure you can help
We have many MYSQL Servers 100 + in a datacentre UK each belonging to a differemt t client. I want to do a linked server to all or most of the them. either through an instance or multiple ones if needed Am I allowed to do that with a single license? How many Instances can a 2016 standard/enterprise support these days if so?
As MySQL is a non-Microsoft product, the question is not really valid, as there is no limit (AFAIK) on the number of linked servers an instance can have.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 24, 2017 at 10:28 am
sqlmatt 1398 - Monday, July 24, 2017 10:02 AMHi guys sure you can help
We have many MYSQL Servers 100 + in a datacentre UK each belonging to a differemt t client. I want to do a linked server to all or most of the them. either through an instance or multiple ones if needed Am I allowed to do that with a single license? How many Instances can a 2016 standard/enterprise support these days if so?
I would guess you mean SQL Server and not MySQL?
For SQL Server, the linked servers don't really have much to do with licensing. You license your instance and it can have many linked servers. You can have 10 licensed instances that all have the same linked server to a different instance
You can have 50 instances on a stand alone server and 25 instances on a fail over cluster with shared disks or 50 instances if using SMB shares for the storage. Of course you could be limited by whatever resources are available on the server or servers.
You can find the maximum capacity specifications for SQL Server in the following documentation:
Maximum Capacity Specifications for SQL Server
Sue
July 24, 2017 at 11:07 am
Sue_H - Monday, July 24, 2017 10:28 AMsqlmatt 1398 - Monday, July 24, 2017 10:02 AMHi guys sure you can help
We have many MYSQL Servers 100 + in a datacentre UK each belonging to a differemt t client. I want to do a linked server to all or most of the them. either through an instance or multiple ones if needed Am I allowed to do that with a single license? How many Instances can a 2016 standard/enterprise support these days if so?I would guess you mean SQL Server and not MySQL?
For SQL Server, the linked servers don't really have much to do with licensing. You license your instance and it can have many linked servers. You can have 10 licensed instances that all have the same linked server to a different instance
You can have 50 instances on a stand alone server and 25 instances on a fail over cluster with shared disks or 50 instances if using SMB shares for the storage. Of course you could be limited by whatever resources are available on the server or servers.
You can find the maximum capacity specifications for SQL Server in the following documentation:
Maximum Capacity Specifications for SQL ServerSue
Yes I have been given an opportunity but with my skill set I would like to link up my SQLServer to all the mySQL isntances which they all are. I just have no ideas these days about licencing and whether I should install install a different instancr per client or one each and that costs involvoved
July 24, 2017 at 11:39 am
You license the SQL instance based on cores (or server + CAL depending on edition). Nothing at all to do with what linked servers you have to where or how many there are.
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
July 24, 2017 at 3:00 pm
GilaMonster - Monday, July 24, 2017 11:39 AMYou license the SQL instance based on cores (or server + CAL depending on edition). Nothing at all to do with what linked servers you have to where or how many there are.
Thank you Gail
So in which case I can get a standard /enterprise edition with 150 circa linked servers? I dont need enterprise BTW
July 24, 2017 at 3:10 pm
sqlmatt 1398 - Monday, July 24, 2017 3:00 PMGilaMonster - Monday, July 24, 2017 11:39 AMYou license the SQL instance based on cores (or server + CAL depending on edition). Nothing at all to do with what linked servers you have to where or how many there are.Thank you Gail
So in which case I can get a standard /enterprise edition with 150 circa linked servers? I dont need enterprise BTW
July 24, 2017 at 3:15 pm
sqlmatt 1398 - Monday, July 24, 2017 3:10 PMsqlmatt 1398 - Monday, July 24, 2017 3:00 PMGilaMonster - Monday, July 24, 2017 11:39 AMYou license the SQL instance based on cores (or server + CAL depending on edition). Nothing at all to do with what linked servers you have to where or how many there are.Thank you Gail
So in which case I can get a standard /enterprise edition with 150 circa linked servers? I dont need enterprise BTW
PS Gail we are looking for a new data centre in SA for SA - Aus - USA - UK traffic
Do you have any recommendtaions I believe we are going into Terraco in CT other than that I have the clients coming out so any opion appreciated
July 25, 2017 at 1:20 am
sqlmatt 1398 - Monday, July 24, 2017 3:00 PMThank you GailSo in which case I can get a standard /enterprise edition with 150 circa linked servers? I dont need enterprise BTW
You could set up a couple million in a SQL Express instance if you liked (and thought that it could handle the queries).
They're not limited in number as far as I can tell, and there's no edition requirements for linked 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
July 25, 2017 at 1:58 am
thanks Gail thats useful to know 🙂
I think handling the queries wouldnt be a problem on express TBH but for what I want in my head SQL Server Agent will be required
Would you know if express works with/commes with SSIS? Been out the game a while I am afraid
Thanks a mill
July 25, 2017 at 5:50 am
sqlmatt 1398 - Tuesday, July 25, 2017 1:58 AMthanks Gail thats useful to know 🙂I think handling the queries wouldnt be a problem on express TBH but for what I want in my head SQL Server Agent will be required
Would you know if express works with/commes with SSIS? Been out the game a while I am afraid
Thanks a mill
You need Standard for SSIS.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
July 25, 2017 at 3:07 pm
Phil Parkin - Tuesday, July 25, 2017 5:50 AMsqlmatt 1398 - Tuesday, July 25, 2017 1:58 AMthanks Gail thats useful to know 🙂I think handling the queries wouldnt be a problem on express TBH but for what I want in my head SQL Server Agent will be required
Would you know if express works with/commes with SSIS? Been out the game a while I am afraid
Thanks a mill
You need Standard for SSIS.
thanks Phil
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply