bookmark - Changing Locking Scheme For Table Having 4 Cr Rows

Changing Locking Scheme For Table Having 4 Cr Rows

 
 Discussion by Amol with 0 Replies.
 Last Update: April 23, 2012, 8:20 am
 
bookmark - Changing Locking Scheme For Table Having 4 Cr Rows  
    
free web hosting
 
Hi Guys,

I am facing heavy amount of deadlocks in my environment.I am currently using Sybase Version 15.0.3 and locking scheme for the table is all page locking scheme.I thought changing the locking scheme will help in reducing the deadlocks.Please suggest if some other mechanism exists to avoid deadlocks.Also how we can change locking scheme for such high volume table.Whether we need to do bcp out and in for same and how much time it will take.

Also My ASE Servers are very busy and tables sizes are high (1Cr ++).They are running 24*7 and previously update statistics and reorg maintenance activities not run from last one year So I want to run it but time frame will always be night time.In morning heavy load will come and these activities should not be possible.Please suggest how can i go for these activities with specific time frame.

Mon Apr 23, 2012    Reply    New Discussion   


Quickly Post to Changing Locking Scheme For Table Having 4 Cr Rows w/o signup Share Info about Changing Locking Scheme For Table Having 4 Cr Rows using Facebook, Twitter etc. email your friend about Changing Locking Scheme For Table Having 4 Cr Rows Print
Reply / Comment Ask a Question? Share / Bookmark E-Mail a Friend Print

Finding The Location Of Data Stored In Small Setup Cloud Environment   Finding The Location Of Data Stored In Small Setup Cloud Environment (1) (3) Algorithms And Flowchars   Algorithms And Flowchars