Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-05-09 : 02:49:49
|
Hi guys,We had a fairly static system running against a SQL 7. A system upgrade to SQl 2000, and the performance has entered the basement ! 10 minute queries now not finising in 2 hours.I'm posting on behalf of the access guy - if canyone has any hints , I filter thro to him...TIA*#* *#* *#* *#* Chaos, Disorder and Panic ... my work is done here! |
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-09 : 16:44:54
|
Did you do a Pef Mon on it when he runs the query to see if it's SQL Server (doubt it) or Access.Anyone taking bets?Also, why is a 10 minute query in access acceptable? I would think only as a "Batch" kind of thing.And if that's the case, then why not do the administrative tasks in SQL to begin with.AND if it is for OLTP, then you must have some VERY patient users.Brett8-) |
 |
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-05-09 : 16:46:18
|
Try re-linking the tables in Access. There's an add-in that will do this automatically for you called "Linked Table Manager" or something like that (tools-->add-ins).Also, make sure your client has the latest version of MDAC installed.- Jeff |
 |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2003-05-12 : 06:54:05
|
I'll check the re-linking.These are OLAP-ish queries, hence the duration. The 10 minutes + component are indeed batch sections, but there are other's that were ... let's say sub-minute, that are now wounded ducks ...It's a sad state of seomone pushing the "little ms access DB that could!" .. we don't want it, but it was rolled out to +-200 users (out of 1000) via "backdoor", and now we're stuck with it.Sadly we are constrained to MDAC 2.6 due to pacakge constraint using same hardware... Thanx guys*#* *#* *#* *#* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
|