Same Query, Different Servers, Different Performance. Now What?
I have 2 cluster servers with 2 nodes; having Single SQL instance installed with below configuration. Production 2.6 GHZ Processor 64 GB RAM 4 CPU SQL MAX Memory 52 GB MAXDOP 1 Pre-Production 2.6 GHZ Processor 64 GB RAM 2 CPU SQL MAX Memory 52 GB MAXDOP 1 I have 1 query which is executing within 30 Sec on pre-production but taking more than 150 Sec in production. Pre-prod DB is restored from production server, having updated stats & indexes. Tested performance of query out of office hours, but giving same result. Execution plans looks similar on both servers. All SP_CONFIGURE parameters also same. Only thing is on Pre-prod hyperthreding is set to 2; while on prod is 1. Meansboth have same logical processors i.e. 4 Can you help me how to find out root cause of slow performance on Production server.