Functions/Invoke-Sdtsp_WhoIsActive.ps1
|
Function Invoke-Sdtsp_WhoIsActive { Param ( [Alias('ServerName','MachineName')] [String[]]$ComputerName = $env:COMPUTERNAME ) BEGIN { $sessions = @(); } PROCESS { if ($_ -ne $null) { $ComputerName = $_; Write-Verbose "Parameters received from PipeLine."; } foreach ($Computer in $ComputerName) { #cd $PSScriptRoot; Write-Verbose "Running sp_WhoIsActive against $Computer.. Please wait.."; $sessions = Invoke-Sqlcmd -ServerInstance $Computer -Database tempdb -Query 'EXEC dbo.sp_WhoIsActive @get_plans=1, @get_full_inner_text=1, @get_transaction_info=1, @get_task_info=2, @get_locks=1, @get_avg_time=1, @get_additional_info=1,@find_block_leaders=1' } } END { Write-Output $sessions; } } |