AXForum  
Вернуться   AXForum > Microsoft Dynamics AX > DAX Blogs
All
Забыли пароль?
Зарегистрироваться Правила Справка Пользователи Сообщения за день Поиск Все разделы прочитаны

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 21.03.2012, 07:15   #1  
Blog bot is offline
Blog bot
Участник
 
25,459 / 846 (79) +++++++
Регистрация: 28.10.2006
axinthefield: Performance Analyzer Reports
Источник: http://blogs.msdn.com/b/axinthefield...r-reports.aspx
==============

We're excited to introduce the next evolution with our Performance Analyzer for Microsoft Dynamics toolset. We'll review the concepts today at Convergence at the Performance Analyzer for Microsoft Dynamics session at 5pm in the Hilton Ballroom B on the 2nd floor. In this post, we'll list the reports that are included in the attached zip file. The zip file includes the Microsoft SQL Server Reporting Services reports as well as a PDF that provides further information on each report. Stay tuned for future posts drilling into each report in more depth.

The list of reports is as follows:

1) Configuration-Server Configuration
- Insight into your current SQL Server and Database configurations
2) Documentation – AX Long Running Queries
- Provides you a list of slow performing database code with the Dynamics AX Call Stack and user information
3) Documentation – Long Running Queries
- Provide a list of long running queries on your Microsoft Dynamics database sorted by Total Elapsed Time.
4) General Query Analysis – Query Analysis
- Meant to be used by your SQL DBA to resolve database query performance
5) Monitoring-Hourly Disk I/O
- Provides a detailed analysis of how your disks that contain database files are performing on an hourly basis.
6) Monitoring-Row Count Statistics (Daily)
7) Monitoring-Row Count Statistics (Hourly)
8) Monitoring-Row Count Statistics (Hourly Detail)
- Drill through set of reports to analyze transaction volume of your Microsoft Dynamics Solution
9) Monitoring-Row Count Comparison
10) Monitoring-Row Count Comparison Sub
- Detailed report to show transaction volumes between different data collection points in the DynamicsPerf database.
11) Query Analysis (Various levels)
- Detailed drill-through report for investigating slow performing database queries
12) Scan Analysis (Index Statistics, Table Properties, User Scan Analysis)
- Set of reports to investigate queries scanning tables in your Microsoft Dynamics Database

These reports are being released as sample reports for Performance Analyzer for Microsoft Dynamics. The reports can be deployed to an existing SSRS server or can be run with SQL Server Business Intelligence Development Studio (BIDS). There is a setup guide provided in the download for the reports.

The sample reports can be downloaded at the bottom of this post.

We would love to hear your feedback on these reports. Please post your ideas and suggestions in the comments of this blog entry.

Rod Hansen, Brent Sokolofsky and Eric Newell

Premier Field Engineering for Dynamics AX




Источник: http://blogs.msdn.com/b/axinthefield...r-reports.aspx
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
axinthefield: New DMVs in SQL Server 2008 R2 SP1 and SQL 2012 ('Denali') and Performance Analyzer for Microsoft Dynamics Blog bot DAX Blogs 0 14.01.2012 05:33
axinthefield: Data Management Views used in Performance Analyzer for Microsoft Dynamics Blog bot DAX Blogs 0 13.06.2011 00:11
axinthefield: Capture Database Blocking with Performance Analyzer for Microsoft Dynamics Blog bot DAX Blogs 0 03.03.2011 21:11
axinthefield: Setting up Performance Analyzer for Microsoft Dynamics Blog bot DAX Blogs 0 01.03.2011 08:12
axinthefield: Performance Analyzer for Dynamics Blog bot DAX Blogs 0 11.12.2010 06:22
Опции темы Поиск в этой теме
Поиск в этой теме:

Расширенный поиск
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.
Быстрый переход

Рейтинг@Mail.ru
Часовой пояс GMT +3, время: 05:20.
Powered by vBulletin® v3.8.5. Перевод: zCarot
Контактная информация, Реклама.