Abstract
This chapter discusses some of the various tools that can be used to find problem queries. Problem queries are queries taking too long to run or hoarding too many resources or both. Problem queries are common in ad hoc user structured query language (SQL) environments and sometimes a result of poor SQL coding, or even impossible to-build SQL queries because the underlying database model is inadequate or inappropriate. Database administrators often have the responsibility of ensuring that performance-impacting queries are located and tuned. Also, if end users or application developers are responsible for submitting poorly performing queries to a database, then tactful advice and even some training might be beneficial to all in an organization. SQL code tuning has been covered from the perspective of writing usable SQL code rather than an in-depth analysis of the tools used to find problems. Therefore, writing SQL code properly in the first place might help avoid having to use in-depth and overbearing SQL code tuning tools.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.