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

 
 
Опции темы Поиск в этой теме Опции просмотра
Старый 22.10.2009, 01:09   #1  
Blog bot is offline
Blog bot
Участник
 
25,574 / 848 (80) +++++++
Регистрация: 28.10.2006
Arijit Basu: SQL Database Performance Monitoring- Nice Tool
Источник: http://daxguy.blogspot.com/2009/10/s...onitoring.html
==============

"There is some problem with the database server..." is a very common term I hear often from clients who face performance related issue with AX. Well database tuning is very important and impacts performance but is not the only thing that needs to be looked. Some other things are:




Recently I was investigating some DB related issue by using SQL Native tools like DMV's, Activity Monitor, DTA etc and also looking for some other utilities which would provide some dashboard view of the AX Database and hit upon a nice tool 'SQL Sentry'.
I decided to take it for a spin on the AX 2009 database and the results were kind of impressive. The Performance Advisor for SQL Server Dashboard and the Disk Activity were nice. Really gives a nice overview to the DB Admin for monitoring and troubleshooting. Nice tool to complement with the native SQL Server tools. Attaching some screenshots I did on AX and SQL Sentry. Basically I had the test data in AX 2009 and ran some resource intensive tasks like Master Scheduling, Multiline journal posting and monitored them using this tool and was pretty impressed with the output. The counters are nice and highly informative(DISK IO).
Activity Dashboard:

Disk Activity:

You may like to take it for a spin :)
Happy DAX-ing


Источник: http://daxguy.blogspot.com/2009/10/s...onitoring.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
 

Похожие темы
Тема Автор Раздел Ответов Посл. сообщение
Arijit Basu: AX Intelligent Data Management Tool : Inside look Blog bot DAX Blogs 0 02.07.2009 22:05
Arijit Basu: Nice Sharepoint 2007 Training for EP Developers Blog bot DAX Blogs 0 09.12.2007 00:33
Arijit Basu: Trace Parser (beta) tool for Microsoft Dynamics™ AX 4.0 Blog bot DAX Blogs 0 02.08.2007 22:00
Arijit Basu: Microsoft SQL Server Reporting Services Integration Blog bot DAX Blogs 0 20.07.2007 11:50
Arijit Basu: Microsoft SQL Server Reporting Services Integration Blog bot DAX Blogs 0 28.06.2007 17:00

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

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

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