true
Data Source=localhost;Initial Catalog=master
SQL
a1a81891-6701-47df-9b33-1b1e0584546c
1in
1in
true
8.5in
true
0.125in
0.125in
textbox22
1
21.875in
true
0.5in
This report displays all processes connected to the server at the time of the report (auto-refresh interval every 90 seconds).
Connection aborted. Please try again.
0.125in
WHO
0.625in
22in
unique_compiles
16
true
=Fields!PID.Value
user_seeks
15
true
=Fields!Status.Value
user_scans
14
true
=Fields!User.Value
avg_total_user_cost
13
true
=Fields!Host.Value
textbox28
12
true
=Fields!Program.Value
textbox5
11
true
=Fields!Mem_Usage.Value
textbox8
10
true
=Fields!CPU_Time.Value
textbox15
9
true
=Fields!I_O.Value
textbox18
8
true
=Fields!Blocked.Value
textbox25
7
true
=Fields!Database.Value
textbox27
6
true
=Fields!Command.Value
textbox30
5
true
=Fields!Last_Batch.Value
textbox32
4
true
=Fields!Login_Time.Value
textbox34
3
true
=Fields!NT_Domain.Value
textbox36
2
true
=Fields!NT_User.Value
textbox38
1
true
=Fields!Net_Address.Value
textbox40
true
=Fields!Net_Library.Value
0.2in
33
true
=Fields!PID.Value
PID
32
true
=Fields!Status.Value
Status
31
true
=Fields!User.Value
User
30
true
=Fields!Host.Value
Host
29
true
=Fields!Program.Value
Program
28
true
=Fields!Mem_Usage.Value
Mem Usage
27
true
=Fields!CPU_Time.Value
CPU Time
26
true
=Fields!I_O.Value
I/O
25
true
=Fields!Blocked.Value
Blocked
24
true
=Fields!Database.Value
Database
23
true
=Fields!Command.Value
Command
22
true
=Fields!Last_Batch.Value
Last Batch
21
true
=Fields!Login_Time.Value
Login Time
20
true
=Fields!NT_Domain.Value
NT Domain
19
true
=Fields!NT_User.Value
NT User
18
true
=Fields!Net_Address.Value
Net Address
17
true
=Fields!Net_Library.Value
Net Library
0.2in
true
0.75in
0.75in
1.875in
1.75in
2.75in
1.125in
1in
0.875in
0.875in
1.625in
1.25in
1.375in
1.375in
1.125in
1.25in
1.125in
1.125in
0.4in
2in
0.125in
textbox14
1
4in
true
WHO
5.5in
3in
true
0.25in
="Report Time: " & Globals!ExecutionTime
0.375in
true
true
78f4fac4-5468-432c-adf6-5d8342f55ce4
1in
true
SELECT
spid 'PID', rtrim(status) 'Status',
SUSER_SNAME(sid) 'User',
rtrim(hostname) 'Host',
rtrim(program_name) 'Program',
memusage 'Mem_Usage',
cpu 'CPU_Time',
physical_io 'I_O',
blocked 'Blocked',
'Database'= CASE WHEN dbid=0 THEN '[NULL]' ELSE DB_NAME(dbid) END,
cmd 'Command', last_batch 'Last_Batch', login_time 'Login_Time',
rtrim(nt_domain) 'NT_Domain', rtrim(nt_username) 'NT_User',
net_address 'Net_Address',
net_library 'Net_Library'
FROM master.dbo.sysprocesses (nolock)
ORDER BY 2
DataSource1
System.Int16
PID
System.String
Status
System.String
User
System.String
Host
System.String
Program
System.Int32
Mem_Usage
System.Int32
CPU_Time
System.Int64
I_O
System.Int16
Blocked
System.String
Database
System.String
Command
System.DateTime
Last_Batch
System.DateTime
Login_Time
System.String
NT_Domain
System.String
NT_User
System.String
Net_Address
System.String
Net_Library
Tommy Bollhofer
25.25in
90
0in
This report displays all processes connected to the server at the time of the report.
en-US
1in
true
true
1in