Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / amachanic/sp_whoisactive issues and pull requests

#112 - Is @get_transaction_info = 1 accurate?

Issue - State: closed - Opened by jcggaurino 10 months ago - 2 comments

#98 - Should new memory columns be divided by 8?

Issue - State: closed - Opened by erikdarlingdata over 1 year ago - 2 comments
Labels: question

#97 - add query_text_id column

Issue - State: closed - Opened by masterpikx over 1 year ago - 1 comment

#96 - Add automatic line ending conversion

Pull Request - State: open - Opened by zikato over 1 year ago

#95 - Update sp_WhoIsActive.sql

Pull Request - State: open - Opened by erikdarlingdata over 1 year ago
Labels: enhancement

#94 - Prevent XML parsing error

Pull Request - State: open - Opened by zikato over 1 year ago

#93 - On index creation the IO doesn't return correct results

Issue - State: open - Opened by mfuller333 over 1 year ago

#92 - fix: add encrypt_option to additional_info xml output.

Pull Request - State: open - Opened by dalehhirt almost 2 years ago - 1 comment

#91 - Add column to show object (stored procedure) name from dm_exec_sql_text

Issue - State: closed - Opened by aroques almost 2 years ago - 2 comments

#90 - Error Creating Procedure on Synapse Dedicated Sql Pool

Issue - State: closed - Opened by frank-bluemke about 2 years ago

#89 - #88 add SET STATISTICS XML OFF to stop showing actual plans

Pull Request - State: closed - Opened by BrentOzar over 2 years ago - 1 comment

#88 - SET STATISTICS XML OFF to avoid getting sp_WhoIsActive's execution plan

Issue - State: open - Opened by BrentOzar over 2 years ago - 3 comments
Labels: enhancement

#87 - Show user_name information to 'external provider' instead of login_name

Issue - State: closed - Opened by aquilavqalmeida over 2 years ago - 2 comments
Labels: enhancement

#86 - request to add job_name and step_name in new columns

Issue - State: closed - Opened by johnecono54 over 2 years ago - 1 comment

#85 - Adding handling for errors in Azure SQL DB

Pull Request - State: open - Opened by Tyoung97 over 2 years ago - 1 comment

#84 - Add ability to return original_login_name in results

Issue - State: closed - Opened by AdamWilbur over 2 years ago - 1 comment

#83 - No results when running on an AG read-only secondary

Issue - State: closed - Opened by gbritton1 over 2 years ago - 2 comments

#82 - Output wait duration in a dedicated column

Issue - State: open - Opened by ant-222 over 2 years ago - 1 comment
Labels: enhancement

#81 - filling up default trace

Issue - State: closed - Opened by murtujakhokhar over 2 years ago - 2 comments

#80 - Initial addition of encrypt_option column.

Pull Request - State: closed - Opened by dalehhirt almost 3 years ago - 3 comments

#79 - Feature: Add encrypted information into session output

Issue - State: open - Opened by dalehhirt almost 3 years ago - 3 comments

#78 - Small corrections

Pull Request - State: closed - Opened by zikato almost 3 years ago - 1 comment

#77 - Change the DMV we get the status from to sys.dm_exec_sessions instead of sys.sysprocesses

Pull Request - State: open - Opened by mfuller333 almost 3 years ago - 2 comments

#76 - getting rid of SP_SERVER_DIAGNOSTICS_SLEEP

Pull Request - State: open - Opened by rudi-bruchez almost 3 years ago

#75 - getting rid of SP_SERVER_DIAGNOSTICS_SLEEP

Pull Request - State: closed - Opened by rudi-bruchez almost 3 years ago

#74 - CheckCPUPercent/Capture WhoIsActive Data

Issue - State: closed - Opened by jdgleason01 almost 3 years ago - 2 comments

#73 - Show Param Values with @Get_Outer_Command = 1

Issue - State: closed - Opened by datadill almost 3 years ago - 7 comments
Labels: enhancement

#72 - Update sp_WhoIsActive.sql

Pull Request - State: closed - Opened by pelya1986 about 3 years ago - 8 comments

#71 - [ENH] Tab Out, Space In

Pull Request - State: closed - Opened by amachanic about 3 years ago
Labels: enhancement

#70 - [FIX] Remove last_request_end_time predicate

Pull Request - State: open - Opened by amachanic about 3 years ago - 3 comments
Labels: bug

#69 - [#4] Add file sp_WhoIsActive.sql

Pull Request - State: closed - Opened by amachanic about 3 years ago
Labels: enhancement

#68 - [#38] Fix money overflows

