The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005 http://support.microsoft.com/kb/940945/en-US...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/kba/archive/2007/08/23/1687.aspx