COM+, SQL Server & Serializable isolation level

Thursday Mar 6th 2003 by DatabaseJournal.com Staff
Share:

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.

[From vyaskn.tripod.com]

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 http://vyaskn.tripod.com/com_isolation_level.htm

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved