16.07.2009, 06:58 | #1 |
Участник
|
Attached at the end of this post is a set of NAV objects that collects index usage information, and displays it in a NAV client so that you can sort tables by no. of Indexes / Index Reads / (Index) Block wait time, etc.:
The tool is using these three SQL Queries / DMVs:
So the new thing is that now the information is read into NAV, making it more easy to browse through it, get an overview, and having information from various queries collected in one place. Note:
The tool contains the following objects: TypeIDNameTable74100IUIT SetupTable74101IUIT IndexTable74102IUIT TableForm74100IUIT SetupForm74101IUIT Index ListForm74102IUIT Table ListCodeunit74100IUIT MgtAnd it assumes that you have a partner’s developers license. To run it: Run form 74102 “IUIT Table List”. First set up the SQL connection by clicking Table -> Setup, and specify SQL Server Name, Database Name and credentials. Then go back to the “IUIT Table List”-form, and click Functions -> Update. After the tool has collected the information (takes a few minutes), you can sort your tables by a number of factors which can all affect performance. And you can look at indexes for each table (Table -> Indexes (Ctrl+F5)), and get statistics for each individual index. These postings are provided “AS IS” with no warranties and confer no rights. You assume all risk for your use. Lars Lohndorf-Larsen Microsoft Dynamics UK Microsoft Customer Service and Support (CSS) EMEA Читать дальше
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|