Need Mssql Expert for Error resolution

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.

Beceriler: ASP, Veri Tabanı Yönetimi, Veritabanı Programlama, Microsoft SQL Server, SQL

Müşteri Hakkında:
( 0 değerlendirme ) Delhi, India

Proje NO: #36213222

Bu iş için 27 freelancer ortalamada ₹8985 teklif veriyor


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 Daha Fazla

₹5000 INR in 7 gün içinde
(42 Değerlendirme)

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 Daha Fazla

₹5000 INR in 2 gün içinde
(46 Değerlendirme)

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 Daha Fazla

₹5000 INR in 7 gün içinde
(25 Değerlendirme)

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 Daha Fazla

₹50000 INR in 7 gün içinde
(8 Değerlendirme)

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 Daha Fazla

₹15000 INR in 7 gün içinde
(66 Değerlendirme)

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 Daha Fazla

₹3500 INR in 999 gün içinde
(5 Değerlendirme)

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 Daha Fazla

₹3500 INR in 7 gün içinde
(4 Değerlendirme)

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.

₹3500 INR in 7 gün içinde
(17 Değerlendirme)

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 Daha Fazla

₹3500 INR in 7 gün içinde
(12 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(3 Değerlendirme)

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.

₹3500 INR in 7 gün içinde
(2 Değerlendirme)

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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(2 Değerlendirme)

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 Daha Fazla

₹3500 INR in 7 gün içinde
(0 Değerlendirme)

Yes we can handle this issue efficiently do come over chat to discuss more about it Thanks Techdock labs

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)

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 Daha Fazla

₹4500 INR in 7 gün içinde
(0 Değerlendirme)

The code will be delivered on time and I will write complex queries. I will give you a better product than what you expected.

₹15000 INR in 7 gün içinde
(0 Değerlendirme)

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.

₹4500 INR in 4 gün içinde
(0 Değerlendirme)

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% INR
(0 Değerlendirme)