Conclusion

Conclusion

This chapter highlights the ways to identify bottlenecks at the SQL layer. The tools used to monitor the server and identify bottlenecks as well as ways to analyze and improve common bottlenecks have been discussed. Learning everything there is to know about SQL Server will certainly take time and experience. This chapter will not make you an expert overnight but will certainly give you insight into identifying bottleneck and coming up with quick fixes to common performance issues encountered at the SQL tier.