Need Mssql Expert for Error resolution
Budget ₹7000-8000 INR
Job Description:
Our database is 5 gb, recently it has started throwing randomly wait time out error.
We reversed any new developments we had done. Shifted server to new server. Increased time to 2000.
Still the error comes as the number of users increase. Does not come with less users.
27 freelances font une offre moyenne de 8985 ₹ pour ce travail
This error needs detail investigation of the code if there are some connections which are left open how are users managed, are queries taking time. These all things after being reviewed properly can help reach the fina Plus
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am a Plus
Hi Anuj, Is this error is coming on only one page? Or others as well? Also you mentioned that error occur only when users are high? Have you faced these error before? What was updated Whe you started to get these err Plus
Hello, You need a structured and proven method of troubleshooting. Random actions will hurt your server than fixing it. Based on the job description, I guess you are facing blocking and/or deadlocks. I can confirm it Plus
Hello, I'm Abu Gosia. I'm interesting in your project very well. I'm good in C#, .Net Core, MVC, ASP.NET, Angular.js, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart. I m quite well experienced in these jobs. Let Plus
Hello, I have more than seven years of experience in the office and more than three years of freelance experience in the required area of work and would like to help you with this task. Thanks for posting in my area of Plus
Can you please explain about the tech stack you are using and the server, hosting and most important, use case of the application. That could help me design the or restructure the architectural part of the application Plus
Hi, Is this issue occurs on specific page? Did you capture query executed in this page? I can work with you to fix query time out issue. I'm 8 years experienced SQL server DBA. Let's connect to fix it.
The error clearly says timeout. Does it timeout out after 2000 seconds? If so we need to see what query is holding up the processing and try to fine tune it. It could not be based on number of users, it has to only do Plus
After reading in detail the requirements of your project and concluding that they match my areas of knowledge and skills, I would like to introduce myself. My name is Pravin Jaiswal from Steema Software Private Limited Plus
Hi there, we are experts in PHP, JavaScript, MySQL. Please, send me a message to discuss the work and finish in no time. Thanks Ashish.
database is timing out due to resource contention. i would check below CPU Memory Indexes if it is only one query that is causing problem i can freeze plan for you.
Hello, Thank you for posting your project on Freelancer. I understand that you are experiencing wait time-out errors with your 5 GB database and that you have already tried reversing new developments, shifting to a ne Plus
Yes we can handle this issue efficiently do come over chat to discuss more about it Thanks Techdock labs
Hello Sir, I am 6 years experienced web developer and system admin. I can restore the database with ssh, Kindly knock me in chat so that we can discuss the details
Hi I can think of ways to resolve the issue and try them out as I have faced such problems earlier in my career. The following approaches might help. 1)Manually execute the query in the system and try to check if i Plus
The code will be delivered on time and I will write complex queries. I will give you a better product than what you expected.
HI, I have seven years of experience in MS SQL, I know the MS SQL in and out. I have resolved the many SQL issues regarding performance issues over the period so confident about resolving of this issue as well.
Hello, I hope you are doing great. I have good experience with doing similar jobs. You can check my portfolio here: https://www.freelancer.com/u/yassineelectro , Please start the chat and discuss this. Thanks! Awais