You are here: System database > mprocesses
   |
   |
|
mprocesses
|
|
|
|
One process per instance per CPU. Within each process there are several worker threads. Note that these processes are all internal to Scimore. The Windows Task Manager will show one process per server instance on each machine.
Table Columns
|
Name |
Type |
Description |
|
instance_id |
INTEGER |
Server instance id that this process is part of. References sysinstances (id) |
|
id |
INTEGER |
Unique process id internal to the server instance |
|
busy |
INTEGER |
Number of worker threads currently executing transactions |
|
total |
INTEGER |
Total number of worker threads allocated in this process |
|
queue |
INTEGER |
Number of SQL requests awaiting a worker thread to service them. |
|
switch_per_sec |
INTEGER |
Number of internal context switches between worker threads per second per process |
|
connections |
INTEGER |
Number of active connections in current process. Each connection is serviced by one process, assigned on connection. |
Related