In many websites, database access is the most expensive part of producing a web page. This chapter shows how to identify the most common sources of delays and how to resolve them.
SQL Server is a very large subject in itself. Rather than attempting to cover all aspects of SQL Server database access, this chapter focuses on those areas where you are likely to gain the biggest payoffs.
It consists of two major sections:
The Fixing bottlenecks ...