An interesting article about ASP.NET and SQL Server Performance

Comments 0

Share to social media

While reading through the excellent http://blogs.msdn.com/ I noticed this post by Todd Carter talking abount ASP.NET and SQL Server Performance, in it he talks about compiler locks slowing down stored proceedure execution. Aparently this occurs when

  1. The user that runs the stored procedure is not the owner of the procedure AND
  2. The stored procedure name is not fully qualified with the object owner’s name.

You can read the full article here.

Load comments

About the author

James Moore

See Profile

James Moore runs the SQL Tools division at Red Gate Software.

James Moore's contributions