Are these AMD chips by any chance?

I know there is some technology that messes with the way SQL 2005 tracks time. This is typically AMDs Quite 'n Cool technology. I've...

After starting the select or delete have you done an sp_who2 from another MS conection to see if there is any blocking?

This is the most likely cause.

Leo

zeeaay (7/1/2010)

---

Dear folks,

Thank you very much for replying so quickly to help me out. Reply to your assumptions. I am not doing anything. If you read my message carefully I...

mitra.zaimi (7/1/2010)

---

would you send me a link to show how to script against master database ( in sql 2000 ) to collect data and then restore it to sql 2005...

Try adding a carriage return at the end of the last line if there isn't one there already.

Leo

Yes, off the peg applications...

From the timeout error it looks like the problem is load on the database server. It may be worth running some Performance counters. like CPU usage to see if your...

Are you seeing any error messages when your connections fail or when trying to connect and it fails? Either in SSMS or the SQL error logs?

Do you see different behaviour...

Users writing their own queries.

New application added, typically data warehouse and Analysis Services

Leo

Quite possibly a permission error. Have you set the trace to capture errors?

Leo

In simple terms, you can run a 32 Bit application on a 64 Bit operating system (with exceptions), but you can't run a 64 Bit application on a 32 Bit...

I much prefer setting the plan to write to a log file and use that than the plan history.

Different courses for differeent horses.

Leo

Have you looked in the SQL Server error log?

Maint plans are notorious for not logging things nicely unless you actual add logging to the plan. Something I would always do....

You can do a query against master..sysprocesses and look at the blocked value. This will also tell you the SPID doing the blocking.

I have a script but I'll need...

In blocking, one process is holding s resource that another process requires. SQL knows that once the blocking process finishes the resource will be available and so the blocked process...