T
tc1845
I hope I'm just overlooking the obvious and there is an easy solution for my
issue. I scanned the messages here and didn't see anything that looked
similar.
My issues is I have a SQL database with a table containing a little over 2.5
million rows linked to access. We typically open the linked table and filter
for a subset of records to modify in table view. The database was recently
moved to a new faster server with more memory and a bigger hard drive. After
the initial move performance when opening and using the table seemed more
robust than on the older slower machine. The performance has degraded over
about a month and a half to the point where the table cant be opened remotely
from the server. On the server connected via remote desktop the table takes
about 5 minutes to open and filter. when data was first migrated this
operation took about 5 seconds. Additionally when navigating records to
update in table view there is about a 40 second lag on updating the first
record but after that I can move from record to record making changes.
There are no errors in the logs and I just don't know where to turn next. My
guess is that some patch has caused me this issue since it appears to be
consistent from all workstations tested. I tried moving back to the old
server which appears to now be plagued by the same issue. the old serer
hasn't been touched since moving to the new one, but has had critical patches
installed.
I hope the above symptoms are enough to suggest where to look to resolve this.
issue. I scanned the messages here and didn't see anything that looked
similar.
My issues is I have a SQL database with a table containing a little over 2.5
million rows linked to access. We typically open the linked table and filter
for a subset of records to modify in table view. The database was recently
moved to a new faster server with more memory and a bigger hard drive. After
the initial move performance when opening and using the table seemed more
robust than on the older slower machine. The performance has degraded over
about a month and a half to the point where the table cant be opened remotely
from the server. On the server connected via remote desktop the table takes
about 5 minutes to open and filter. when data was first migrated this
operation took about 5 seconds. Additionally when navigating records to
update in table view there is about a 40 second lag on updating the first
record but after that I can move from record to record making changes.
There are no errors in the logs and I just don't know where to turn next. My
guess is that some patch has caused me this issue since it appears to be
consistent from all workstations tested. I tried moving back to the old
server which appears to now be plagued by the same issue. the old serer
hasn't been touched since moving to the new one, but has had critical patches
installed.
I hope the above symptoms are enough to suggest where to look to resolve this.