We need highly experienced SQL Server admin to troubleshoot & fix SQL server database becoming not responding after executing an update statement on 24,000 records.
Executing a simple select count was taking so much time and failing to execute.
We tried running CHECKDB repair_allow_data_loss and this has been executing for the past almost 1 hour and the Database showing ( In Recovery ).
Note: we are talking about a small database not a large one.
40 freelancers are bidding on average $138 for this job
Hello, As an expert in ms sql server, i am very much interested to fix the issue in your database. May i see the database and issue please? Looking forward to have a positive response from you. Thanks
Hi, Looks like you've some locking issue on your database . I'm expert sql server DBA and I can fix your issue. Let me know when we can further discuss as I'm available now. Thanks
Hey, Kindly share you select select and update query with me, most probably issues come from query instead of server. Ping me back, So we can discuss it further. Thanks