sybase报Error: 1204

系统出现Error: 1204, Severity: 17, State: 2的错误，访问的应用被中断

1> sp_monitorconfig "number of locks"
2> go
Usage information at date and time: Jan 24 2008  9:03AM.
 
 Name                      Num_free    Num_active  Pct_act Max_Used  
         Num_Reuse  
 ------------------------- ----------- ----------- ------- -----------
         -----------
 number of locks                 99543         457   0.46       100378

                   0
(return status = 0)

 

 

1> sp_monitorconfig "number of user connections"
2> go
Usage information at date and time: Jan 24 2008  9:03AM.
 
 Name                      Num_free    Num_active  Pct_act Max_Used  
         Num_Reuse  
 ------------------------- ----------- ----------- ------- -----------
         -----------
 number of user connection         292           8   2.67           40
                   0
(return status = 0)

 

再通过检查sp_configure "number"

发现number of locks超出了系统设置范围，加大这个参数系统恢复正常。