Închis

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.

Aptitudini: SQL, Server Microsoft SQL, Administrare baze de date, Microsoft Access, MySQL

Despre client:
( 25 recenzii ) Moscow, Russian Federation

ID Proiect: #35365154

51 freelanceri licitează în medie 146$ pentru acest proiect

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(92 recenzii)
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 în 7 zile
(30 recenzii)
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 în 10 zile
(82 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(36 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(25 recenzii)
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 în 1 zi
(61 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(32 recenzii)
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, Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(17 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(7 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(28 recenzii)
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. Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(23 recenzii)
4.6
ganeshrasekar

I can do it

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(19 recenzii)
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 în 1 zi
(4 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(7 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(17 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(4 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(3 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(15 recenzii)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(1 părere)
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 Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(12 recenzii)
3.0