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.
25
questions
4
votes
1answer
47 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
204 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
303 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
348 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
84 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
248 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
866 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
390 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
471 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
233 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
154 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
674 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
53 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
188 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
31k 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
552 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
874 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
899 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
769 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 ...
