SQL Server Performance Impact of Procedure Calls without Owner Qualification -- SQL Server 2000

Linchi Shea : Performance Impact of Procedure Calls without Owner Qualification -- SQL Server 2000

The first thing to note is that on SQL Server 2005, the performance degradation caused by procedure calls without owner qualification was less than 5% with 100 or more concurrent users, whereas on SQL Server 2000 the performance degradation with exactly the same test workload was between 15% and 26% with 100 or more concurrent users.

Also interesting to note is the performance increase for SQL Server 2005:

With procedure calls owner qualified, SQL Server 2005 showed 15~18% improvement over SQL Server 2000 under heavy load. With procedure calls not owner qualified, SQL Server 2005 improved transaction throughput by a whopping 35~55% under heavy load.