Fermé

Fixing Microsoft SQL SERVER database slow issue (Only expert)

Job Description:

I have identical two database one is slow and one fast both are cleaned database.

The databases had data and i used this query to clean the tables

DELETE FROM tablename

DBCC CHECKIDENT (tablename, RESEED, 0)

I have used this query to clean every table with one database the other database im not sure if i used this query with all table or sometimes used TRUNCATE table

I want someone who are able to find why one of them are slow and fix it.

I will show you both databases when i restore them from bak file.

You will use anydesk to access to my computer to show you the problem.

Compétences : SQL, Serveur SQL Microsoft, Administration de Bases de données, Microsoft Access, MySQL

Concernant le client :
( 25 commentaires ) Moscow, Russian Federation

Nº du projet : #35365154

51 freelances font une offre moyenne de 146 $ pour ce travail

Agiletechstudio

Hi there, I have read your initial requirements in details and I have some questions regarding to your sql server database project. please send me a message so that we could discuss it further requirements , budget and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(92 Commentaires)
7.6
talhaamin

Hello, I am an expert in Database and have worked on lots of database fixing their performance and currently have worked on fixing a MySQL database for performance and have been able to reduce the load from 95% to 40%

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(30 Commentaires)
7.8
riskypathak

When you say database is slow, Is that mean when you run same query on different database, then you see clear difference in their execution time? Are they both on same DB server? I will be happy to take a look

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(82 Commentaires)
7.6
hoisticdeveloper

Hello! I am a skilled coder with 11+ years of experience. I am a developer who is well skilled for this project including Database Administration, MySQL, Microsoft SQL Server, Microsoft Access and SQL. If you give me Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(36 Commentaires)
6.4
fanninson45

Let me handle your MSSQL database optimization and code refactor for better database performance . Getting this project started is a message away. SIMILAR PROJECTS I COMPLETED • https://www.freelancer.com/projects/sql Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(25 Commentaires)
6.3
manhpham

Hi my client, I am SQL server expert. i can help you to check the root reason why the database is slow. Please contact me. Manh

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(61 Commentaires)
5.9
TSCreators

Hi , I have 7 years experience over asp.net(webform and MVC, core), windows application, HTML, CSS, Javascript,xml,xsd , crystal report , API Integration, .Net Web Services (WCF, and ASMX), Version Control: Github Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(32 Commentaires)
5.2
vw7596592vw

Hello, I have read the job description and I am interested in this job. I can check your database and optimize it for performance. I have 17 years experience in developing products using ASP.NET MVC, Azure, ASP.NET, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(17 Commentaires)
5.5
dhanuitdevendra

Title: [5-day-delivery] SQL Server Health Check Category: 5-day-delivery Tag(s): SQL Server, Troubleshoot, Health Check, Performance Description: You want a thorough SQL Server Health Check. ### Checklist Ite Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
5.4
kundansql

Hello Friend ! I can help you to optimise the database for higher throughput and better user experience. I can also help you to figure out the difference between these two databases if you want. We can do a 15-minut Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(28 Commentaires)
4.9
tariqs028

Hi, Ready to connect on your any-desk and solve your issue. I have read your requirements and really to much interested in your project. I'm well suited for your project. I did many project as like your requirements. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(23 Commentaires)
4.6
ganeshrasekar

I can do it

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(19 Commentaires)
4.9
SeasonedDveloper

I'm ready to start work right now and I can assure you the best service from my end.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
4.3
awais26

Hi, I’m very interested in your job posting. Please consider my application. I have a background in database administration in MS SQL server and have been doing this for 7+ years. I have experience and can work with yo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(7 Commentaires)
4.4
Shakerfawzy

Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an as Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(17 Commentaires)
4.4
freelancepraful

I can help you with sql server queries , please ping/connect me now I am available. Please check my reviews and project which I have completed. I can create sql queries for sql server database as per design, let me kno Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
4.3
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% USD en 1 jour
(3 Commentaires)
3.9
noureen23

Hi There, I hope you having good day. I am glad to offer my services for "Database slow performance". I have extensive experience in Database administration. My experience makes me confident to assure you 100 percent a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(15 Commentaires)
4.0
usamasohail91

Greeting! I read your project description and I can fix. I am ready to start working quickly on your project. Come to the chat box to discuss this work and cost ... I am an experienced web developer and I can work wi Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)
2.9
Bhatti1987

I have more than 12 years of experience in Oracle/ SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I hav Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(12 Commentaires)
3.0