Mark's Stuff

My Foray Into Weblogging. Using this to store interesting items for later review.

Monday, July 16, 2007

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.

Labels:

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home