Pull Request - State: closed - Opened by amachanic about 3 years ago
Labels: bug

#67 - [#45] Test PR

Pull Request - State: closed - Opened by amachanic about 3 years ago
Labels: enhancement

#66 - Show user friendly job_name in top level column program_name instead of job_id in hex

Issue - State: open - Opened by mfuller333 about 3 years ago - 10 comments
Labels: enhancement

#65 - Add implicit transaction column

Pull Request - State: closed - Opened by amachanic about 3 years ago - 2 comments
Labels: enhancement

#64 - Fix documentation

Pull Request - State: closed - Opened by erikdarlingdata about 3 years ago

#63 - Fix issue with AG databases

Pull Request - State: closed - Opened by erikdarlingdata about 3 years ago

#62 - Add implicit transaction column to output

Pull Request - State: closed - Opened by erikdarlingdata about 3 years ago - 3 comments

#61 - Add context info to additional info column

Pull Request - State: closed - Opened by erikdarlingdata about 3 years ago - 1 comment

#60 - Replace XML characters in l4.resource_description

Pull Request - State: closed - Opened by erikdarlingdata about 3 years ago - 3 comments

#59 - Changed to trim extra latch info from waitresource

Pull Request - State: closed - Opened by dimitri-furman about 3 years ago - 7 comments
Labels: enhancement

#58 - Change CPU column from INT to BIGINT

Pull Request - State: closed - Opened by erikdarlingdata about 3 years ago
Labels: enhancement

#57 - Convert Deprecated sys.sysprocesses to sys.dm_exec_sessions

Issue - State: closed - Opened by sparkledoney about 3 years ago - 3 comments

#56 - An upcoming change in waitresource format will break sp_whoisactive

Issue - State: closed - Opened by dimitri-furman about 3 years ago - 4 comments
Labels: enhancement

#55 - Login_name not useable in Azure SQL DB for Managed Identities

Issue - State: closed - Opened by ryandevries about 3 years ago - 1 comment

#54 - SQL Server exception running sp_WhoIsActive regularly

Issue - State: closed - Opened by philcart about 3 years ago - 3 comments

#53 - Additional memory counters, SQL versioning, and memory XML output

Pull Request - State: closed - Opened by mfuller333 over 3 years ago - 20 comments
Labels: enhancement

#52 - Add support for additional parallelism waits

Pull Request - State: closed - Opened by erikdarlingdata over 3 years ago - 2 comments
Labels: enhancement

#51 - Support new parallel wait types

Pull Request - State: closed - Opened by erikdarlingdata over 3 years ago - 1 comment

#50 - Get the duration in seconds (in combination with @format_output)

Issue - State: closed - Opened by buckleyGI over 3 years ago - 2 comments

#49 - [#42] Fixed blocked session output

Pull Request - State: closed - Opened by amachanic over 3 years ago - 1 comment
Labels: enhancement

#48 - All new memory counters

Pull Request - State: closed - Opened by mfuller333 over 3 years ago - 19 comments

#47 - Added Memory DMV to handle memory requests, and grants

Pull Request - State: closed - Opened by mfuller333 over 3 years ago - 2 comments

#46 - Added Memory DMV to handle memory requests, and grants

Pull Request - State: closed - Opened by mfuller333 over 3 years ago

#45 - Error related with availability group

Issue - State: closed - Opened by MaxShoshin over 3 years ago - 14 comments
Labels: bug

#44 - Add server_name column to output

Issue - State: closed - Opened by jahveman over 3 years ago - 2 comments

#43 - Arithmetic overflow error converting expression to data type int

Issue - State: closed - Opened by imajaydwivedi over 3 years ago - 1 comment

#42 - Persisting blocked_session_count shows 0

Issue - State: closed - Opened by datadill over 3 years ago - 3 comments
Labels: bug

#41 - Add implicit transaction column to output

Issue - State: closed - Opened by erikdarlingdata over 3 years ago - 8 comments
Labels: enhancement

#40 - Add context_info to output

Issue - State: closed - Opened by kottivakkam over 3 years ago - 4 comments
Labels: enhancement

#38 - Arithmetic overflow error converting expression to data type money.

Issue - State: closed - Opened by viswaratha12 almost 4 years ago - 15 comments
Labels: bug

#37 - When I Use this Options : @get_task_info = 2 Getting failed.

Issue - State: closed - Opened by mdurajesh-rk almost 4 years ago - 2 comments

#36 - Created GitHub Markdown documentation

Pull Request - State: open - Opened by bakirp almost 4 years ago - 1 comment

#35 - Split out wait_info into XML fields

Issue - State: closed - Opened by jzabroski almost 4 years ago - 8 comments

#34 - DMA Shows like "Unqualified Join(s) detected"

Issue - State: closed - Opened by sandeshjonnala almost 4 years ago - 2 comments

#33 - Query plans getting dropped, potentially due to OPENQUERY

Issue - State: open - Opened by amachanic about 4 years ago

#32 - Enhacements related to sort order and CPU_Delta

Pull Request - State: closed - Opened by rrg92 about 4 years ago - 4 comments

#31 - Add support for memory grant information

Issue - State: closed - Opened by erikdarlingdata about 4 years ago

#29 - Better resource_description parsing for parallel waits

Issue - State: closed - Opened by erikdarlingdata about 4 years ago

#28 - Add support for CXCONSUMER wait detection

Issue - State: closed - Opened by erikdarlingdata about 4 years ago - 1 comment

#27 - Fix sort order case-sensitivity issue

Pull Request - State: closed - Opened by erikdarlingdata about 4 years ago
Labels: bug

#26 - @sort_order doesn't seem to work

Issue - State: closed - Opened by erikdarlingdata about 4 years ago - 2 comments

#25 - Successfully compile sp_whoisactive in Azure Synapse (azure sql data warehouse)

Issue - State: closed - Opened by gorkam23 about 4 years ago - 1 comment

#24 - Multiple error when executing sp_whoisactive on SQL Server 2019

Issue - State: closed - Opened by aallee1 over 4 years ago - 1 comment

#23 - Might trim query text sometimes

Issue - State: closed - Opened by artshade over 4 years ago - 5 comments

#22 - Strange values for Reads and CPU for fast requests

Issue - State: closed - Opened by rrg92 over 4 years ago - 3 comments
Labels: bug

#21 - Please offer original_login_name

Issue - State: closed - Opened by TheConstructor over 4 years ago - 4 comments
Labels: enhancement

#20 - fix typo, replace blocked_session_count with percent_complete

Pull Request - State: closed - Opened by amon09 over 4 years ago

#19 - "percent_complete" does not work when @format_output is 2

Issue - State: closed - Opened by amon09 over 4 years ago - 2 comments

#18 - Create dbo.sp_WhoIsActiveRunFor

Pull Request - State: closed - Opened by Platzer almost 5 years ago - 2 comments

#17 - Integrate the documentation as markdown files on GitHub

Issue - State: open - Opened by kapsiR almost 5 years ago - 2 comments
Labels: enhancement

#16 - Error while executing .sql file , Azure

Issue - State: closed - Opened by forecaster3434 about 5 years ago - 1 comment

#15 - Create .gitattributes file

Pull Request - State: closed - Opened by aharpervc about 5 years ago

#14 - Add Workload Group to Output

Issue - State: closed - Opened by jacobgexigo about 5 years ago - 7 comments
Labels: enhancement

#13 - sys.dm_exec_requests not supported in Azure Synapse

Issue - State: closed - Opened by lotsahelp about 5 years ago - 1 comment

#12 - SSMS 18.3.1 - Some numbers don't fit into the columns

Issue - State: closed - Opened by alex-bochkov about 5 years ago - 4 comments

#11 - Result is incorrect

Issue - State: closed - Opened by ibmsatya about 5 years ago - 3 comments

#10 - Incorrect syntax near 'r'.

Issue - State: closed - Opened by ghost about 5 years ago - 1 comment

#9 - sp_WhoIsActive | Error 6841

Issue - State: closed - Opened by bbworks about 5 years ago - 6 comments
Labels: bug, help wanted

#8 - [percent_complete] show value as NULL

Issue - State: open - Opened by jeffrey-yao about 5 years ago - 9 comments
Labels: bug

#7 - Warning on launch since "sqlops module" turned obsolete

Issue - State: closed - Opened by Eagle3386 about 5 years ago - 4 comments

#6 - Add badjes, description and change case for procedure name

Pull Request - State: closed - Opened by ktaranov about 5 years ago

#5 - Very useful resource!

Issue - State: closed - Opened by wdcadmin over 5 years ago - 1 comment

#4 - Rename file to dbo.sp_WhoIsActive.sql

Issue - State: closed - Opened by ktaranov over 5 years ago - 59 comments
Labels: work in progress

#3 - Replace old-school comma-joins with CROSS JOIN

Pull Request - State: closed - Opened by MisterZeus over 5 years ago

#2 - CPU_Delta > 3 000 000 ms, and tasks = 1

Issue - State: open - Opened by rrg92 over 5 years ago - 6 comments
Labels: bug