[AccessD] Job Duration Puzzler - Access 2007 Report

Jim Dettman jimdettman at verizon.net
Mon Sep 16 16:28:51 CDT 2013


Brad,

  Your server scheduling may be set to give priority to background services
rather then foreground applications.  If so, anything in the running as a
service is going to preempt your Access Reporting, which will increase the
time it takes to run.

  There are also some memory related settings on the advanced tab that can
affect foreground processing and may have been changed either by a software
install or in conjunction with it.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Monday, September 16, 2013 03:15 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Job Duration Puzzler - Access 2007 Report

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    
   



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list