Session

Get-DbaOpenTransaction

Chrissy LeMaire (@cl), netnerds.net

Get-DbaOpenTransaction View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves detailed information about open database transactions across SQL Server instances. Description Queries SQL Server dynamic management views to identify open transactions that may be causing blocking, consuming transaction log space, or impacting performance. Returns comprehensive details including session information, database context, transaction duration, log space usage, and the last executed query with its execution plan. This is particularly useful when troubleshooting blocking issues, investigating long-running transactions, or monitoring transaction log growth.

Get-DbaProcess

Chrissy LeMaire (@cl), netnerds.net

Get-DbaProcess View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Retrieves active SQL Server processes and sessions with detailed connection and activity information. Description Displays comprehensive information about SQL Server processes including session details, connection properties, timing data, and the last executed SQL statement. This function combines data from multiple system views to provide a complete picture of current database activity. Use this to monitor active connections, identify blocking processes, track application connections, troubleshoot performance issues, or audit database access patterns.