Q8.10: Poor man's sp_sysmon
This is needed for System 10 and Sybase 4.9.2 where there is no
sp_sysmon command available.
Fine tune the waitfor for your application. You may need
TS Role -- see Q3.1.
<![CDATA[
use master
go
dbcc traceon(3604)
dbcc monitor ("clear", "all", "on")
waitfor delay "00:01:00"
dbcc monitor ("sample", "all", "on")
dbcc monitor ("select", "all", "on")
dbcc traceon(8399)
select field_name, group_name, value from sysmonitors
dbcc traceoff(8399)
go
dbcc traceoff(3604)
go
]]>