Gave it a shot. no luck. i wonder, if sqlservr.exe is corrupted or what. any different option i try, it gives the same path error.

DIR - CLS - DEL works from the Binn directory. anytime i run sqlservr.exe or sqlservr.exe -c -m or with any combo - none of them work. not even with...

I ran it from the current directory and it reports the same error. Dont know, why its behaving that. Is there any other way i could look into?

Thanks for the answer. I shall look into this.

Gail thanks a ton for for the answer. I looked at the pages in questions and found out to be database tables. i have sent the relevant info to the...

Gail,

Hate to be back with the same issue. Here's another dead lock info i see in my error logs and failed to figure out as to which process is dead...

Gail (Man of great knowledge) that was amazing. It certainly is very helpful and thanks a million for your great analysis. I am going to keep this analysis as a...

Hello Gail,

Sorry for posting the partial dead lock info. please the detail dead lock info here. (I have copied everything from the SQL Server - error logs and pasted here.)...

Thansk everyone for contributing to this thread.

I have enabled 1204 and 3605 parameter and now i see a deadlock event logged into my SQL Error logs:

But the hard thing is,...

Hello Gila,

Thanks for the answer. Unfortunately i have Profiler running against my SQL 2000 box and i dont see deadlocks info in there. Also i looked at my SQL DB...

Thank you Jeff. The provided link was very helpful.

Unfortunately running profiler against AS - 2000 is not supported. This has been supported starting 2005. but AS - 2000 is pain to manage.

I am sure, there must be some...

Have some update to share:

The query is our financial quarter end report which our finance folks runs. This problem has been around for a while and never got noticed. i...

Hello Ian,

Yes the sql query tool takes over 1 GB of ram (precisely it took 1.8 GB to complete) in addition to sqlservr.exe which takes 2.1 GB. The rows returned...

I have some updates to share with you folks. Here are couple of things i have done to make the query run faster - but tough luck. Here are the...