New answers tagged database-performance
a. Have you check wait state of the running query ? Select * from sys.sysprocesses will do b. is there any resource governor in place ? c. have you use recompile hint to test it ? d. have you check the query plan ? e. have you tried to force the plan to run in paralel mode using dbcc cpuweight ? f. have you update the statistics of the tables?
Top 50 recent answers are included