Post reply

Lock created on UDF

  • April 12, 2005 at 4:36 am

    #85526

    We are running SQL Server 2000 and have purchased a program that allows us to use regular expressions in our SQL queries, enabling advanced string comparisons.  This program creates UDF's in the master database that calls Extended Stored Procedures.  Queries using these UDF's can take a long time to run (several minutes) and a lock is created during these queries on the Master database on these UDF's.

     

    Is there a way to prevent a lock from being placed?  We are running update queries and need to have several processes accessing these queries at the same time, which then blocks the later processes until the first ends.

     

    Thanks.

  • April 12, 2005 at 5:41 am

    #552099

    What kind of locks are we talking about here? If it is compile locks then you should check if the UDFs are being recompiled a lot and try to avoid that.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply