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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-09-10 : 20:07:50
|
| Hi folks,We recently upgraded the server from sql 2000 to 20005.Previously one query is used to take 15-20 min, but after upgrading the same query is taking more than 4 hours.IN the upgraded version we have sp 1 , does it effects the performace of the query.Any suggestions are greatly appreciated.Thanks,Thaniparthi |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-09-11 : 07:23:05
|
| Actually the query is extracting the data from views.Any ideas. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-11 : 08:34:20
|
Views do not normally hold data.They are just "pointers" to underlying tables, which has indexes and statistics.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-11 : 12:23:32
|
quote:
Originally posted by thaniparthi.rao
Actually the query is extracting the data from views.Any ideas.
You didn't answer my question.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-09-11 : 18:05:11
|
| I was not involved in the upgrading process.Where exactly we have to check whether the indexes were upgraded or not. |
|
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-09-11 : 18:07:26
|
| Where exactly i have to check whether the indexes where rebuilded or not.Does it has any impact on the query performance. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-11 : 18:08:50
|
| Ask the DBA if the indexes were rebuilt after the upgrade. If they weren't, ask if statistics were updated. If they weren't, I'd question his skills.The DBA should also check fragmentation of the indexes.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
query