[AccessD] SQL Server "wakeup" mystery

...I'd be looking for an MS security update problem or a service that's not 
starting automatically ...sounds like the system is thrashing about at 
startup looking for something that's not responding as expected but 
eventually finds it  ...if you can duplicate the problem locally, I'd try 
backing it up and then backing out each patch and see if the problem fixes 
itself.

...else it could be a huge log file that is taking forever to load ...but 
once it gets loaded its good until next time.

William

--------------------------------------------------
From: "jwcolby" <jwcolby at colbyconsulting.com>
Sent: Friday, May 07, 2010 11:01 AM
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Subject: [AccessD] SQL Server "wakeup" mystery

> Guys,
>
> I got the following in an email from a customer.  Does anyone have any 
> ideas?
>
> >John - For the past 3 months (or so) there seems to be a problem 
> >regarding the access to the check
> info that resides on the SQLSERVER on PSSERVER.
>
> >The pattern we seem to be seeing is that the first time someone tries to 
> >access the check info in
> DISCO the check screen fields display "?????" . When They get out and go 
> back into it again the
> check info is present.  Then for the balance of the day all is fine.
>
> >John says he has a similar problem when running reports from PSSERVER. 
> >He initiates the report,
> it hangs, he kills it, then reruns and then it is OK.
>
> >It just appears like there is a "wakeup" issue going on when anyone 
> >initially access the SQLSRVR
> on PSSERVER.
>
>
> -- 
> John W. Colby
> www.ColbyConsulting.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>