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: who need sap, what new on oracle business, what is a temp, temp work, sql code oracle, simply-logic technologies, simply logic technologies, procedure sql oracle, oracle sql projects, net it systems, looking for sap projects, i net technologies, mssql stored procedure performance, sql stored procedure tuning, what is sap experience, what is erp sap, sql clr, performance tuning in oracle, oracle performance, new net technologies, mssql having, ERP SAP, erp logic, stored, SAP SQL

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

Proje NO: #739751



Please read PBM, thank you for your time!

%selectedBids___i_period_sub_7% gün içinde 30%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)

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


Please check PMB for more details.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(32 Değerlendirme)

Hello, please see PMB.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

Please check pmb.

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(24 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

Please see pmb.

in %bids___i_period_sub_35% gün içinde250%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde230%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

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

in %bids___i_period_sub_35% gün içinde215%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)