Sounds like it could be parameter sniffing.

http://sqlinthewild.co.za/index.php/2007/11/27/parameter-sniffing/

http://sqlinthewild.co.za/index.php/2008/02/25/parameter-sniffing-pt-2/

http://sqlinthewild.co.za/index.php/2008/05/22/parameter-sniffing-pt-3/

If you post the query, we could point out potential problems with it, give you an idea what to look for, and why...

See the post in the SQL 2000 forum:

http://www.sqlservercentral.com/Forums/Topic560970-5-1.aspx

Check the windows event log. There should be a record in the application log of SQL shutting down. There sshould also be the login name that requested the shutdown included...

This piece is wrong

IF @vFieldsDataType='VARCHAR' OR @vFieldsDataType='TEXT'

...

Does sql_login have rights on the blacklist table?

What you can do to debug is something like this (untested):

CREATE TRIGGER connection_limit_trigger

ON ALL SERVER WITH EXECUTE AS 'sql_login'

FOR LOGON

AS

BEGIN

BEGIN TRY

IF ORIGINAL_LOGIN()= 'sql_login'...

Have you done a full stats update on all tables after the 2005 upgrade? If not, that could result in non-optimal query plans.

Run profiler for a while and capture the...

Could you post this as a bug on Connect please?

http://connect.microsoft.com

Clustered SQL installation?

That's probably what happened. The owner of the site said that page hasn't been changed in years.

Master contains all the information on the logins on the SQL server, as well as the database references, the linked servers, server-level triggers and server settings.

Model is used to...

Tell then to stop talking...

Depends on what permissions have been granted to the public role. If no permissions have been granted to it, then users with just public will have no rights to do...

It's teling you that there are slow IOs occuring. The typical range for a single IO operation should be 10-50 ms at the most. The warning is saying that in...

Maybe these two blog posts will help?

http://www.sqlskills.com/blogs/paul/2007/10/25/DebunkingACoupleOfMythsAroundFullDatabaseBackups.aspx

http://www.sqlskills.com/blogs/paul/2008/01/31/MoreOnHowMuchTransactionLogAFullBackupIncludes.aspx

DBCC DBREINDEX will do a stats update with full scan as it rebuilds the index.

DBCC INDEXDEFRAG will not update the statistics at all.

I would suggest that you do different stats...