Fix Too frequent deadlocks in database transactions

We are running a database for student registration, fee collection and few other financial transactions. Database is hosted on dedicated server with SQL Server Std. Editon.

Client applications are using that database through web services running on IIS Server. IIS server is running on same machine.

We are facing too many deadlocks due to which client application are not running properly.

Here your goal is to identify reason for those deadlocks, identify involved objects, queries, SPs etc., rectify problem and remove deadlocks completely.

We will also need a report on cause for deadlocks with suggestions to remove then, so we could avoide them in further development.

We will provide XML trace file from SQL profiler.

If you need any other info then please do not hesitate to ask.

Payment will be released after running database for at least 5 days after you complete work.

## Deliverables

We are running a database for student registration, fee collection and few other financial transactions. Database is hosted on dedicated server with SQL Server Std. Editon.

Client applications are using that database through web services running on IIS Server. IIS server is running on same machine.

We are facing too many deadlocks due to which client application are not running properly.

Here your goal is to identify reason for those deadlocks, identify involved objects, queries, SPs etc., rectify problem and remove deadlocks completely.

We will also need a report on cause for deadlocks with suggestions to remove then, so we could avoide them in further development.

We will provide XML trace file from SQL profiler.

If you need any other info then please do not hesitate to ask.

Payment will be released after running database for at least 5 days after you complete work.

MySQL Odd Jobs Software Architecture SQL

Project ID: #2738663

About the project