Cred ca gasesti raspunsul chiar in articolul respectiv:

"DMVs provide a level of transparency that was not available in SQL Server 2000 and can be used for diagnostics, memory and process tuning, and monitoring"  .

Fragmente poti gasi in:

http://www.2shared.com/file/2464287/72fdc52a/sqlserver.html

http://www.sqlskills.com/blogs/paul/2007/10/05/IndexesFromEveryAngleHowCanYouTellIfAnIndexIsBeingUsed.aspx 

http://www.mssqltips.com/tip.asp?tip=1359

http://www.mssqltips.com/tip.asp?tip=1196

http://www.mssqltips.com/tip.asp?tip=1014 

http://www.databasejournal.com/features/mssql/print.php/3608296 

http://www.sqlskills.com/blogs/paul/CategoryView,category,Indexes+From+Every+Angle.aspx

...

O  prezentarea exhaustiva a solutiilor de optimizare poti gasi chiar in BOL din SQL Server 2000.

Ca fapt divers, de la adresa aceasta se poate copia o schema care include vederile (views) sistem din SQL Server 2005.