Will SQL Server Service Broker be supported in SQL Azure in the future?

I found that SQL Server Service Broker is not supported in SQL Azure. Service Broker is a very attractive choice for our event notification needs. But before I decided on this, I wanted to make sure that Microsoft would be supported by Microsoft in the future. The fact that Azure SQL does not support Service Broker bothers me. Is this the first step to the resignation of Service Broker? We plan to port our application to Azure in the future, and I was trying to figure out if Microsoft will support Service Broker in future versions of SQL Azure. I tried with lots of googling, but I did not get a definitive answer. Does anyone know why Microsoft does not support Service Broker on SQL Azure and will it support in the future?

Thanks, Sathish

+7
source share
3 answers

Support for a service broker in SQL Azure has some technical issues that Microsoft has not yet resolved. For example, a service broker supports message routing between servers. The implementation of this function can be difficult in sql azure and below in the list of priorities. Microsoft did not indicate that they depreciate the service broker, and I would be surprised if it does not end in the end.

There is the same situation for supporting sql clr in the azure region. This is a great idea if you can understand how to get someone to create problems with poorly written code.

Microsoft rarely comments when these types of features are added, they just appear on the same day. In addition, it is important to remember that sql azure is not intended to replace all instances of SQL Server. It is designed to be a simple db that has enough features that can be useful for a fairly wide audience. They recommend that if you require additional functionality, start SQL Server in a virtual machine.

+6
source

Service Broker is currently only supported on a managed Azure SQL Database instance and can only be used on that instance. If this meets the criteria of customers, then the price depends on the size of the managed instance and, possibly, on the storage if it exceeds the first 32 GB per month.

Pricing can be found at the link below:

https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fpricing%2Fdetails%2Fsql-database%2Fmanaged%2F&data=02%7C01%7Cjaander % 40microsoft.com% 7Cc61242a8da824953b31808d6f34f1a98% 7C72f988bf86f141af91ab2d7cd011db47% 7C1% 7C0% 7C636963918401364162 & SData = Ppk1H4WLtBXgtBqGtBqBtQrBqtwqtbqqtw

Below are links to information about the Azure SQL Database Service broker function.

https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-features&data=02%7C01%7Cjaander % 40microsoft.com% 7Cc61242a8da824953b31808d6f34f1a98% 7C72f988bf86f141af91ab2d7cd011db47% 7C1% 7C0% 7C636963918401364162 & SData = p394IKXDtoocyclidYrWeIrWeIrWeIrWeIrWeIrWeIrWeIdOfWeIrWeIdOfErWeIdOfWeIdOfEr

https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-managed-instance-transact-sql -information% 23service-broker and data = 02% 7C01% 7Cjaander% 40microsoft.com% 7Cc61242a8da824953b31808d6f34f1a98 % 7C72f988bf86f141af91ab2d7cd011db47% 7C1% 7C0% 7C636963918401374158 & SData = Ztu4F5W0A% 2BRpsVWqpcrTUGTGzy% 2BFjKRAKB0QtCJ6XO0% 3D & reserved = 0

0
source

Source: https://habr.com/ru/post/925984/


All Articles