Click here to monitor SSC
A service from Red Gate

in
Home SQL .NET SysAdmin Opinion Blogs Forums Books
Sign in | Join | Help
Home Blogs Forums
Blogs Home > James Moore > An interesting article about ASP.NET and SQL Server Performance

James Moore

Divisional Manager for SQL Tools - Red Gate Software

An interesting article about ASP.NET and SQL Server Performance

Published Tuesday, November 15, 2005 8:18 AM

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.

by James

Comments

No Comments
New Comments to this post are disabled
Latest articles
Checking Out SQL Backup Pro 7’s New Automatic Backup Verification
 Wouldn't it be great to offload the daily chore of checking the integrity of your production... Read more...

Chuck Lathrope: DBA of the Day
 Chuck Lathrope was a finalist for the Exceptional DBA of the Year award in 2009. We contacted him to... Read more...

Backups, What Are They Good For?
 Pixar recently confessed, in an engaging video, that Toy Story 2 was almost lost due to a bad backup,... Read more...

C# Async: What is it, and how does it work?
 The biggest new feature in C#5 is Async, and its associated Await (contextual) keyword. Anybody who is... Read more...

SQL Server 2012 AlwaysOn
 SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server 2012. It... Read more...