amachanic/sp_whoisactive

Issues

• Insert to table fails when using case sensitive collation

  #123 opened 2 months ago by bealer
  2

• Is @get_transaction_info = 1 accurate?

  #112 opened 5 months ago by jcggaurino
  2

• Figure out if anything needs to change with Optimized Locking

  #122 opened 3 months ago by erikdarlingdata
  0

• sp_whoisactive on SQL2022 Always on AG random fails

  #121 opened 3 months ago by x1ebnik
  0

• Sql Server 2022 Support?

  #120 opened 5 months ago by carehart
  6

• Can't find a permission set to run sp_whoisactive on an Azure DB

  #109 opened 5 months ago by proofrock
  5

• Show user_name information to 'external provider' instead of login_name

  #87 opened 5 months ago by aquilavqalmeida
  2

• Should new memory columns be divided by 8?

  #98 opened 5 months ago by erikdarlingdata
  2

• XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels

  #111 opened 5 months ago by rwyoung01
  1

• An error occurred while executing batch. Error message is: Name cannot begin with the ' ' character, hexadecimal values 0x20. Line 5372, position 60.

  #99 opened 2 years ago by STLJim
  10

• Issue with Loading WhoisActive Results Due to Nested XML Nodes

  #119 opened 6 months ago by Imran-imtiaz48
  1

• Has this repo become Archived/in Maintenance mode?

  #118 opened 8 months ago by PureKrome
  1

• Intermittent error

  #117 opened 9 months ago by AndersonSouzaDBA
  1

• SQL 2019 errors

  #114 opened 9 months ago by dca00
  1

• I am facing below warning once the execution is stopped for sp_whoisactive.. Should I be worried for the data due to this?

  #115 opened 9 months ago by sumabris
  1

• active_transaction_count > than reported on sys.dm_tran_active_transactions

  #116 opened 10 months ago by ptmarco
  1

• 'Dormant' should be treated the same as 'sleeping'

  #110 opened a year ago by JC-aus
  0

• An error occurred while executing batch. Error message is: Name cannot begin with the '>' character, hexadecimal value 0x3E. Line 126, position 22.

  #100 opened a year ago by ghauan
  1

• @get_full_inner_text = 1

  #101 opened a year ago by Sicos1977
  3

• Scalability issue when >740K syslockinformation rows

  #108 opened a year ago by pablos-here
  4

• Invalid SPID nnn specified when logging to a table

  #107 opened a year ago by genetsmartx
  4

• SQL Agent job no longer works with SQL 2022

  #106 opened a year ago by sfoulk
  4

• Empty Results Set from sp_WhoIsActive

  #105 opened a year ago by Susja
  1

• Addition of Session level Wait stats

  #102 opened a year ago by dataVidyarthi
  0

• add query_text_id column

  #97 opened 2 years ago by masterpikx
  1

• On index creation the IO doesn't return correct results

  #93 opened 2 years ago by mfuller333
  0

• Show user friendly job_name in top level column program_name instead of job_id in hex

  #66 opened 3 years ago by mfuller333
  10

• Error Creating Procedure on Synapse Dedicated Sql Pool

  #90 opened 2 years ago by frank-bluemke
  0

• Error related with availability group

  #45 opened 2 years ago by MaxShoshin
  14

• Feature: Add encrypted information into session output

  #79 opened 3 years ago by dalehhirt
  3

• Output wait duration in a dedicated column

  #82 opened 3 years ago by ant-222
  1

• Add column to show object (stored procedure) name from dm_exec_sql_text

  #91 opened 2 years ago by aroques
  2

• SET STATISTICS XML OFF to avoid getting sp_WhoIsActive's execution plan

  #88 opened 3 years ago by BrentOzar
  3

• request to add job_name and step_name in new columns

  #86 opened 2 years ago by johnecono54
  1

• No results when running on an AG read-only secondary

  #83 opened 2 years ago by gbritton1
  2

• filling up default trace

  #81 opened 3 years ago by murtujakhokhar
  2

• Add ability to return original_login_name in results

  #84 opened 3 years ago by AdamWilbur
  1

• SQL Server exception running sp_WhoIsActive regularly

  #54 opened 3 years ago by philcart
  3

• Show Param Values with @Get_Outer_Command = 1

  #73 opened 3 years ago by datadill
  7

• CheckCPUPercent/Capture WhoIsActive Data

  #74 opened 3 years ago by jdgleason01
  2

• An upcoming change in waitresource format will break sp_whoisactive

  #56 opened 3 years ago by dimitri-furman
  4

• Get the duration in seconds (in combination with @format_output)

  #50 opened 3 years ago by buckleyGI
  2

• Add implicit transaction column to output

  #41 opened 3 years ago by erikdarlingdata
  8

• Add context_info to output

  #40 opened 3 years ago by kottivakkam
  4

• Login_name not useable in Azure SQL DB for Managed Identities

  #55 opened 3 years ago by ryandevries
  1

• Arithmetic overflow error converting expression to data type int

  #43 opened 3 years ago by imajaydwivedi
  1

• Add server_name column to output

  #44 opened 3 years ago by jahveman
  2

• Convert Deprecated sys.sysprocesses to sys.dm_exec_sessions

  #57 opened 3 years ago by sparkledoney
  3

• Persisting blocked_session_count shows 0

  #42 opened 3 years ago by datadill
  3

• The current transaction cannot be committed and cannot support operations that write to the log file.

  #39 opened 4 years ago by p-doyle
  6