|
| This just starting happening this morning and we can't figure out why.
We have SQL 2000 and have two FE: a asp website and a Access XP FE (linked
tables via dsn-less connection.
This morning, if more than 5 people go into the driver form, any searches or
modification to the driver table times out. any tables linked to the driver
table isn't affected. Other tables aren't affected either.
We went ahead and rebooted the server. didn't help.
Now the table tblClient has the same issue. We see there is a notice to
recondition the battery. We'll do that later today and hope that fixes the
problem.
I noticed that one of our weekly maintenance jobs failed on Monday, the
purging of the db logs. However, we were working fine until today. I'll be
re-rerunning the maintenance jobs again tonight.
The last time I remember something like that happened was because we reached
the max for the primary key. however, the primary keys on these tables are
set to be int, and the IDs aren't even at 400000 yet.
Is there something else we can check?
|
|