Questions tagged [microsoft-dynamics]

The Microsoft business applications product line, which is now being rolled into a single Dynamics 365 brand. Please add more details about the product and the version in the question body.

Filter by
Sorted by
Tagged with
1
vote
0answers
16 views

Source Control Dynamics

What ways are there to do version control of an MS Dynamics database? I've found mentions of DACBAC, and obviously SSIS packages could just be dumped in a git repo. I'm particularly keen on learning ...
4
votes
1answer
119 views

Delete unused indexes from Microsoft Dynamics CRM Application

So I found tons of unused indexes from our CRM application with this query from Pinal: SELECT o.name AS ObjectName , i.name AS IndexName , i.index_id AS IndexID , dm_ius.user_seeks AS UserSeek , ...
0
votes
2answers
601 views

Add missing column to SSIS, data not extracted to staging table

I've inherited an environment that extracts data from a Dynamics AX 2012 ERP to a data warehouse for reporting. The original extraction set up by consultants did not include the proper date column ...
0
votes
1answer
821 views

SSRS Rectangle visibility based on Parameter Value

I am creating a Report in SSRS. Its a Dynamic 2011 CRM Report. I have created some Tables. And some Rectangles. Each Rectangle contains some Tables. Also there is a Parameter that contains value from ...
5
votes
2answers
553 views

What is the persistent_version_store table?

What is the purpose of the MS Shipped table: sys.persistent_version_store? Why do I want to know Primarily curiosity, partly because it may relate to an issue waiting to bite us... We're running a ...
1
vote
0answers
97 views

Troubleshooting non-working Plan Guide in SQL Server 2008 R2

I have problems with a Plan Guide I have created in Microsoft SQL Server 2008 R2. The Plan guide is purposed for a performance issue in Microsoft Dynamics AX 2009 and forces a specific question to use ...
1
vote
2answers
283 views

POS Performance Issue AX 2012 R3

I have slowness. Can anyone review this plan (PasteThePlan) and tell me what I need to optimize? This is the actual plan. That is a part of process to get Customer Info from an application. In a ...
9
votes
1answer
1k views

sp_cursorprepexec causing 53 million reads?

We are running a Dynamics AX 2012 installation with SQL Server 2012. I know that cursors should not be used anymore but AX is using it and we can't change this behavior so we have to work with it. ...
2
votes
1answer
632 views

Add shared folder to AlwaysOn AG Failover

We have setup a 2 node Synchronous AG with automatic failover to provide HA for our ERP application (Dynamics GP) The GP desktop client loads a number of shared reports and dictionaries from a file ...
4
votes
2answers
586 views

Help me tune the long-running query

I have a problem with the following query executing from the application (Microsoft Dynamics AX): DECLARE @p1 INT; SET @p1 = NULL; DECLARE @p2 INT; SET @p2 = 0; DECLARE @p5 INT; SET @p5 = 2 + 4096; ...
2
votes
1answer
253 views

Configuring Dynamics GP's (SQL Server) Disks

I am an accidental DBA at my work, and when I took it over, it was quiet a mess. Fortunately, we have the green light to build new systems for an upgrade to our accounting system: Microsoft Dynamics ...
1
vote
1answer
166 views

Should I ever use query hints?

SQL Server 2008 R2, Dynamics AX 2009 We have this ugly query DECLARE @P1 NVARCHAR(5), @P2 INT, @P3 INT, @P4 NVARCHAR(11), @P5 INT, @P6 NVARCHAR(5), @P7 NVARCHAR(11)SELECT A.SALESID, A.LINENUM, ...
3
votes
1answer
2k views

Select only the most recent record

I've got a problem with creating a SQL query in order to get only the most recent record from multiple records. I've already checked different solutions like a subselect; unfortunately that does not ...
2
votes
1answer
727 views

Slow without recompile

My query performs bad when I run it without OPTION (RECOMPILE). Without recompile it take 3-4 minutes to run and with recompile it takes about 15-20sec. I can’t change the query, I have updated all ...
1
vote
0answers
54 views

SQL Server 2016 CU2: Severity level 20 errors for DML on restore of AX Dynamics 7 database with Change Tracking

Problem: After we restore a database to a new environment, we are unable to perform DML operations (e.g. update the record) in some specific tables which have change tracking enabled. Details: We ...
7
votes
2answers
193 views

SQL perf issue - configure server correctly first or troubleshoot issues one by one?

This is for SQL Server 2012. I am troubleshooting overall slow performance on a Dynamics AX environment. Everything is just slow - app itself, reports, ad-hoc, etc. Right off the bat, I can see ...
31
votes
3answers
37k views

What does OPTION FAST in SELECT statement do?

I have done some digging on what the OPTION (FAST XXX) query hint does inside a SELECT statement and am still confused on it. According to MSDN: Specifies that the query is optimized for fast ...
2
votes
0answers
692 views

Include HostName in ODBC System DSN Connection

Not sure if this is a question for here or if it should go on Stack Overflow. If SO is a better fit, please migrate it. Our finance team uses Dynamics GP. Occasionally we need to track the query that ...
3
votes
2answers
995 views

Why is context_info sometimes blank in sys.dm_exec_sessions?

I am trying to get information from the context_info column using Cast(context_info as varchar(128)) from sys.dm_exec_sessions as given in the article below: Finding User Sessions from SPID in ...
4
votes
3answers
1k views

Setting maxdop 1 vs setting the threshold for parallelism high

I am looking at a possible fringe case for parallelism settings. I've long since followed the credence that maxdop 1 is a viable option for Microsoft Dynamics CRM databases. As the nature of the ...
15
votes
1answer
2k views

sp_cursoropen and parallelism

I'm running into a performance problem with a query that I can't seem to get my head around. I pulled the query out of a cursor definition. This query takes seconds to execute SELECT A.JOBTYPE FROM ...
7
votes
2answers
2k views

Verifying connection pooling server side with CONTEXT_INFO on

I'm working with a 3 tiered application, Microsoft Dynamics AX, where the middle tier maintains connections to a SQL Server. Several clients connect to this middle tier server. The middle tier server ...
1
vote
2answers
876 views

Viewing execution plans for queries with parameters

I have a sample query generated by an application (Microsoft Dynamics AX 2012 in this case) which is ineffective performance-wise (cross joins, order by etc.) I would like to display its execution ...
7
votes
2answers
26k views

How to repair database consistency errors

I have a Microsoft Dynamics AX SQL Server database. I just run DBCC CHECKDB in order to check the integrity. After a few minutes I got at the end of the results the following: CHECKDB found 0 ...
4
votes
2answers
2k views

Join on dm_db_index_physical_stats very slow

I'm running a small query below in a MS Dynamics AX 2012 database and it runs more than 5 minutes which I had to cancel and it is showing PAGEIOLATCH_SH wait type. The database data file is 560GB and ...