ipalanisamy
Programmer
- Aug 28, 2008
- 2
Hi,
I'm new to Sybase and I have worked in MySQL earlier.
I would like to findout a command which is similar to MySQL's 'show processlist' and 'show full processlist' commands.
This command I use to debug a slow query problems.
The MySQL 'show processlist' output looks like below.
In this output you will see, the connection information's like connection id, the time, the state, the query, etc.
It would be great if someone points to a similar command in SyBase Adaptive SQL Server.
mysql> show processlist;
+-----+------+----------------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+----------------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 468 | root | localhost:1176 | webnmsdb | Sleep | 299 | | NULL |
| 469 | root | localhost:1177 | webnmsdb | Query | 3 | Opening tables | SELECT SQL_CALC_FOUND_ROWS merged_usr_960.id as usr_id,merged_flowSummary_961.deviceId as flowSumma |
| 470 | root | localhost:1178 | webnmsdb | Sleep | 299 | | NULL |
|
+-----+------+----------------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
mysql> show processlist;
+-----+------+----------------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+----------------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
|
| 469 | root | localhost:1177 | webnmsdb | Query | 24 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS merged_usr_960.id as usr_id,merged_flowSummary_961.deviceId as flowSumma |
|
| 478 | root | localhost:1186 | webnmsdb | Query | 15 | Locked | LOAD DATA INFILE 'C:/ConSentry/InSight/data/unprocessedData/Device4700075_flowSummary_2008_08_28_00_ |
| 479 | root | localhost:1187 | webnmsdb | Sleep | 320 | | NULL |
|
+-----+------+----------------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
I'm new to Sybase and I have worked in MySQL earlier.
I would like to findout a command which is similar to MySQL's 'show processlist' and 'show full processlist' commands.
This command I use to debug a slow query problems.
The MySQL 'show processlist' output looks like below.
In this output you will see, the connection information's like connection id, the time, the state, the query, etc.
It would be great if someone points to a similar command in SyBase Adaptive SQL Server.
mysql> show processlist;
+-----+------+----------------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+----------------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 468 | root | localhost:1176 | webnmsdb | Sleep | 299 | | NULL |
| 469 | root | localhost:1177 | webnmsdb | Query | 3 | Opening tables | SELECT SQL_CALC_FOUND_ROWS merged_usr_960.id as usr_id,merged_flowSummary_961.deviceId as flowSumma |
| 470 | root | localhost:1178 | webnmsdb | Sleep | 299 | | NULL |
|
+-----+------+----------------+----------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
mysql> show processlist;
+-----+------+----------------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+----------------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
|
| 469 | root | localhost:1177 | webnmsdb | Query | 24 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS merged_usr_960.id as usr_id,merged_flowSummary_961.deviceId as flowSumma |
|
| 478 | root | localhost:1186 | webnmsdb | Query | 15 | Locked | LOAD DATA INFILE 'C:/ConSentry/InSight/data/unprocessedData/Device4700075_flowSummary_2008_08_28_00_ |
| 479 | root | localhost:1187 | webnmsdb | Sleep | 320 | | NULL |
|
+-----+------+----------------+----------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+