Slowness while executing SQL Query using MIi 15.1 Query Template

[former_member186805]

Dear Experts, We are doing xMII upgrade from 11.5 to MII 15.1. We are using SQL server 2014 database. We are experiencing slowness issue while executing SQL query using MII Query template. It takes approximately 7 seconds. While when we run the same query in SQL server directly it executes in 1-2 seconds. Please help urgently. Regards Ayush

[swaroop_anasane]

Hi Ayush,

Can you check if query caching is on or off?

Regards,

Swaroop

[former_member186805]

Dear Swaroop, Thanks for your reply. But i got this fixed after applying SQL tuning and indexing. Now Query takes less than one second to execute successfully. Regards, Ayush

[swaroop_anasane]

Cool