Analytics Software

     most of our users are complaining about latency we've tested the latest version ending 800 and current version installed after they run a Refresh only on 4 to 8 rows rather than a whole sheet it's still takes a while but it's once the refresh has completed there's slowness when pressing shifting through cells and so on, going into Help and health check and setting to recommneded settings makes no difference.

I have run a fiddler capture, procmon capture and Wireshark if there's anything I need to look at, I'm currently shifting through your knowledge base and I've also applied the recommended settings with no joy

We've followed the performance recommendations set here https://docs.oracle.com/cd/E72988_01/ICSMV/ch06s11.html  and tried the latest 900 build too.

Note that I ran Process explorer and monitored CPU/RAM/IOPS and network activity and there was no increase in cpu or RAM or latency very after the refresh had completed and when excel started to lag when clicking on buttons, very strange?

There's no latency as far as I can tell when doing a tracert, does anyone have any suggestions as all of finance are complaining the add-in and it's functionality is causing Excel to slow down a lot

I've switched on diagnostics and it's displayed the following:

[2019-10-04T14:25:02-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iwejdgoImFw0zlfo05Jz3BDSE0zWYzH0005BW000000,0]
[2019-10-04T14:25:02-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iwejdgoImFw0zlfo05Jz3BDSE0zWYzH0005BW000000,0]    at SmartQuery.BasicModel.get_Queries()
   at SmartQuery.BasicModel.Initialize()
   at SmartQuery.CmdProcessor.ISVConnOfficeEvents2_Sink.ExcelWorkbookActivate(Object workbook)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

[2019-10-04T14:25:02-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iwejdgoImFw0zlfo05Jz3BDSE0zWYzH0005BW000000,0]
[2019-10-04T14:25:02-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iwejdgoImFw0zlfo05Jz3BDSE0zWYzH0005BW000000,0]    at SmartQuery.BasicModel.get_Queries()
   at SmartQuery.BasicModel.Initialize()
   at SmartQuery.CmdProcessor.ISVConnOfficeEvents2_Sink.ExcelWorksheetActivate(Object worksheet)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

[2019-10-04T14:31:11-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iwejdgoImFw0zlfo05Jz3BDSE0zWYzH0005BW000000,0]
[2019-10-04T14:31:11-00:00] [SVC] [NOTIFICATION:4] [SVC10000] [SVC] [ecid: 00iwejdgoImFw0zlfo05Jz3BDSE0zWYzH0005BW000000,0]    at SmartQuery.BasicModel.get_Queries()
   at SmartQuery.BasicModel.Initialize()
   at SmartQuery.CmdProcessor.ISVConnOfficeEvents2_Sink.ExcelWorkbookActivate(Object workbook)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

11.2.5.800 (build 205)

Office version