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
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.