BDL Performance on SQL Server

Hi all,

We've been trying to tune a few 4GL applications so they can run
effectively against a SQL Server database.  Certain programs seem to
cause problems where they are generating thousands of extent locks on
the tempdb database.  When the locks get high enough, the whole system
seems to grind to a halt.  

I've been looking at areas in the code where temp tables are used but
have not had success pinpointing the issue.  There are a few places
where temp tables are being used in cursors so maybe this is related??
Would indexes on my temp tables help decrease these extent locks?

Any ideas would be very appreciated.

Thanks,


Richard