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.
asked Aug 11, 2017 at 09:13 AM in Default
Have you checked the power options?
answered Aug 11, 2017 at 09:20 AM
Kev Riley ♦♦