Submit a ticketCall us

WebinarVisual Monitoring Tactics: Getting More Log Search Value from SolarWinds Log & Event Manager with nDepth Webcast

Do things seem to make more sense when they are visualized? Are you an IT professional or security expert with a wish for more cybersecurity tools that provide an intuitive visual experience? Join Alexis Horn and Jamie Hynds from SolarWinds as they demonstrate how the nDepth feature in LEM can help make visualizing log search results a reality.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Comments inserted by DPA in SQL text

Comments inserted by DPA in SQL text

Table of contents

Updated September 14, 2016

Overview

In some of the SQL text that DPA collects, it inserts 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 it is not. This article explains why DPA inserts this information. 

Environment

DPA for SQL server

Detail

DPA is providing information about where the SQL statement is being run from. 

DPA shows the SQL statements that ran and the wait time for each SQL statement. Stored procedures include many statements. If, for example, a stored procedure included an Insert, an Update, and a select statement, DPA would show the wait time for each one as a separate SQL hash value. It would also try to map each statement to the stored procedure. The name of the stored procedure is usually shown in the comment block.

 

Last modified

Tags

Classifications

Public