[AccessD] SQL Server "wakeup" mystery

Gary Kjos garykjos at gmail.com
Fri May 7 10:17:49 CDT 2010


Are the drives going into power down mode or something that would then
cause the lookup to not complete in teh timeout period?  Check power
saving parameters maybe?  Does it happen if someone were to do a disk
access like a folder list or something before the query that fails?

GK

On Fri, May 7, 2010 at 10:01 AM, jwcolby <jwcolby at colbyconsulting.com> wrote:
> 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
>



-- 
Gary Kjos
garykjos at gmail.com




More information about the AccessD mailing list