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...
Is there a command in Sybase similar to MySql 'show processlist' | Thread profile
Thread profile page for "Is there a command in Sybase similar to MySql 'show processlist'" on http://www.tek-tips.com.
This report page is a snippet summary view from a single thread "Is there a command in Sybase similar to MySql 'show processlist'", located on the Message Board at http://www.tek-tips.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity, which are reported in a table below.
Additional thread profile information is also shown in the following ways:
1) Top Contributing Authors 2) Related Threads on "eBay Auctions" 3) Related Threads on Other Sites Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a thread's popularity and/or exact posting volumes at any given reporting period. |
||||||||||||||||
|
|
|||||||||||||||
Thread posts in Is there a command in Sybase similar to MySql 'show processlist':1.
Started 10 months, 1 week ago (2008-08-28 13:26:00)
by ipalanisamy
Size: 7,129 bytes
Customize: 
2.
Started 10 months, 1 week ago (2008-08-29 02:30:00)
by PDreyer
exec sp_who or select * from sysprocesses
Size: 123 bytes
Customize:
3.
Started 10 months, 1 week ago (2008-08-29 13:49:00)
by ipalanisamy
Both the commands that you have mentioned is deprecated with the version SQL Anywhere 10.0.1.388. Is there any other commands which has replaced these ones? Also I would like to know the format of the log file content. After I have enabled the log, I see the below output =,<,4,EXEC_ANY_IMM,DELETE TOP 1000 FROM EVENTS WHERE (TIMESTAMP < 20070811031622, 0.000000001) +937,<,2,CACHED_DROP_STMT,...
Size: 995 bytes
Customize:
4.
Started 10 months ago (2008-09-03 04:17:00)
by PDreyer
Your 1st post said Adaptive server and this is an ASE forum But now you say SQL Anywhere I can't find a SQL Anywhere forum on this site Maybe try posting to the sybase.public.sqlanywhere.general newsgroup at forums.sybase.com htt p://forums .sybase.co m/cgi-bin/ webnews.cg i?cmd=list items& sort_on=no ne&sec ond_sort=d ate&so rt_method= date&s ort_revers e=true& ;group=syb ase.public ....
Size: 857 bytes
Customize:
|
Top contributing authors for Is there a command in Sybase similar to MySql 'show processlist'Related threads on "Tek-Tips Forums":Related threads on other sites: |
|||||||||||||||
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.