Devam Ediyor

MSSQL Stored Procedure PerformanceTuning

Before you read on, know that I am looking for someone who is very familiar with how ERP systems like Oracle and SAP work, and has years of experience working with Microsoft SQL and .NET technologies.

I am looking for an experienced Microsoft SQL Query/Stored Procedure expert to help to tune a stored procedure that is very inefficient. It causes a huge amount of growth in the SQL transaction log file, it timeouts or simply takes way too long to run most of the time.

I am trying to avoid having to use a CLR procedure due to the fact that we need to be able to install it quickly. If you don't know what a CLR procedure is please move on to the next project.

The program has quite a bit of business logic in it which makes the use of indexes and such difficult. It is 640 lines of code presently. I have tried increasing performance by removing all Cursors from the logic and trying to use temp tables with my own indexes (#temp for example). I have greatly improved performance but it's still no where near I think it should be.

I am looking for a long term contact that I can rely on for future tuning as well as new development projects to be written in Microsoft SQL, .NET, and ASP .NET.

Beceriler: .NET, Üretim, Oracle, SAP, SQL

Daha fazlasını görün: need sap, new oracle business, temp work, sql code oracle, simply logic technologies, oracle sql projects, net systems, looking sap projects, mssql stored procedure performance, sql stored procedure tuning, sql clr, performance tuning oracle, oracle performance, new net technologies, mssql having, erp sap, erp logic, stored, sap sql, sap erp, performance tuning, oracle net, oracle business, next move, move sql

İşveren Hakkında:
( 23 değerlendirme ) benbrook, United States

Proje NO: #739751

Seçilen:

JohnInFL

Please read PBM, thank you for your time!

7 gün içinde 30$ USD
(2 Değerlendirme)
2.3

10 freelancer bu iş için ortalamada 278$ teklif veriyor

tejas34

Please check PMB for more details.

in 7 gün içinde250$ USD
(32 Değerlendirme)
5.9
kamosion

Hello, please see PMB.

in 2 gün içinde250$ USD
(8 Değerlendirme)
5.2
akjajoo123

Please check pmb.

in 7 gün içinde150$ USD
(24 Değerlendirme)
5.2
tfcarlos

I have more than 10 years of experience with sql server. I have knowlodge of SAP erp.

in 5 gün içinde250$ USD
(1 Değerlendirme)
4.0
yngautam

Please see pmb.

in 7 gün içinde250$ USD
(6 Değerlendirme)
3.0
mdaxini

Hello, we are the expert team in Asp.net working since 2 years. We will give you your work within your time limit. thanks, md

in 4 gün içinde230$ USD
(3 Değerlendirme)
2.9
goxy011

We must work together on a problem. 2-way communication, I mean. Please check PM.

in 7 gün içinde150$ USD
(0 Değerlendirme)
0.0
alexeyup

Hi, we can do it. Please contact me to discuss details

in 5 gün içinde1000$ USD
(0 Değerlendirme)
0.0
ocherk

Hi, my specialization is tuning of large databases, vies, procedures, sqlclr procedures.

in 3 gün içinde215$ USD
(0 Değerlendirme)
3.0