SQL Server Performance Tuning Part 3

Before going to tune the query as an experience developer you should aware on

If your application stops working suddenly, it may not be a database issue. For example, maybe you have a network problem. Investigate a bit before you approach the DBA!

The below are the few generic points for tuning.

Transaction Level Tuning Tips

1. Avoid long-running transactions.

2.  Avoid transactions that require user input to commit.

3.  Access heavily used data at the end of the transaction.

4.  Try to access resources in the same order.

5. Use isolation level hints to minimize locking. For more information about isolation level please click here

6. Ensure that explicit transactions commit or roll back.