Get-SqlProcess

Returns the current proccesses on a SQL Server. Equivalent to sp_who.

Syntax

Get-SqlProcess [-sqlserver] <Object> [[-spid] <Int32>] [[-name] <String>] [[-excludeSystemProcesses]] [<CommonParameters>]

Detailed Description

The Get-SqlProcess function returns the current proccesses on a SQL Server. Equivalent to sp_who.

Related Commands

* Get-SqlProcess

Parameters

Name Description Required? Pipeline Input Default Value
sqlserver    true  false   
spid    false  false   
name    false  false   
excludeSystemProcesses    false  false   

Input Type

None You cannot pipe objects to Get-SqlProcess

Return Values

System.Data.DataRow Get-SqlProcess returns an array of System.Data.DataRow.

Examples

EXAMPLE 1

Get-SqlProcess "Z002\sql2k8"
This command returns the current processes on the Z002\sql2k8 server.