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...

Can you see the SPID related to these transactions? You should be able to see what the update statment was, even if all you do is a DBCC INPUTBUFFER(spid_no).

Also what...

I recommend you do some basic SQL courses. Some one may have time to answer these sorts of questions, but if you read the SQL BOL (books on line) or...

I would check the build was done correctly, particularly that all the databases are on shared resources.

Leo

There are 10 types of people in the world.

Those who understand binary and and...