Optimization level

drecksgekritzel
drecksgekritzel Member Posts: 37
edited 2008-04-18 in SQL General
Hello,
is it possible to see in a sql database the optimization level of the tables like in a C/Side database? :?:

Thanks for your help in advance!

Kind Regards
Alex

Comments

  • stryk
    stryk Member Posts: 645
    Hi Alex,

    yes, it is possible. The "optimization level" in native NAV represents actually the degree of fragmentation.
    This could be measured in SQL using the DBCC SHOWCONTIG command.
    Please check the "Books Online" for details!

    Regards,
    Jörg
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • Ola_Hallengren
    Ola_Hallengren Member Posts: 3
    In SQL Server 2005 you could also use the DMV sys.dm_db_index_physical_stats. DBCC SHOWCONTIG will be removed in future versions of SQL Server.

    Ola Hallengren
    http://ola.hallengren.com

Categories