July 16, 2013 at 4:39 am
Hi All,
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.
Harsha
July 16, 2013 at 6:06 am
Hi,
Sorry but we would need more information on what the stored procedure is doing. Does it accept parameters and if so, do they vary?
Regards,
Andrew
July 16, 2013 at 7:18 am
Hi Andrew,
Thank you for the response.
The procedure accepts parameters. It generates a big dynamic query for 11 teams and then inserts into the 11 tables.
Currently I have resolved this now.
I had changed the affinity mask. It was 0 as default. After changing, this worked without any problems.
Thanks,
Harsha
July 16, 2013 at 7:30 am
Glad it's sorted, what did you change the value to?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply