Upgrade and downgrade azure sql server plan. RRS feed

  • Question

  • Hello, we are using azure sql database on our production server. The database is connected to all the applications like admin panel, website that we are building and to bot etc. When development is going simultaneously we are getting session limit 300 is reached error and we are unable to get log in to database. Is there any possibility or way to auto upgrade service plan from basic to next level when session limit is crossed and again downgrade that plan  to basic when sessions are available?

    Please help us.

    Friday, November 24, 2017 5:30 AM

All replies

  • Hi,

    Since this is the forum which is talking about Transact-SQL and your issue is more related to Azure SQL Database.

    So I would suggest you to post your issue to Azure SQL Database forum for more professional help.

    Xi Jin.

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Friday, November 24, 2017 6:57 AM