Home > Archive > MS SQL Server ODBC > May 2005 > System performance with ODBC Excel query









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author System performance with ODBC Excel query
Alex Gates

2005-05-11, 8:23 pm

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.
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com