As the number of users of an application (Web or Windows forms) increases , the performance of the application is limited by its slowest part. The slowest piece of an application at any given time is referred to as the application's "bottleneck." There will almost always be a bottleneck in your application because one component or another will always be slower than the others. In this hour, you'll see some effective techniques you can use to ensure that the data access portion of your application isn't the bottleneck.
In this hour, you'll learn
Some tips to improving your ADO.NET code for faster data access
How to use the tracing functionality in ASP.NET to locate bottlenecks in your application
How to use the SQL Query Analyzer to improve the speed of your database queries