Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > (inserted by DPA) in SQL text

(inserted by DPA) in SQL text

Table of contents

Updated September 14, 2016

Overview

DPA has some items in the SQL text that we collect where it will insert a comment such as the following:

/* (inserted by DPA)
Procedure: [dbo].sp_someProcedure
Character Range: 4906 to 6649 
Waiting on statement:

This sometimes gets mistaken as a procedure DPA is running but, this isn't want this means. This article is to explain why you will see this in the DPA and what it is doing. 

Environment

DPA for SQL server

Detail

This is not being run by DPA. DPA is trying to give you a hint on where this is run from. 
DPA shows the SQL running and the wait time for SQL statements. If DPA sees stored procedures for example, these have many statements. If for example you had one that had an Insert, an Update, and a select, DPA will show the wait time for each as separate SQL hash values. It also will try to map the statement to the stored procedure. Usually if we grab the name of the stored procedure it will show in the comment block.

 

Last modified
10:14, 20 Sep 2016

Tags

Classifications

Public