Access Freezes After Using Performance Analyzer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed Ardzinski - 11 Aug 2005 18:26 GMT

Not sure this is the best NG to post this in, but none of the others seemed
any more appropriate...

I just had 2 instances of a freeze up after using the performance analyzer
to suggest some indexes...it was an odd freeze up: Could still get to Access
via clicking on the task bar icon, but Alt-Tab did not recognized that Access
was there. And Access was absolutely unresponsive to anything.

The Task Manager said "running" but instantly returned the "not responding"
dialog as soon as I indicated to end task.

Anyone ever see this? TIA

btw, A2K3, Win XP (not on SP2)

Reply to this Message

SteveS - 26 Aug 2005 03:01 GMT

> Not sure this is the best NG to post this in, but none of the others seemed
> any more appropriate...
[quoted text clipped - 10 lines]
>
> btw, A2K3, Win XP (not on SP2)

I don't think that Access froze... the performance analyzer sometimes takes
what seems like a long time (sometimes 10 minutes seems forever!!!).

When you hit "End Process" and the "not responding" dialog box appears, it
indicates that Access didn't respond to the request to stop. This will/can
happen with *any* program.

Try arranging the desktop so you can see the Performance tab of the Task
Manager and Access, then start the performance analyzer. Watch the CPU usage
graph to see if the processor load goes to 100% and stays there. If so,
Access is working as hard as it can - go have a cuppa and a stretch.

Depending on the complexity of the database, CPU speed, amount of RAM, hard
drive space, time of day, what season, what direction your computer faces,
how you hold your tongue <g>, etc, it could take from one minute to over 30
minutes - sometimes hours even...... Remember: spend time now to save time
later.

HTH

Signature

Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)

Reply to this Message