Required DBA

Imefungwa Ilichapishwa Miaka 4 iliyopita Kulipwa wakati wa kujifungua
Imefungwa Kulipwa wakati wa kujifungua

I need a Sql Server DBA who can help me to figure out the problem I am facing.

Problem:

I have one DB with near about 300 tables. One application is inserting the rows in the table on a regular basis like each second. While my website is reading the same table when the user is accessing the site. Due to the insert application website is opening slow. If I will close the application then I am able to open the site within 3 seconds but if service/application is running then it takes near about 30-35 seconds.

Please let me know the solution for this.

SQL Mtandao wa Microsoft SQL Oracle Usimamizi wa Uhifadhi Data MySQL

Kitambulisho cha Mradi: #20297240

Kuhusu mradi

20 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

20 wafanyakazi huru wanazabuni wastani wa ₹2395 kwa kazi hii

latatestTech

With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) Hello, A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. Zaidi

₹1125 INR kwa siku 7
(Maoni 49)
7.2
CodeRaiser

Hello I have a solution for you. I will guide you but you will have to implement it yourself because you are the one who know the whole infrastructure. Talk soon

₹3500 INR kwa siku 1
(Maoni 30)
4.6
aap31374

Myself Anil have more then 10 years of experience in SQL Server databse development and Administration. I have worked with big Databases for clients like match. Com, nationstar mortgage and with TCS. I am also good f Zaidi

₹3333 INR kwa siku 1
(Maoni 5)
3.3
DBhut

Hi Sir, I am core SQL Server DBA. I have excellent experience in performance tuning. I understand your problem in your database. I will fix your database such that you website loads always faster and you no need to Zaidi

₹950 INR kwa siku 1
(Maoni 3)
2.6
smthakur19

By analyzing the problem, I have understood that there are two applications which are being operated on a single database. One application is the write-intensive application while the other (website) is unknown. Can we Zaidi

₹2000 INR kwa siku 2
(Maoni 1)
1.2
cadentic

hi we can solve this. it requires a performance tuning. we are quite familiar with it. to work on this and proceed further we know few more details. os , database version and also awr report , alert log , other system Zaidi

₹10500 INR kwa siku 5
(Maoni 0)
0.0
popolvux2012

How often does the application run? Can you cache data? Or create a queue? It all depends on the architecture and functionality. so hard to say the exact solution

₹1500 INR kwa siku 7
(Maoni 0)
0.0
luliqzx

Hi Sir, I've facing like your problem, I know the transaction was locking table by default. So, I'll use with no lock for speed up reading on your web app. Lets we discuss for details. Regards Lucky Relevant Skills an Zaidi

₹1300 INR kwa siku 7
(Maoni 0)
0.0
Kirankumarjembul

 Having 9.4 years of experience as SQL Server Database Administrator in production support environment.

₹10000 INR kwa siku 7
(Maoni 0)
0.0
sriramchellappa2

This is my first project in freelancer, but I am SQL DBA by profession. I have worked in such scenarios. We can work together and fix it. Let's work together and solve it..Give me a chance Relevant Skills and Experie Zaidi

₹900 INR kwa siku 1
(Maoni 0)
0.0
mykolahromivchuk

I can show you a way how to find bottleneck. Please contact with me for farther cooperation. Regards, Mike

₹1050 INR kwa siku 7
(Maoni 0)
0.0
jay55rajani

There is a indexing issue Relevant Skills and Experience Surerb to work at optimizer wuery

₹1250 INR kwa siku 1
(Maoni 0)
0.0
Jugdambay

You require bit of tweaking, doesn't seem much work Hi, I am core SQL Server DBA. I have excellent experience in performance tuning. I understand your problem in your database. I will fix your database such that you w Zaidi

₹600 INR kwa siku 1
(Maoni 0)
0.0
syedss7866

Database expert with 15 years of rich BAU experience. Speciality in performance tuning, upgrade and migrations.

₹600 INR kwa siku 2
(Maoni 0)
0.0
Samruddhig239

I will complete your project asap

₹750 INR kwa siku 1
(Maoni 0)
0.0
SunilBhakuni

. I have 16+ Yrs of experience in IT and for last 7 Yrs, I have been working for Top E-commerce platforms. I have an exposure for working in vast variety of IT Technologies in the area of Database/Infrastructure/Secur Zaidi

₹3500 INR kwa siku 1
(Maoni 0)
0.0
MariosPavlidis

Hi, I am an experienced SQL Server (MCSE) DBA and have faced similar locking issues in the past. I can provide feedback and several proposals as soon as I watch the issue and we will agree on the changes depending on Zaidi

₹1400 INR kwa siku 3
(Maoni 0)
0.0
ntaservices

Hi, Our team is experienced with databases in fortune 200 companies that come across issues like this all the time. We have solutions that have been put in place to account for these situations. We have over 20 years Zaidi

₹1050 INR kwa siku 7
(Maoni 0)
0.0