Dynamics AX/SQL Maintenance Scripts

  Attached are the Maintenance Scripts I described in my EaaS Video “Microsoft Dynamics AX and SQL Server Maintenance Plans”   1.   SP_STATISTICS_MAINTENANCE 2.   SP_INDEX_MAINTENANCE_ENTERPRISE       a. Requires parameter values be set 3.   SP_INDEX_MAINTENANCE_STANDARD       a. Requires parameter values be set 4.   SP_DBCC_CHECK_DB       a. Requires parameter values be set       Database Maintenance Script.zip

12

DynamicsPerf needs your HELP !!

We REALLY, REALLY, REALLY want to hear from you !!! I need your help in defining a list of new features for DynamicsPerf.  Please leave comments below explaining what you would like to see and what impact that feature would have on the Dynamics community.    Here are a couple of items on my agenda…

14

DynamicsPerf Deep Dive Blog Series

  Welcome to my blog series on Performance Analyzer for Microsoft Dynamics (Dynamicsperf) !! In this series of blogs, I will be covering the technical details of the DynamicsPerf toolset and how to analyze the data. Bookmark this blog entry and check back often. I will be linking to all of the blogs in this…


Performance Analyzer for Microsoft Dynamics 1.20 Deployment Guide Dynamics AX Installation

INTRODUCTION Please be sure to install the core components of Performance Analyzer for Microsoft Dynamics before completing this guide. http://blogs.msdn.com/b/axinthefield/archive/2014/05/29/performance-analyzer-for-microsoft-dynamics-1-20-deployment-guide.aspx Performance Analyzer is delivered as a SQL Server solution file and includes a set of SQL jobs, X++ classes, VB scripts, and performance counters to initiate the collection process. It also includes a set of…

11

Performance Analyzer for Microsoft Dynamics 1.20 Deployment Guide Core Installation

  INTRODUCTION DynamicsPerf (Performance Analyzer) ,http://dynamicsperf.codeplex.com,  is the tool used by Microsoft Dynamics support, Premier Field Engineers, and product team members to diagnose performance issues with Dynamics products. IMPORTANT: The purpose of the Performance Analyzer is to be used on a continual basis so it is important for administrators to understand the components that make…

4

DynamicsPerf Deep Dive – The Vision

  Before I dive into all of the things you can do with DynamicsPerf, I think it’s important that I describe its history as this will tell you a lot about the vision for the toolset. DynamicsPerf was born during the development of SQL Server 2005 which gave us Dynamic Management Views (DMVs).  Mark Prazak…

2

Time to patch SQL Server 2012 Service Pack 2

It’s time to patch SQL Server 2012 installations again.  There is one critical data corruption issue, a fix for Always On, SSIS bug that impacts DIXF and a new performance trace flag.   Here are the relevant KBs for SQL Server 2012 Service Pack 2 Cumulative Update 1:   Data corruption bug rebuilding clustered indexes online…

5

How to manage Windows NLB when AOS Service stops

Consider the following scenario where there is an AOS Cluster configured for Services’ high availability by following the information published at “Configuring network load balancing for services AX2012” (http://technet.microsoft.com/en-us/library/hh397322.aspx) The NLB cluster is working fine and suddenly one of the AOS services stops. The rest of Windows Server components in that server are still up and running. The NLB…

1

Management Reporter 2012 CU10 for Dynamics AX 2012 is now available!

If you have any question with regards to ERP versions supported by this release, please review the compatibility list here. Management Reporter 2012 CU10 (version 2.1.10001.112 & w/ Hotfix 2.1.10001.126 – see below) has been formally posted and ready for customers to download. This update release for MR 2012 contains enhancements around some of the most voted on suggestions in MSConnect including…