We are facing very weird issue. Staging and Prod have same no of records in the Broker and DBs are hosted on same physical machine and SQL server. Stage and Prod are on different CD servers.
Broker is queried using Broker APIs(CD), its working fine on all other environment including staging (which is having almost similar hardware and software) but on Production its performance is very slow. its taking 5-6 min to get results which on other environments takes seconds. it loads records between 20 - 150.
Has anybody faced this kind of issue and has some tips to resolve it?