none
SQL Server Connection Through a web service RRS feed

  • Question

  • Hello 

    We will be connecting to sql server via web service . 

    Do we have any connection limitations ? We will be uploading documents at random times and multiple time from different desktops . The min transactions are 11000.


    Thanks


    usher A


    • Edited by usher227 Monday, June 10, 2019 8:27 PM
    Monday, June 10, 2019 4:15 PM

All replies

  • Hi usher227,

     

    Thank you for your issue.

     

    About the number or size of transactions, there is no specific size limit in SQL Server, they can theoretically modify any amount of data without problems. The practical limit is really the size of the transaction log file of the target database. The DB engine stores all the temporary and modified data in this file while the transaction is in progress (so it can use it to roll it back if needed), so this file will grow in size. It must have enough free space in the DB properties, and enough HD space for the file to grow.

     

    The user connections option specifies the maximum number of simultaneous user connections that are allowed on an instance of SQL Server. The actual number of user connections allowed also depends on the version of SQL Server that you are using, and also the limits of your application or applications and hardware. SQL Server allows a maximum of 32,767 user connections. Because user connections is a dynamic (self-configuring) option, SQL Server adjusts the maximum number of user connections automatically as needed, up to the maximum value allowable.

     

    For more information , please refer to Maximum Capacity Specifications for SQL Server.

     

    Best Regards,

    Rachel


    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 MSDNFSF@microsoft.com.

    Tuesday, June 11, 2019 6:32 AM