Performance Issue while updgrading from 6.5 to 2000

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

We have a 10GB Database in SQL Server 6.5 and test upgraded to SQL Server 2000.The performance of views have become very slow compared to that of SQL Server 6.5. What tunning is need to make the views at least work like 6.5

Thnaks in advance

-- Anonymous, March 19, 2002

Answers

Riyaz,

I would try running DBCC DBREINDEX on the tables in question, then running sp_updatestats (which updates statistics on all your database tables).

If that does not improve performance look into "indexed views". This is documented in SQL Server Books Online.

Hope this helps,

Eric

-- Anonymous, March 19, 2002


Moderation questions? read the FAQ