Método EnumProcesses (Boolean)
Enumerates a list of processes running on the instance of SQL Server with the option to exclude system processes.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
Public Function EnumProcesses ( _
excludeSystemProcesses As Boolean _
) As DataTable
'Uso
Dim instance As Server
Dim excludeSystemProcesses As Boolean
Dim returnValue As DataTable
returnValue = instance.EnumProcesses(excludeSystemProcesses)
public DataTable EnumProcesses(
bool excludeSystemProcesses
)
public:
DataTable^ EnumProcesses(
bool excludeSystemProcesses
)
member EnumProcesses :
excludeSystemProcesses:bool -> DataTable
public function EnumProcesses(
excludeSystemProcesses : boolean
) : DataTable
Parâmetros
- excludeSystemProcesses
Tipo: System. . :: . .Boolean
A Boolean value that specifies whether to include system processes in the results.
If True, system processes are excluded.
If False, system processes are included.
Valor de retorno
Tipo: System.Data. . :: . .DataTable
A DataTable object value that contains a list of processes running on the instance of SQL Server. The table describes the different columns of the returned DataTable.
Column |
Data type |
Description |
Urn |
The URN string that represents the process. "Server[@Name='PCNAME']/Process[@Spid='51']", for example. |
|
Name |
The name of the process. |
|
Spid |
The SQL Server process ID that uniquely identifies the process, see sys.sysprocesses (Transact-SQL). |
|
Login |
The login running the process. |
|
Host |
The name of the computer on which the process is running. |
|
Status |
The status of the process. Running and sleeping, for example. |
|
Command |
The command currently being executed. |
|
Database |
The database is which the process is running. |
|
Cpu |
The cumulative time taken by the process in seconds. See sys.sysprocesses (Transact-SQL). |
|
MemUsage |
The number of pages in the procedure cache that are currently allocated to the process. A negative number indicates that the process is freeing up memory allocated by another process. |
|
BlockingSpid |
The SQL Server procedure ID of the procedure that is blocking the referenced procedure.. |
|
IsSystem |
The value that specifies whether the process is a system process or not. |
|
Program |
The name of the program the process |
|
ExecutionContextID |
The ID value that uniquely identifies the execution context under which the process is running. |
Exemplos
'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Call the EnumCollations method and return collation information to DataTable variable.
Dim d As DataTable
'Select the returned data into an array of DataRow.
d = srv.EnumCollations
'Iterate through the rows and display collation details for the instance of SQL Server.
Dim r As DataRow
Dim c As DataColumn
For Each r In d.Rows
Console.WriteLine("============================================")
For Each c In r.Table.Columns
Console.WriteLine(c.ColumnName + " = " + r(c).ToString)
Next
Next
Consulte também