This article shows you how to identify SQL Server performance problems and explains how the SERIALIZABLE transaction isolation level effected the performance of an OLTP application.
Recently I was asked to improve the performance of an application, that was about to go into production. It was suffering from performance issues. Testers were not very happy with the performance of the application and sometimes the application failed with unexpected errors. I agree this is not a very detailed problem description, but this is all I had, to start with. My immediate task was to narrow down and identify the problem areas and fix them.
I used Performance monitor to see if there are any bottlenecks that are having an impact on the overall system performance.
The article continues at