VB and VBA Users Source Code: Obtaining process information for a Sybase Server

VB/VBA Source Code
Obtaining process information for a Sybase Server

By:	Andrew Baker
Email (spam proof):	Email the originator of this post
Date:	Monday, August 19, 2002
Hits:	634
Category:	Database/SQL/ADO

Article:
The following SQL will return process information for a Sybase SQL server: SELECT spid 'PID', fid 'FID', status 'Status', SUSER_NAME(suid) 'User', hostname 'Host', program_name 'Program', memusage 'Mem Usage', cpu 'CPU Time', physical_io 'I/O', blocked 'Blocked', DB_NAME(dbid) 'Database', cmd 'Command', tran_name 'Transaction', time_blocked 'Time Blocked', network_pktsz 'Packet Size' FROM master.dbo.sysprocesses ORDER by 3 go
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder