locked
High availability system RRS feed

  • Question

  • Dear Experts ,

    We have a requirement of doing the parallel insert/update  and select operation in the same table.

    What should be the best way to achieve this ?

    Thanks,

    Abhisek


    Abhisek Mondal

    Monday, May 8, 2017 10:40 AM

Answers

  • Abhisek,

    That is quite open ended question SQL Server is capable of handling simultaneous updates and inserts on same table what you need to have is 

    1. Proper schema design

    2. Correct table design with correct data types and lenght

    3 Queries supported by index.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, May 8, 2017 11:07 AM
    Answerer
  • What you are trying to achieve is high concurrency - the ability to support multiple users doing useful work simultaneously.

    You need to look at the snapshot isolation level for this.

    https://msdn.microsoft.com/en-us/library/tcbchxcb(v=vs.110).aspx

    You will need to stress test to determine if your SQL Server current configuration can support the existing and anticipated workloads, or if you need to investigate snapshot isolation level.

    Monday, May 8, 2017 11:13 AM

All replies

  • Abhisek,

    That is quite open ended question SQL Server is capable of handling simultaneous updates and inserts on same table what you need to have is 

    1. Proper schema design

    2. Correct table design with correct data types and lenght

    3 Queries supported by index.


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, May 8, 2017 11:07 AM
    Answerer
  • What you are trying to achieve is high concurrency - the ability to support multiple users doing useful work simultaneously.

    You need to look at the snapshot isolation level for this.

    https://msdn.microsoft.com/en-us/library/tcbchxcb(v=vs.110).aspx

    You will need to stress test to determine if your SQL Server current configuration can support the existing and anticipated workloads, or if you need to investigate snapshot isolation level.

    Monday, May 8, 2017 11:13 AM