Hi ,

I have a similar problem. I think the link that you have provided here is quiet useful. Can you please translate in English.

1000 and 1 thanks

Hi,

See your query execution plan for Hash joins, large sort operation, frequent recompile of sp.. etc. They may be the culprits

Hi Raj,

Thanks for the update.

Yes they did restore on existing db yesterday. EM was opened today.

I did a detach and attach and came back online.

cheers

Thank u Steve. I have only a single instance. I ran netstat -an to take a look at port usage. But could not figure out anything. Does it have any...

Hi Francis,

then I assume they are on seperate logical drives which are existing on the same physical array. In one of our production setup I saw this configuration. Just to...

Hi Ann,

thanks a ton

Thanks a lot Paul. I have already found the same solution. Works perfect. Thnaks for input

Thanks a ton Chris for the info...

Thanks a lot Brain. But I am running on Windows 2000 advanced server.

Any help?

Hi Josheph,

But I did not have trace running on that time. I need to send a report to client. Can I start trace before killing the suspected process

Thanks

Hi,

This error is from our ticketing systm. A software will probe the database and generate these tickets. This could be from error log, Even logs, etc..

Any help.

Hi,

Big thanks to both of you.

Hi rudy,

Thanks a lot for your help. It works for me now. One more question - How can I get the output of execution if I run this script? and...

Hi,

You can try that. It gives a definte boost.  However I prefer to use a batchjob. As always, try to minimize the amount of inserts, deletes and updates in one...

Hi,

Did u set SET NOCOUNT ON. Does this have any effect