Источник:
http://blogs.msdn.com/b/axsupport/ar...ts-page-7.aspx
==============
This is page
7 of 8 of the general performance analysis scripts online for the
Performance Analyser 1.20 tool. See
page 1 for the introduction. Use the links in the table below to navigate between pages.
- General analysisAnalyse SQL Configuration
Page 1Analyse SQL Indexes
Page 2Analyse SQL Queries
Page 3Analyse Blocking
Page 4Baseline - benchmark queries
Page 5- AX SpecificAnalyse AX Configuration
Page 6Analyse AX Indexes
Page 7Analyse AX Queries
Page 8Analyse AX Indexes
INDEXES_IN_DB_NOT_IN_AOT
INDEXES_WITH_RECVERSION
--
-- INDEXES_IN_DB_NOT_IN_AOT
--
-- --------------------------------------------------------------
-- Find INDEXES that are not defined in the AOT
--
-----------------------------------------------------------------
SELECT *
FROM INDEX_STATS_CURR_VW I
WHERE INDEX_DESCRIPTION 'HEAP' AND INDEX_DESCRIPTION NOT LIKE '%FILTERED%'
AND NOT EXISTS (SELECT *
FROM AX_INDEX_DETAIL_CURR_VW A
WHERE A.DATABASE_NAME = I.DATABASE_NAME
AND A.TABLE_NAME = I.TABLE_NAME
AND A.INDEX_NAME = I.INDEX_NAME)
ORDER BY TABLE_NAME,
INDEX_NAME
--
-- INDEXES_WITH_RECVERSION
--
-- --------------------------------------------------------------
-- Find INDEXES that have RECVERSION in the Key or Included list
-- RECVERSION should NOT be apart of AX Indexes do to the
-- frequency of updates
-----------------------------------------------------------------
SELECT *
FROM INDEX_STATS_CURR_VW I
WHERE INDEX_KEYS LIKE '%RECVERSION%'
OR INCLUDED_COLUMNS LIKE '%RECVERSION%'
ORDER BY TABLE_NAME,
INDEX_NAME
.
Источник:
http://blogs.msdn.com/b/axsupport/ar...ts-page-7.aspx