Find Jobs
Hire Freelancers

SQL Server Query Optimization 5 SP's and High Memory Usage

$30-250 USD

Đang triển khai
Đã đăng vào khoảng 2 tháng trước

$30-250 USD

Thanh toán khi bàn giao
I'm experiencing performance issues with 5 stored procedures in my SQL Server. These procedures are significantly slower than expected due to complex JOIN queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity with procedures handling multi-table JOIN queries. GetInvKardexPorLote rows : 10924, max : 96'' GetKardexInventario rows : 4931, max : 72'' GetLibroAuxiliar rows : 3007, max : 94' GetVEncabezados rows : 2870, max : 98'' GetBalancePrueba --> rows : 2509, max : 104''
Mã dự án: 37982636

Về dự án

86 đề xuất
Dự án từ xa
Hoạt động 1 tháng trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
Hello, I'm a SQL Server DBA and developer Data Engineer with more than seven years worth of experience as a SQL Server DBA. I have read your project carefully, and I think I will be the perfect candidate. I'm ready to start. Furthermore, I have extensive experience managing databases ranging in size from GB to TB. I'm an expert at planning and implementing high-availability solutions, migration, and upgrading. Good experience with Performance optimization, such as Server performance optimization and Code performance optimization. Also, good hands with troubleshooting and recovering. I processed an excellent command on T-SQL programming I have a good references and would be delighted to discuss this with you at your convenience. I have excellent management skills, good communication skills, and an excellent command of English and French. Thank you. I hope to hear from you soon.
$50 USD trong 1 ngày
0,0 (0 nhận xét)
0,0
0,0
86 freelancer chào giá trung bình $173 USD cho công việc này
Avatar người dùng
Can i access the SQL server online or its just locak server you refering too. so discuss with me more so i can fix things for you accordingly. I need to see the procedures and price you. let me know.
$140 USD trong 7 ngày
4,9 (234 nhận xét)
7,5
7,5
Avatar người dùng
Hello, Full stack web developer, with 16+ years of experience in ASP.NET Core, Blazor, Angular, Reactjs, Nodejs, ASP.NET MVC, Azure. AWS Apis, C# web forms, VB.NET, Classic ASP, Vbscript, SQL Server, HTML, CSS, javascript, jQuery, JSON and XML. Handled various integration-based projects, product-based projects, and CMS-based projects.
$290 USD trong 7 ngày
4,9 (44 nhận xét)
6,1
6,1
Avatar người dùng
Hello, Thanks for job posting. I read your project description . I have extensive experience in SQL server DBA and development. I am one of Microsoft certified SQL server DBA. I specialized in SQL server and Azure. Provided DBA services to many clients. Contact me and let's talk together about project details. I hope to make a magical one. Thanks
$140 USD trong 7 ngày
5,0 (32 nhận xét)
5,7
5,7
Avatar người dùng
As a seasoned database professional, I have a profound understanding of the issues you're facing. My adeptness in optimizing SQL Server performance and my familiarity with intricate JOIN processes make me the perfect fit for your project. Over the past five years, I've honed my skills through numerous projects that entailed heavy-duty SQL query optimization and performance improvement, often achieving substantial speed enhancements. Furthermore, my educational background in computer science affirms my expertise. A Bachelor's degree in Commerce bolsters my efficiency in managing project costs and estimates, which is particularly salient to your project. In addition to all this, I am also a certified CCNA professional, guaranteeing well-rounded knowledge crucial for diagnosing high memory usage of your SQL Server instance. Lastly, my commitment to quality work aligned with your needs makes me an ideal choice. My core values of reliability, time consciousness and honesty are reflected in my project delivery history and satisfied clientele. From crafting comprehensive software requirements specifications (SRS) to designing optimized database schemas, I possess a vast skill set that can enhance your project meticulously. With a promise of efficient results, I invite you to click "Hire me" on my profile, [insert link] to experience exceptional service firsthand. Thank you!
$140 USD trong 7 ngày
4,8 (28 nhận xét)
5,2
5,2
Avatar người dùng
Hi, I apologize if my bid proposal offends you. In my opinion, only focusing on 5 specific SPs is not a great choice as it primarily includes Query Optimization techniques. And if you choose Performance Tuning, it includes Query Optimization as well as Configuration Settings, Indexing, and Index Maintenance. As you've mentioned, you're experiencing high Memory Usage issues. SQL Server default settings are designed to use as much memory as it requires. To reduce the Memory Usage, either you change the settings or optimize the database or do both. I recommend you to do both. I can efficiently help you to relieve the pain by optimizing the SQL Server performance. I'll start by analyzing the performance numbers, especially wait stats, to determine the root cause of the slowdowns. Once the bottlenecks are identified, I'll fix them by configuring the SQL Server's settings, creating high-value missing indexes, disabling any unused indexes, and fine-tuning slow queries. In addition to that, I can also help you to automate index maintenance jobs which will prevent performance degradation over time. In bonus, I'd suggest some database settings that'll minimize the chances of data corruption issues. I'm a SQL Server Expert, and I specialize in SQL Server Performance Tuning and Troubleshooting. Feel free to reach out on message if you've any questions or would like to move forward. Warm regards, Kundan
$2.000 USD trong 7 ngày
5,0 (37 nhận xét)
5,2
5,2
Avatar người dùng
Hi There, I've been working in the field of database design, management, and performance tuning for over 15 years. I have continually mastered my SQL proficiency and I'm especially skilled in the complexity of JOIN operations that you've highlighted. This puts me in an excellent position to diagnose the root causes of the poor performance your stored procedures are experiencing and find concrete solutions that will improve their speed more than of 50%. Lastly, my commitment to delivering top-notch work with precise execution aligns flawlessly with the nature of your project. I have complete faith in my abilities to transform your existing slow operations into fast ones while making sure they are optimized to utilize memory effectively. Let's harness the power of your data together! Warm Regards Saima
$70 USD trong 7 ngày
5,0 (28 nhận xét)
5,0
5,0
Avatar người dùng
I have 17 years of experience in sql server development and performance tuning. I will be able to complete the project. Please ping me the procs and we can discuss further
$350 USD trong 7 ngày
4,9 (14 nhận xét)
4,6
4,6
Avatar người dùng
Greetings. I am MSSQL DBA. Have worked on many performance tuning projects. We can achieve performance of stored procedure by 1. Tuning queries 2. Applying appropriate indexes 3. Applying appropriate query hints 4. Looking at index fragmentation and statistics 5. Arranging data to get high IOPs 6. Arranging server settings to get optimal performance from database server. and many more things Looking forward to work with you to complete this task. Thanks & Regards, Milind
$200 USD trong 7 ngày
5,0 (24 nhận xét)
4,3
4,3
Avatar người dùng
SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$240 USD trong 3 ngày
4,6 (34 nhận xét)
4,3
4,3
Avatar người dùng
Hi, Hope you well ! I have 12 + years experience in .NET with C++, C#, VB, JAVA, SpringBoot, ASP.NET MVC, ASP.NET Core, Angular, IIS, Web Service, WCF, JavaScript, jQuery, SQL, PL/SQL, SSIS, SSRS, Crystal Report, XML ,XSLT and HTML. I have worked on enterprise level applications , and extensive knowledge to develop robust applications. I have more than 5 years of experience in database development and worked on database objects optimizations. Please send me a message so we can discuss further. Thank You
$250 USD trong 7 ngày
5,0 (10 nhận xét)
4,1
4,1
Avatar người dùng
Hi, I have extensive experience developing and optimizing complex stored procedures and sql code with multiple joins, nested procedures and subqueries. I'll be happy to help you with this project.
$140 USD trong 7 ngày
5,0 (5 nhận xét)
3,8
3,8
Avatar người dùng
Hi I'm Professional Database Developer and Engineer. I have 7 years of experience in this field. I will help you to optimize the sp's. Feel free to contact me. Thanks
$200 USD trong 1 ngày
4,6 (9 nhận xét)
3,4
3,4
Avatar người dùng
Hi Luis R., How are you doing? As a professional developer with expertise in MySQL, SQL, Database Programming, Microsoft SQL Server and Database Administration, I eagerly anticipate the opportunity to complete this project for you. Please drop me a message to discuss the project detail. Thank you for considering my services.
$50 USD trong 6 ngày
5,0 (2 nhận xét)
2,9
2,9
Avatar người dùng
As an experienced Java and Python programmer, I'm confident in my abilities to not only understand the SQL queries but also have stamina when it comes to complex and lengthy tasks. Throughout my career, I've worked on numerous projects dealing with both front-end and back-end development, incorporating a wide range of technologies including SQL Server. My knowledge of advanced SQL query optimization techniques is what differentiates me from the rest. I will be able to diagnose the root cause of the slow performance of your stored procedures with accuracy and offer fast, effective solutions. I've also built a strong foundation working with different databases including MySQL, Oracle and PostgreSQL which allows me to approach database administration in a well-rounded manner. The fact that you need a 50% increase in speed is a challenge that fuels my passion for coding and problem solving. I assure you if given this opportunity, the outcome will demonstrate my commitment to excellence; your project will receive the attention it deserves as I plan to meticulously analyze every line of code during the debugging process, ensuring optimal performance and reduced memory usage for your sing server instance. Looking forward to being a part of your solution.
$140 USD trong 2 ngày
5,0 (3 nhận xét)
2,9
2,9
Avatar người dùng
Hello Sir, I am keen to tackle the performance issues you are facing with your SQL Server stored procedures. With extensive experience in SQL Server optimization and a deep understanding of complex JOIN operations, I am well-prepared to enhance the performance of your system. My expertise includes diagnosing and resolving inefficiencies in SQL queries, particularly those involving multiple table joins and large datasets. I have a successful track record of significantly reducing execution times and memory usage in SQL Server environments, ensuring systems run more smoothly and efficiently. The approach I take involves thorough analysis to identify bottlenecks in your current procedures. By utilizing advanced SQL Server performance tuning techniques, such as indexing strategies, query refactoring, and execution plan analysis, I aim to not only meet but exceed the goal of achieving at least a 50% increase in speed. Additionally, I will implement best practices to manage and optimize memory usage, addressing the high memory consumption issues you've noted. I'm looking forward to the opportunity to discuss how I can contribute to the efficiency and effectiveness of your SQL Server operations. Best regards.
$200 USD trong 7 ngày
4,5 (2 nhận xét)
3,0
3,0
Avatar người dùng
Hola! Tengo experiencia en optimización de bases de datos SQL, de hecho doy clases de una materia que trata el tema. Me gustaría que me concedan este trabajo. Además dado que hablamos español seguramente podemos comunicarnos de forma más fluida. Saludos!
$200 USD trong 7 ngày
5,0 (1 nhận xét)
2,1
2,1
Avatar người dùng
As a seasoned SQL expert with an emphasis in query optimization and performance tuning, I believe my skillset aligns perfectly with your project needs. In my years of working on complex projects, I have encountered and resolved similar optimization and speed issues that you may be facing. Not only can I identify the underlying cause of slow performance within these 5 stored procedures, but I'm confident I can deliver a significant 50% increase in efficiency, or even surpass your expectations. Beyond my technical expertise, I am known for my strong debugging and diagnostic abilities. This skill has proven invaluable in understanding complex JOIN operations, not leaving any stone unturned until the problem is resolved. I also offer knowledge in designing secure database structures that offer remarkable performance, which addresses your memo regarding high memory usage in SQL server Instances. My commitment to superior quality work is likewise supported by my experience in C#, ASP.net Core and PHP. These languages have honed my ability to organize codes based on client-specific requirements, making them highly readable and reusable. So, as not just a SQL specialist but as an overall software engineer, I'm confident that choosing me as your business partner will be a decision you won't regret.
$100 USD trong 7 ngày
5,0 (2 nhận xét)
1,0
1,0
Avatar người dùng
Soy un desarrollador de software altamente capacitado y experimentado, especializado en el entorno .NET con más de 10 años de experiencia. Mi enfoque principal se centra en el desarrollo backend utilizando el lenguaje de programación C#, donde me esfuerzo por crear soluciones eficientes y confiables, con un énfasis en la mantenibilidad y escalabilidad. Mi experiencia predominante radica en el desarrollo de API, facilitando la integración de servicios que interactúan con bases de datos y servicios de terceros. En el ámbito de las bases de datos, mi experiencia abarca plataformas como SqlServer, Oracle y postgres, donde empleo tecnologías ORM como EntityFramework y Dapper para optimizar el manejo y la integración de datos. Siempre apegado a las buenas prácticas. Dicho esto, entiendo que puedo apoyarte a llevar a cabo la revisión de tus SP, para analizar el performances de tus querys. Sientente libre para conversar al respecto, quedo al pendiente y a la orden. Saludos, CD
$170 USD trong 7 ngày
5,0 (1 nhận xét)
0,4
0,4
Avatar người dùng
Dear Client, Luis R. How are you? I’ve read all of your requirements carefully about SQL Server Query Optimization 5 SP's and High Memory Usage and really interested in this job and I found my skills relevant to your project. I won't bother you with a long story as I know you have lots of proposals to read to look for an appropriate candidate. To be honest, I possess all the skills and experience that you are looking for. If you are interested in my skills, please let me know here. I can start working right now and hope to establish a long term working relationship with you in the future. Would it be possible for us to engage in a more in-depth conversation about your project through a chat or short interview? Eagerly anticipate your response.
$155 USD trong 5 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
Dear Luis R., I’ve read all of your requirements fully and I'm really interested in SQL Server Query Optimization 5 SP's and High Memory Usage. I have rich experience in MySQL, Database Programming, Microsoft SQL Server, Database Administration and SQL with over 9 years. I am always ready to discuss more detail this project with you and I can start working immediately. Looking forward to working with you soon. For the best result and a long term in the future. Regards, Mikael.
$30 USD trong 5 ngày
5,0 (1 nhận xét)
0,0
0,0

Về khách hàng

Cờ của COLOMBIA
Bogotá, Colombia
5,0
8
Phương thức thanh toán đã xác thực
Thành viên từ thg 10 26, 2018

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.