Find Jobs
Hire Freelancers

SQL Index Tuning

$30-250 USD

Selesai
Dibuat hampir 4 tahun yang lalu

$30-250 USD

Dibayar ketika dikirim
We have sql server 2008 R2 Sp3 with index issues causing slowness for such statement batch jo running by AX Dynamics 2009 related to Sales pulling it has so many Scaler function SUM, besides that shows expensive plan cache, some indexes shows Aggressive Under-Indexing with Total lock wait time > 5 minutes (row + page) with long average waits we need your consulting service to solve this issue, ASAP, please advise ...
ID Proyek: 26311328

Tentang proyek

19 proposal
Proyek remot
Aktif 4 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
Diberikan kepada:
Avatar Pengguna
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 assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker
$80 USD dalam 3 hari
5,0 (23 ulasan)
4,8
4,8
19 freelancer menawar dengan rata-rata $203 USD untuk pekerjaan ini
Avatar Pengguna
-- 20 years DBA expert ----- I need to check your database first ---- then i can analysis and will tell you the reason and possible solution for that
$95 USD dalam 1 hari
5,0 (52 ulasan)
6,1
6,1
Avatar Pengguna
Hi For start could you provide diagrams for your database and execution plans for your queries? Do you have a list of queries and indexes that should be optimize? Please ignore project delivery time and bid amount. They will be estimated after questions are answered. Please discuss details over chat. Maximum response time is 12 hours, although mostly I respond in minutes. Thanks for your attention Archil
$123 USD dalam 7 hari
5,0 (5 ulasan)
5,9
5,9
Avatar Pengguna
Hi, My name is Ali and I can work on it with immediate availability. I have 12 years of experience in .Net, Sql Server, MVC, .Net Core and Angular. Problem: Indexing causing wait lock while bulk indexing. Solution: 1) Create multiple files while uploading and divide / schedule them separately. 2) Upload data when there is no load on server by removing / pausing the indexes and then rebuild them once uploading is done (This is average approach but we can discuss it too).
$100 USD dalam 7 hari
5,0 (45 ulasan)
5,2
5,2
Avatar Pengguna
Hello, I'm senior database administrator responsible for over a 50+ instances of the MSSQL. I can help you to analyze the server and apply performance tuning solution. I have an extensive knowledge in performance tuning and I can quickly identify the problem for you. From my experiences, I had a Microsoft's based performance tuning training and i tuned databases over 2TBs large. From the topic, i have following questions. 1) The Sale table, how many records does it have approximately? 2) Are able to modify the queries coming from the AX Dynamics or they're just box solutions? 3) What edition are you using ? Express , Standard or Enterprise? Please contact me case you're interested. With Regards & thank you, Frantisek
$156 USD dalam 1 hari
5,0 (8 ulasan)
4,3
4,3
Avatar Pengguna
- Language : ----- C++, C#, Qt, Java, VB/VBA, delphi ----- I have rich experience in following as: - Skill : Database(MySQL, SqlServer, Sqlite, Access, Excel, Oracle, MSSQL...) High and low desktop application, Flexible UI, Installer Network communication(TCP/IP, UDP, RTSP/RTP, HTTP, SMTP...) Computer security & Encrypt/Decrypt(DES...) Project reversing, Multi-processing, Multi-threading
$140 USD dalam 7 hari
5,0 (1 ulasan)
1,4
1,4
Avatar Pengguna
I have more experience with SQL Server, I can optimize your query and indexes need to the tables. I have worked with different types of data, so I can understand your data easily.
$140 USD dalam 7 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi Team, Hope you are doing good. I am having around 11 years of IT experience which Includes mainly in the area of Database development,Design,Maintenance,Management along with worked on many data Warehouse projects. Mainly worked on Oracle, SQL SERVER, HANA DB servers as well as MS ACCESS,TIDAL scheduler,VBA,VB and crystal reports. lets meetup and start working on . Thanks, Wasim About Me
$250 USD dalam 7 hari
0,0 (0 ulasan)
2,4
2,4
Avatar Pengguna
I am a Data architect with 23 years of experience in Multiple RDBMS like Oracle, SQL Server, DB2 etc. I Worked for Oracle (India) as a technical architect for 9 years. I am specialized in Performance tuning/Optimization/complex Query tuning. I can resolve your Query slowness issue in a day or two.
$150 USD dalam 2 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
You need a DBA who will interpret what you need and understands whstvtje job requires completely. I have expertise in Microsoft SQL from 2003 and can help you. Relevant Skills and Experience I am an MCSE, MCDBA ,etc.
$1.111 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hello, I'm a sql dba having 9 years experience. Performance tuning is an art. Your system will go more slower if you create bad index. I would request to arrange a call so that I can help you better.
$222 USD dalam 1 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I was managing sql server from nov 2011 and i am working as sr sql dbs as well as sr sql developer . and i am having a good knowledge in sql server
$150 USD dalam 7 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
I have working experience in SQL with all these mentioned software. I want to work with you. I understand your problem and what you want actually .
$155 USD dalam 10 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Hi, I am very interested in your work post. Allow me to describe my knowledge. I am lead business intelligence and reports developer with vast experience for developing MS SQL databases and corresponding applications to interface with MS SQL databases. I often design tables, create stored procedures, views, functions, and design data warehouse. I am using FirstResponderKit script, so I believe I can help you with your problem. If you have any inquiries regarding my job, do not hesitate to inquire. Good luck.
$90 USD dalam 3 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
i had many tunning project on SQL server platforme to optimise database perforamnces with some specefic methodes and technics
$140 USD dalam 7 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera KUWAIT
Kuwait, Kuwait
5,0
1
Memverifikasi Metode pembayaran
Anggota sejak Jun 29, 2020

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.