http://goo.gl/EmKxy0

Home > ASE, Start Sybase, Sybase ASE/REP Interview Questions, UNIX > How to avoid locking on system tables in tempdb

How to avoid locking on system tables in tempdb

1. tempdb database is shared among all databases in a server, so it is heavily used. It causes lock contention on sysobjects, syscolumns and sysindexes tables. To reduce the contention try to use “select…insert” instead of “select into””, because former is fully logged operation which slow down the process and provide a solution to locking problem.

2. Try to use data only locking scheme in place of allpages.

Check the Sybase Wiki @ sybasewiki.com
  1. No comments yet.
  1. No trackbacks yet.