Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Add information to the trend view blockers tab like the current view blockers tab.

Currently in DPA there is a larger list of information given in the blockers on the current view then there is in the historical trend view.

This is the list of columns in the current view.

spid

loginame

program_name

hostname

db_name

lastwaittype

cmd

sql_hash

sql_handle

stmt_start

stmt_end

kpid

blocked

waittype

waittime

waitresource

dbid

uid

cpu

physical_io

memusage

login_time

last_batch

ecid

open_tran

status

sid

hostprocess

nt_domain

nt_username

net_address

net_library

context_info

request_id

This is the columns given in the trend view for historical data.

SPID

Caused

Waited

User

Program

Machine

SQL

Wait

This request would be to extend the historical trend blockers tab to have all these additional columns.

Find more posts tagged with

Status: None

Comments

red8rain

guys, lets add this okay? telling me what the waittype is is absolutely useless. please add WaitResource or just copy and paste what's in the blocker to the histrocial trend blockers tab.

thanks.