Slow reports performance NAV2009R2+LS Retail 6.4

kardo

there is a case where Navision 2009r2 with LS retail 6.4 is suddenly having a slow performance reporting issue! Reports based on TSE table (size=27GB). Its SQL DB (150GB) , simple recovery mode,where maintenance is frequently running along with update statistics. 32GB RAM Server, Raid 1+0 (6x300GB). Any suggestions?

ara3n

Use SQL Perform tool to monitor the long queries during the printing and create the necessary key(indexes).