Đã hoàn thành

I need SQL Server tuning to be done to our database. - open to bidding

Our SQL Server business applications database has many stored procedures which can benefit from non-clustered indexes and rewriting. I need a Microsoft MVP to study the stored procedures and do the needful to speed up retrieval to less than 3 secs. I have identified a list of these stored procedures and can make them available for study.

I have attached an Excel file that gives statistics collected from a live production database. The "last_elapsed_time" column can be sorted to show the stored procedures that took the highest execution time. These would be the ones to target first. I can setup access to the database to those interested. The database is over 25GB and can't be uploaded for review. From the "statement" column one can see that some stored procedures use views. These are also candidates for rewriting. Our target is SQL Server 2008 R2. Please feel free to get back to me with any questions. Thank you.

Kĩ năng: Quản trị cơ sở dữ liệu, Microsoft SQL Server, MySQL

Xem nhiều hơn: sql database business, sql less than, TUNING, sql business, MICROSOFT SQL SERVER, database tuning, database microsoft sql, SQL Server Stored Procedures, list stored procedures, rewriting database, sql procedures, tuning applications, tuning, needful, database sql server

Về Bên Thuê:
( 7 nhận xét ) Jeddah, Saudi Arabia

ID dự án: #7116808

Được trao cho:


Hi I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have Thêm

$25 USD / giờ
(69 Đánh Giá)

42 freelancer chào giá trung bình $36/giờ cho công việc này


Greetings, I have read your Project description and can I get your database? Our current bid is just a placeholder since Freelancer requires it but once you respond us, we can then finalize the total cost & payme Thêm

$31 USD / giờ
(54 Nhận xét)

Hello, Greetings from Ace Infoway Pvt. Ltd...! Interesting project. We are government awarded best software development company in Microsoft technologies..! You can check it out on our website. We can s Thêm

$25 USD / giờ
(172 Nhận xét)

Hello, My name is Janos and I'd like to help you on this! The requirement seems fairly straightforward, my only question is if you can provide a test server or a database backup instead of just providing specific st Thêm

$52 USD / giờ
(76 Nhận xét)

Greetings, This is Kris from DreamzTechUSA. Please open the chat room so we can discuss this in details. To get an idea of the quality of our work you can check the below link : [login to view URL] Thêm

$41 USD / giờ
(22 Nhận xét)

I have 16 years of experience with MSSQL (check exams of SQL and SQL Server) , 20 years experience with databases . We are Israel based premier specialist IT solutions and services company, that combines core techni Thêm

$30 USD / giờ
(8 Nhận xét)

Hi I am Microsoft Certified Professional in MS SQL Server having 10+ years of professional development experience. Currently, I am working in Vodafone UK as MS SQL Server Database Specialist. I am willing to work Thêm

$47 USD / giờ
(78 Nhận xét)

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid Skype - khalidpal Thêm

$41 USD / giờ
(39 Nhận xét)

Hi There Senior SQL Engineer here. I would like to complete this project for you. I can provide you with my certifications as well. Please let me know when your available to discuss further.

$50 USD / giờ
(33 Nhận xét)

I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well and within your budget. I have worked on similar projects to what you are looking for, and I am c Thêm

$37 USD / giờ
(18 Nhận xét)

Hello, have you applied any calculations to the query output you have provided? The dmv you have taken this from is sys.dm_exec_query_stats, are you aware the values in this view are in microseconds? This means your Thêm

$30 USD / giờ
(26 Nhận xét)

Dear Sir, This is Sikander. I am having 12+ years of experience in software development and I am ready to start this job. Please discuss with detail project specification, so, I can give you the exact time frame and Thêm

$25 USD / giờ
(11 Nhận xét)

A proposal has not yet been provided

$27 USD / giờ
(35 Nhận xét)

Hi, I have gone through your requirements. I am 12+ years experienced Database Administrator at CMMI-5 level company. I am working on : RDBMS: Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools Thêm

$30 USD / giờ
(35 Nhận xét)

I have over 6 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.Net / C# ) ,PHP, WordPress, ASP CLASSIC etc. Scri Thêm

$50 USD / giờ
(26 Nhận xét)

George here based from Los Angeles, USA. I am expert in desired skills for this project and have done similar tasks already. Please get back to me, so I can show you some of the work I have done.

$38 USD / giờ
(57 Nhận xét)

Hi, Here you are with CTO of Cubic with 23 years of professional experience & Ex Microsoft Technical Head , we have deployed many SQL, Windows, SBS Servers for our clients as well as in our infrastructure and mainta Thêm

$50 USD / giờ
(4 Nhận xét)

Warm Regards. Microsoft certified DBA. i am working with CMM5 level MNC have more than 5 years experiance.. i would like to work on your project..rest if you would like to discuss something feel free to chat in PM. Thêm

$52 USD / giờ
(6 Nhận xét)

I have 7 years experiance with SP on MSSQL Please see my cert at : [login to view URL] Transcript Id : 950871 Access Code : thampl0411

$27 USD / giờ
(5 Nhận xét)

Hi, I'm an expert DBA. You can give me access to let me discover those procedures and views. Sincerely yours, Eric

$25 USD / giờ
(1 Nhận xét)

Greetings, i'm not a mvp but i think i don't need it to check the performance of your database, i have over 3 years of experiences and the most i like is troubleshoting and tuning database, i'm really interested in che Thêm

$30 USD / giờ
(1 Nhận xét)