TEC600881: SQL Agent Average Response Time vs. Average Result Processing Time.

Document created by KulbirNijjer Employee on May 25, 2016Last modified by SamCreek on May 25, 2016
Version 2Show Document
  • View in full screen mode

Author: KulbirNijjer

 

Document ID:  TEC600881

Last Modified Date:  10/21/2013

  • Products
    • CA Application Performance Management
    • CA Introscope
  • Releases
    • CA Application Performance Management:Release:9.1.0
    • CA Application Performance Management:Release:9.1.1
    • CA Application Performance Management:Release:CA APM 9.5
  • Components
    • WILY INTROSCOPE
    • INTROSCOPE AGENT
    • SQL AGENT
    • APPLICATION PERFORMANCE MANAGEMENT
    • APM AGENTS

style="margin-bottom:10px"

  • The application performs a lot of inefficient processing for each row of data in between fetching it, rather than fetching all of the data into a ResultSet object, closing the ResultSet and then processing it.

 

 

Search the Entire CA APM Knowledge Base

 

search-kb.jpg

Attachments

    Outcomes