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
0
votes
2answers
97 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
0answers
25 views

Find when tables were deleted historically

We've had an issue where data tables have been deleted from a client applications SQL Server Database (Dynamics Navision). Unfortunately we had an outage and the SQL Servers were affected by this, ...
0
votes
1answer
131 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 ...
4
votes
1answer
290 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
83 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
231 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
822 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
347 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
433 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
228 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
151 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
1k 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
657 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
52 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 ...
6
votes
2answers
187 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 ...
27
votes
3answers
30k 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
522 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 ...
2
votes
2answers
853 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
883 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
1k 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
739 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
24k 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 ...