I have strange problem with my live cluster environment.
I have a dev environment in which a procedure completes in approx 4mins.
In my live environment, the same procedure if executed it runs for
1st time = 18 sec
2nd time = 18-20 sec
3rd time it hangs the servers. At this point, I cannot open new window from management studio. I cannot run any query in any other window in that server.
This keeps on for several hours or more than 1 day and then server crashes.
We have disabled the hypthreading and have made the default max worker threads.
My SQL Version:-0
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64) Jun 17 2011 00:54:03 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1
<X64> (Build 7601: Service Pack 1)
Thanks in advance.