Find Jobs
Hire Freelancers

SQL server tunning planning for high concurrencies

$250-750 USD

Lezárt
Kiadva ekkor: körülbelül 5 évvel ezelőtt

$250-750 USD

Teljesítéskor fizetve
Hi everyone! I beg you: Please read bellow: We have a SQL Server 2008 database that contains 1.1 Terabytes of size and high concurrencies on its queries. We need a tunning plan to control "Deadlock victim" ocurrencies. All queries came from ERP system developed with .NET plataform. The ERP system is keep improoving a better reading and writing by developers team. If you know about tools that can monitors the queries and suggest us to better configure the ISOLATION LEVEL, TRANSACTION MODE and DEADLOCK PRIORITY, please make your bid for us. Thanks!
Projektazonosító: 18817367

A projektről

23 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
23 szabadúszó adott átlagosan $493 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Hi there, sir i read your initial requirements and i have some question regarding to your SQL tuning project. please send me message so that we could discuss it further
$250 USD 3 napon belül
4,9 (125 értékelés)
7,7
7,7
Felhasználó avatár
Hello, Dear How are you? I have checked your project description and am ready for discussing with you about project for now. I have experienced in developing .NET, ASP.NET, C# Programming, Microsoft SQL Server, SQL. I will work very hard and best for you. Best Regards
$500 USD 10 napon belül
4,9 (17 értékelés)
6,6
6,6
Felhasználó avatár
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep
$750 USD 10 napon belül
5,0 (36 értékelés)
6,2
6,2
Felhasználó avatár
Hello ,I have 3+ experienced Asp.Net in C#, i will develop your applications as per your requirements and your time. I will provide you following technology - Asp.net - C# -VB - Kendo -Sqlserver (Latest version) as per your requirement - Ms-Access -Web services DataBase (Mysql , sqlite, sql). i can also work on Database or Schema Designing Development of Database Database Programing ERD Development Data Flow Diagram Class Diagram Normalization (1nf,2nf,3nf). I believe in QUALITY and QUICK service. I am sure you 'll satisfied 100% with my work. I am sure you'll satisfied 100% with my work. i am waiting for your response. reply me soon Thank You!
$381 USD 10 napon belül
4,9 (28 értékelés)
5,1
5,1
Felhasználó avatár
Hello, my name is Anatoli Bosenko, I'm a senior .NET developer from Minsk, Belarus. Understanding and solving such problems, as you described is in my competence. You need to gather an info about locks on various layers of db in situations related to deadlock. "Extended Events" feature could be a quite powerful tool for it, if used in right way (could be enable for a short time even on high-loaded systems). After you have an info about locks and queries related to it, there are some possibilities depending on what kind of access layer you use (EF, dapper, stored procedures or smth else). Basicly the trick is to customize the query to make it "atomic" (not every time possible), or as you described to use right ISOLATION LEVEL, TRANSACTION MODE and so on. If you want me to have a look - feel free to write me. Good luck!
$350 USD 10 napon belül
5,0 (1 értékelés)
5,1
5,1
Felhasználó avatár
Hello, Proposal: I would like to offer my services as database tunning expert, the deadlock issues caused by high concurrency will be tackled through a proper systematic process that will involve studying the high level structure of your database schema and data, then monitoring the traffic to your SQL server by using SQL Server profiling and finally properly configuring the isolation levels as you mentioned in the project description, apart from isolation level configuration there are other techniques as well to cop with deadlock issues. Relevant Experience: I have been working with Azure SQL for the past 3 years, and during this time i have been involved with team that have been tackling issues like Deadlocks, query optimization, indexes recommendations etc. About Me: I am a full time .Net developer with hands on experience of about seven and a half years, i have expertise in following: * MS SQL Server * Big Data * Asp.net web forms * Asp.net MVC * Asp.net Web API * C# * HTML, Javascript, JQuery, CSS, Ajax I work as individual on freelancer and full time as .Net team lead in a software firm. Please share the details of your project and let's start working together :) We can discuss any questions and concerns in PM. Thanks
$666 USD 10 napon belül
5,0 (16 értékelés)
4,9
4,9
Felhasználó avatár
I have more than 14 years of experience on database. I have good hands on on all kind of isolation and which one is best fit in which place. Also I know how to handle exception handling. Using these 2 things we will be able to achieve handling of deadlock. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, Javascript, ASP.Net with C# language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$722 USD 10 napon belül
5,0 (34 értékelés)
5,1
5,1
Felhasználó avatár
we have a graet team of members to perform this project on time and best....High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.
$311 USD 10 napon belül
5,0 (1 értékelés)
4,1
4,1
Felhasználó avatár
Hi, my name is Esteban Salpeter and I'm an experienced developer, with many years on different platforms. You can check out my portfolio to view some of my work. I can give you full advise on your current DB programming and strategies to manage all that big data! The plan is to understand the model and how the ERP interacts, do some monitoring and then give you a full optimizing plan. Feel free to ask me any questions before contracting, I'll be glad to chat with you. Hoping to start working together soon, Best regards, Esteban
$750 USD 20 napon belül
5,0 (5 értékelés)
3,6
3,6
Felhasználó avatár
Hi, I can help you I'm expert in tuning performance,I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014, SAN Storage and Backup Solutions Regards Shaker
$250 USD 5 napon belül
5,0 (5 értékelés)
3,5
3,5
Felhasználó avatár
Hello , Greetings !!! I just read your Project Description and i m willing to go ahead and start SQL isolation and tunning problem . I have done this kind of project recently i can give you this Project in real quick time. I have 10 year working experience on multiple Database Project based on MS SQL server, mysql and Oracle. i will work in Strategic milestones and transparency so that you will be frequently uploaded on where we stand in the project i can achieve the result that you are looking . Looking forward to hearing at your earliest convenience. Thank you Avin Pawar
$622 USD 10 napon belül
5,0 (2 értékelés)
1,2
1,2
Felhasználó avatár
I think your database server has to handle mane transactions, that is why deadlock is happening. I can help you. Recently a have worked on a project which is build on SQL server 2012 and the application handles large amount of data. Let's discuss.
$500 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello, I have experience +5 years in SQL Server. chat for more details. Looking forward to working with you.
$500 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi, I am having 8+ Years of experience in SQL. Worked on majorly performance tuning of sql queries and application. having knowledge of ERP system as well.
$444 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hey, I can really do it. i have been doing this for about a decade. I have worked on various versions of SQL servers for the performance tuning issues several times. Thanks, Gopal
$555 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I am well capable enough to handle such projects since I have an experience of 8+ years of experience.
$777 USD 20 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I have been carrying out the tasks of Project Manager, Database Manager, System and Configuration Manager, software module manager, analyst team leader, Test team leader in projects that have been successfully progressing for 10 years in the field of information systems. I continuously follow the innovations, developments and publications in the fields of software, programming, system and database. Thanks to the projects I have been working with, I would like to continue my career in this sector and develop it further. I also want to use my knowledge and experience in a dynamic business environment. I believe that my academic knowledge and experience in my business life coincide with what is sought for in this position. I would very much like to discuss with you in detail about the appropriateness of position and position to my skills.
$500 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
give me chance to work on it , i will provide you solution with in a week. previously i worked on same situation of deadlock .
$555 USD 10 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

BRAZIL zászlója
SÃO PAULO, Brazil
5,0
84
Fizetési mód hitelesítve
Tagság kezdete: jan. 19, 2010

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.