Fermé

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.

Compétences : ASP, Administration de Bases de données, Programmation de bases de données, Serveur SQL Microsoft, SQL

Concernant le client :
( 0 commentaires ) Delhi, India

Nº du projet : #36213222

27 freelances font une offre moyenne de 8985 ₹ pour ce travail

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(42 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(46 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(25 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(8 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(66 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 999 jours
(5 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(4 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(17 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(12 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(3 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(2 Commentaires)
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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(2 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
0.0
shailyshafeeque

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 7 jours
(0 Commentaires)
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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 4 jours
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% INR en 1 jour
(0 Commentaires)
0.0