Concluído

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.

Habilidades: Administração de Bancos de Dados, Microsoft SQL Server , MySQL

Veja mais: 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

Acerca do Empregador:
( 6 comentários ) Jeddah, Saudi Arabia

ID do Projeto: #7116808

Concedido a:

mpalgeo

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 Mais

$25 USD / hora
(69 Comentários)
6.2

43 freelancers estão ofertando em média $36/hora para esse trabalho

leadconcept

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 Mais

$31 USD / hora
(49 Comentários)
8.3
o2iplanet

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 Mais

$25 USD / hora
(172 Comentários)
7.6
CodeAmbassador

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 Mais

$52 USD / hora
(76 Comentários)
7.3
krishdts

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] Mais

$41 USD / hora
(22 Comentários)
7.6
thecloudkernel

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 Mais

$30 USD / hora
(8 Comentários)
6.7
ngscoder

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 Mais

$47 USD / hora
(78 Comentários)
6.8
sikandermandal

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 Mais

$25 USD / hora
(11 Comentários)
5.6
robnicholson

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 Mais

$30 USD / hora
(25 Comentários)
5.7
Lee2133

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 / hora
(30 Comentários)
5.4
fanninson45

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 Mais

$37 USD / hora
(16 Comentários)
5.5
kmpal

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 Mais

$41 USD / hora
(34 Comentários)
5.6
elboukharimu

A proposal has not yet been provided

$27 USD / hora
(35 Comentários)
5.3
acronymsolutions

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 Mais

$30 USD / hora
(35 Comentários)
5.5
AliSafder

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 Mais

$50 USD / hora
(23 Comentários)
4.5
superior5

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 / hora
(57 Comentários)
7.3
mk73rc

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 Mais

$50 USD / hora
(4 Comentários)
4.0
mikeblane

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. Mais

$52 USD / hora
(6 Comentários)
5.1
thampl

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 / hora
(5 Comentários)
3.4
grundahl

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

$25 USD / hora
(1 Comentário)
2.7
fsarcosfree

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 Mais

$30 USD / hora
(1 Comentário)
0.9