Закрыт

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.

Навыки: ASP, Управление базами данных, Программирование баз данных, SQL-сервер Microsoft, SQL

О клиенте:
( 0 отзыв(-а, -ов) ) Delhi, India

ID проекта: #36213222

27 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹8985

talhaamin

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 Больше

₹5000 INR за 7 дней(-я)
(42 отзывов(-а))
7.8
schoudhary1553

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 Больше

₹5000 INR за 2 дней(-я)
(46 отзывов(-а))
6.5
shobhitpundir

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 Больше

₹5000 INR за 7 дней(-я)
(25 отзывов(-а))
5.5
dhanuitdevendra

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 Больше

₹50000 INR за 7 дней(-я)
(8 отзывов(-а))
5.7
abugosia

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 Больше

₹15000 INR за 7 дней(-я)
(66 отзывов(-а))
5.9
SyedRohaanAlam

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 Больше

₹3500 INR за 999 дней(-я)
(5 отзывов(-а))
4.9
onkarkulkarni8

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 Больше

₹3500 INR за 7 дней(-я)
(4 отзывов(-а))
5.0
awais26

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 за 7 дней(-я)
(17 отзывов(-а))
5.1
supergana

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 Больше

₹3500 INR за 7 дней(-я)
(12 отзывов(-а))
4.1
pravinjaiswalp

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 Больше

₹5000 INR за 1 день
(3 отзывов(-а))
3.9
ashinnd84

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 за 7 дней(-я)
(2 отзывов(-а))
3.1
vijaybandi

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.

₹4500 INR за 1 день
(2 отзывов(-а))
1.7
AteebNoOne

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 Больше

₹3500 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
shailyshafeeque

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

₹5000 INR за 1 день
(0 отзывов(-а))
0.0
codexexpart

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

₹3000 INR за 1 день
(0 отзывов(-а))
0.0
bhagyasreedekond

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 Больше

₹4500 INR за 7 дней(-я)
(0 отзывов(-а))
0.0
DasariVenkataSai

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 за 7 дней(-я)
(0 отзывов(-а))
0.0
sunilyelapure4

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 за 4 дней(-я)
(0 отзывов(-а))
0.0
yassineelectro

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

₹2000 INR за 1 день
(0 отзывов(-а))
0.0