asked
Query hangs
Hi ! A query which runs fine in dev environment is hanging in QA. The query hangs on the part where it inserts into a temp table so made sure that there is enough space on it I checked that indexes are the same in both the environments. It is reading out 4 million rows .When I check using the query sys.dm_exec_sessions it shows as running. Appreciate any suggestions to troubleshoot the issue Thanks a lot
Are you able to provide the query and the execution plan. A few other questions - What is the specification of the server (including the disk config) - Does it run slow after the first time you have executed it? - Have you checked index frag and that stats are up to date?
18 People are following this question.
