select @@version
go

use master
go

sp_sysmon "00:00:30"
go




Adaptive Server Enterprise/12.5.1/EBF 11560 ESD#1/P/Sun_svr4/OS 5.8/ase1251/1831/64-bit/FBO/Sat Nov 22 07:27:33 2003

1 Row(s) affected

This command did not return data, and it did not return any rows
Error: DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
(State:HY000, Native Code: 9E0)
Error: Run Date: Aug 29, 2005 (State:01000, Native Code: 0)
Error: Statistics Cleared at: Aug 29, 2005 17:52:26 (State:01000, Native Code: 0)
Error: Statistics Sampled at: Aug 29, 2005 17:52:56 (State:01000, Native Code: 0)
Error: Server Name: KIOMC1 (State:01000, Native Code: 0)
Error: Server Version: Adaptive Server Enterprise/12.5.1/EBF 11560 ESD#1/P/Sun_ (State:01000, Native Code: 0)
Error: (State:01000, Native Code: 0)
Error: =============================================================================== (State:01000, Native Code: 0)
Error: Sybase Adaptive Server Enterprise System Performance Report (State:01000, Native Code: 0)
Error: =============================================================================== (State:01000, Native Code: 0)
Error: Sample Interval: 00:00:30 (State:01000, Native Code: 0)
Error: (State:01000, Native Code: 0)

Sybase пачим время от времени.

Первый раз sp_sysmon попробовал. Появились deadlockи в базе. Пытаюсь выяснить в чём дело, а тут такой облом. Причём неприятно что включить T1204 (trace flag) тоже не могу:

dbcc traceon (1204)

Error: DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
(State:HY000, Native Code: 9E0)

Log:
08:00000:00544:2005/08/30 19:11:01.00 server DBCC TRACEON 8399, SPID 544


Printout:

This command did not return data, and it did not return any rows
Error: DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
(State:HY000, Native Code: 9E0)
Error: Run Date: Aug 30, 2005 (State:01000, Native Code: 0)
Error: Statistics Cleared at: Aug 30, 2005 19:10:30 (State:01000, Native Code: 0)
Error: Statistics Sampled at: Aug 30, 2005 19:11:01 (State:01000, Native Code: 0)
Error: Server Name: KIOMC1 (State:01000, Native Code: 0)
Error: Server Version: Adaptive Server Enterprise/12.5.1/EBF 11560 ESD#1/P/Sun_ (State:01000, Native Code: 0)
Error: (State:01000, Native Code: 0)
Error: =============================================================================== (State:01000, Native Code: 0)
Error: Sybase Adaptive Server Enterprise System Performance Report (State:01000, Native Code: 0)
Error: =============================================================================== (State:01000, Native Code: 0)
Error: Sample Interval: 00:00:30 (State:01000, Native Code: 0)
Error: (State:01000, Native Code: 0)