Table for high


  • Hello, I have an application that constantly work on one table. 

    This table have like 2 million records and I don`t believe it will have more than 3 in the next 3 years. 

    This table is constantly access by the application to (count according to some columns), read task and update. 

    My application run fine when just one user or 5 users are using it, but when 15 users are using it, I get so many locks that its almost impossible to work with it. 

    What is the correct approach for this case? 

    Due to the kind of search, it have 2 index one clustered and one non-cluster. that`s all. 

    If i remove the index, I get no locks, but the lag is so high that my application got time out errors. 

    Gilberto H.

    Wednesday, May 09, 2018 10:12 PM

All replies