We created pivot table in Excel that uses an SQL statement and data source to
pull data in from our SQL database. It had been working fine but over the
past couple of weeks I noticed that every once in a while when refreshing the
data, what would normally complete in under 30 seconds would take up to 30
minutes. Recently the system performance was taking a hit while refreshing
the data in the Excel sheet so we monitored and as soon as the Excel query
ended the CPU went from 100% to under 10% and response times went back to
normal. The query only accesses one table which is only used by one other
process which populates it. I wouldn’t expect any contention since they both
run at separate times. Any feedback is appreciated. Thank you.