Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2017December18 - Deletes > SQL suspended processes with no impact on SolarWinds products

SQL suspended processes with no impact on SolarWinds products

Table of contents
Created by Eric Bryant, last modified by Kevin.Swinson on Dec 18, 2017

Views: 826 Votes: 1 Revisions: 5

Overview

This article provides information about suspended queries in SQL that have no performance impact on SolarWinds Orion products.

The following is an example of a SQL query with a long running CPU time:

TEXT
session_id
status
command
cpu_time
total_elapsed_time
create procedure sys.sp_trace_getdata
(@traceid int,
  @records int = 0
)
as
select * from OpenRowset(TrcData, @traceid, @records)

Environment

All Orion Core versions

Detail

This type of query could happen with SolarWinds Orion products, including DPA. This query has 0 wait time and continuously runs without performance impact.

 

The following query extracts information on suspended processes:

 SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

 

 

Last modified

Tags

Classifications

Public