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 |
|
jonest
Starting Member
2 Posts |
 Posted - 2011-03-04 : 18:08:09
|
| I just updated our 1.5 TB database from SQL 2000 standard edition to 2008 enterprise edition. Since the upgrade there have been multiple reports that used to run in minutes now take hours or do not finish. A couple of these use DISTINCT in the select statement. Has anyone had issues with DISTINCT after upgrading? Or other performance issues?Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jonest
Starting Member
2 Posts |
Posted - 2011-03-04 : 18:51:26
|
| We've changed the compatibility level to 100 for the master db but not our production db as there are some archaic stored procedures that are sure to fail & the report developers haven't had a chance to test them on our test db which is set to 100. We haven't updated statistics db wide because of the size of the db. The statistics for our most frequently used tables/indexes have been updated. One report was causing issues after the upgrade & it was determined that there wasn't an appropriate index on a table, once that index was created it went back to pre-upgrade behavior. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DISTINCT reports timing out after upgrade