I need a Sql Server DBA who can help me to figure out the problem I am facing.
I have one DB with near about 300 tables. One application is inserting the rows in the table on a regular basis like each second. While my website is reading the same table when the user is accessing the site. Due to the insert application website is opening slow. If I will close the application then I am able to open the site within 3 seconds but if service/application is running then it takes near about 30-35 seconds.
Please let me know the solution for this.
23 freelancers are bidding on average ₹2279 for this job
Hello I have a solution for you. I will guide you but you will have to implement it yourself because you are the one who know the whole infrastructure. Talk soon