Upsizing Access97 to SQL7

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Sir,

I'll try to upsize our access97 database which is almost 800MB in size in SQL7 using upsizing wizard. My upsizing successfully done but I notice that my transaction comes slower in SQL7 compare to it's original source Access97. Lets say in Access97 transaction process only 30 secs in SQL7 it takes 60 Secs. Why? Hope you could help me to point the problem.

-- Anonymous, December 28, 1999

Answers

Aurora,

Slowness after upsizing can happen.

Make sure that all the indexes were created properly, and that SQL Server has plenty of memory. Then use SQL Server query optimization techniques such as using the Index Tuning Wizard.

Hope this helps,

Eric

-- Anonymous, January 03, 2000


Moderation questions? read the FAQ