Lukket

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.

Færdigheder: ASP, Database Administration, Programmering af database, Microsoft SQL Server, SQL

Om klienten:
( 0 bedømmelser ) Delhi, India

Projekt ID: #36213222

27 freelancere byder i gennemsnit ₹8985 timen for dette job

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 Flere

₹5000 INR in 7 dage
(42 bedømmelser)
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 Flere

₹5000 INR in 2 dage
(46 bedømmelser)
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 Flere

₹5000 INR in 7 dage
(25 bedømmelser)
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 Flere

₹50000 INR in 7 dage
(8 bedømmelser)
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 Flere

₹15000 INR in 7 dage
(66 bedømmelser)
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 Flere

₹3500 INR in 999 dage
(5 bedømmelser)
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 Flere

₹3500 INR in 7 dage
(4 bedømmelser)
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 in 7 dage
(17 bedømmelser)
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 Flere

₹3500 INR in 7 dage
(12 bedømmelser)
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 Flere

₹5000 INR på 1 dag
(3 bedømmelser)
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 in 7 dage
(2 bedømmelser)
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 på 1 dag
(2 bedømmelser)
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 Flere

₹3500 INR in 7 dage
(0 bedømmelser)
0.0
shailyshafeeque

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

₹5000 INR på 1 dag
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 Flere

₹4500 INR in 7 dage
(0 bedømmelser)
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 in 7 dage
(0 bedømmelser)
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 in 4 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
0.0