Closed

Required DBA

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.

Skills: SQL, Microsoft SQL Server, Oracle, Database Administration, MySQL

See more: what is a dba, how to use a dba name, dba examples, disadvantages of dba, filing a dba in ny, do i need a dba in texas, how to file a dba in california, dba meaning, sql server 2005 developer required skills, read xml file using net insert sql server, insert xml document sql server, website need password user, reading user role database, need script user sign can friends link, need modelmayhem user password, reading user input javascript calculations, script insert joomla community builder user, need lightweight user friendly php code datable, required dba trainer, need reading response

About the Employer:
( 28 reviews ) SAS Nagar, India

Project ID: #20297240

23 freelancers are bidding on average ₹2279 for this job

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. More

₹1125 INR in 7 days
(45 Reviews)
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 in 1 day
(28 Reviews)
4.5
iTechnorati

Hi, How are you inserting the data (SQL, EF, SP etc)? and How are you reading the data (SQL statement?) Lets discuss this over chat

₹1500 INR in 1 day
(1 Review)
3.0
adricabrelles

Hi, I'm a senior DBA with more than 15 years experience in sql server, Oracle, ... I can help you. Regards.

₹1500 INR in 1 day
(4 Reviews)
2.3
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 More

₹2000 INR in 2 days
(1 Review)
1.2
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 More

₹3333 INR in 1 day
(1 Review)
0.6
jay55rajani

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

₹1250 INR in 1 day
(0 Reviews)
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 More

₹1400 INR in 3 days
(0 Reviews)
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 More

₹3500 INR in 1 day
(0 Reviews)
0.0
Samruddhig239

I will complete your project asap

₹750 INR in 1 day
(0 Reviews)
0.0
inforafeesoft

Hi sir I'm a [login to view URL] Engineer Database Administrator and System Administrator Also Network Administrator I'm expert in Database (My SQL,MS SQL,Azure,AWS,Mongo Db,Postgre DB,Magento ...etc), Java, Java Script, PHP, More

₹1500 INR in 1 day
(0 Reviews)
0.0
syedss7866

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

₹600 INR in 2 days
(0 Reviews)
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 More

₹600 INR in 1 day
(0 Reviews)
0.0
₹1300 INR in 1 day
(0 Reviews)
0.0
mykolahromivchuk

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

₹1050 INR in 7 days
(0 Reviews)
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 More

₹900 INR in 1 day
(0 Reviews)
0.0
Kirankumarjembul

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

₹10000 INR in 7 days
(0 Reviews)
0.0
sumitengineer81

I am oracle dba working with top mnc and handling siE of over 10tb and more than 7k tables Relevant Skills and Experience I suggest u to rebuild the index of the table which creates [login to view URL] no index available creat More

₹1300 INR in 1 day
(0 Reviews)
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 More

₹1300 INR in 7 days
(0 Reviews)
0.0
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 More

₹950 INR in 1 day
(1 Review)
0.0