Archive for June, 2011

Sybase Replication Experts

June 29th, 2011 No comments


Created a new group “Sybase Replication Experts” in Linkedin as

Any Novice/Proficient/Expert Replication DBA, ASE DBA, IQ Admin can join this group to share their thoughts, issues, findings with Sybase Replication Server in Homogeneous and Hetrogeneous Environment.

Categories: ASE Tags:

Need to understand concepts about locking and blocking.

June 7th, 2011 1 comment

Hi sybanva,
Could you please provide some insight on the locking and blocking i.e.
1. How to figure out the SQL text of spid which comes as an output of “sp_who”
2. How to check which table is locked and by which sp id
3. Suppose my procedure takes 2 min. everyday and suddenly one day it took 2 hrs. to complete. So what could have been occoured, how to check whether table used by procedure were locked or not, if yes then which spid was responsible for table locking and etc etc.

Many Thanks

Categories: ASE Tags: