Brad Marks
BradM at blackforestltd.com
Mon Sep 16 14:14:46 CDT 2013
All, We have a high level Access 2007 Report that is generated every night. The data for this report is pulled from a number of SQL-Server database tables. This report is automatically generated nightly on a server with these specs - MS Window Server 2003 R2 Enterprise Edition SP2 2.50 Ghz 12 GB Ram About a month ago, I noticed that the "run time" for generating this report went from 8 minutes to 20 minutes. Everything works fine, except that the run time has more than doubled. I can also run this same report on a stand-alone PC with these specs - Windows XP SP3 2.50 Ghz 3.25 GB Ram When the same report is generated on this PC, the job runs for about 8 minutes. Over the weekend, when nothing else was running, I conducted a number of tests to confirm what I was seeing. The results were consistent. The generation of this report takes more than twice as long on the Server as compared to the PC. I am very puzzled and not sure where to look. I don't know why the run times went up dramatically on the Server. I don't understand why the run times vary between the two boxes. Any insights or advice would be most appreciated. Thanks, Brad