year 2009
MSSQL 2000
database optimization service
Database Optimization Result
1.0 | Before optimization
1.1  | 
User complained that printing the monthly statement took about 15 seconds.
1.2 | 
User complained that viewing the historical data took about 5 seconds to show on the screen.
1.3 | 
Deadlock occurred during generating payment voucher.
2.0 | After optimization
2.1  | 
After optimization, it took less than 1 second to generate the monthly statement.
2.2 | 
After optimization, the system took less than 1 second to show the historical data on screen.
2.3 | 
After optimization that includes patching the stored procedure, the deadlock problem has been resolved.
Client Background
The client is running an inhouse built ERP System.