solomon.jernas (6/24/2016)
Users are facing slowness issue after restored database from 2000 to 2008 sql server, they are gernerating report in crystalit takes 5 minutes in SQL 2000 physical server.
But after migrated to VM machine sql 2008 with 80 compatilablity , but report gerneration almost takes 3 hours.
Could you nyone help on this...
what is cause of slowness crystal report generation
BR,
Jerry
Did you force an update of statistics after the migration? Also, what are the initial size and growth settings for TempDB?
And why on this good green Earth would you stick with the SQL Server 80 compatibility?
--Jeff Moden
Change is inevitable... Change for the better is not.