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.
32
questions
0
votes
0
answers
41
views
Indexing operations on a 8TB AX dynamics database
We have an 8TB AX dynamics database on SQL Server 2016 Enterprise Edition.
Our team would like to perform indexing operations but for a max of 8 hours with minimal impact during the week. My ...
- 11
0
votes
0
answers
13
views
Query to Include All Records
I am trying to create an excel report and am running into an issue that I am most likely overthinking. What I am trying to do is create multiple pivot tables to show me my overall inventory and then a ...
- 126
6
votes
3
answers
625
views
Restore database of 90GB to computer of only 100GB
How do I restore a huge Microsoft SQL Server database that is 6GB as a zip file and 90GB as a bak file to a computer that only has 100GB free space?
When I uncompress the zip file I get a bak file ...
- 163
0
votes
1
answer
51
views
Can the Data Export Service in Microsoft Dynamics export data to an Azure Synapse Data Warehouse?
I am able to use the Data Export Service (DES) to export data to an Azure SQL Database. When I try to create a new profile in DES that connects to a Data Warehouse (aka Azure Synapse Analytics) on the ...
- 103
0
votes
1
answer
122
views
How to connect to Microsoft Dynamics Rms 2.0 Running sql2008r2?
Would anyone know anything about Microsoft Dynamics Rms 2.0 (2012)? We are having trouble connecting our sql server to the client side cashier (windows 10 pro) this software sunset in 2016 I believe ...
- 1
0
votes
1
answer
118
views
Full-Text Search against serial numbers?
Using Dynamics 365 with MSSQL. There is an option to enable Full Text Search, however once it is enabled we cannot search by partial serial numbers.
For instance, KN567228 shows in the full text ...
3
votes
0
answers
41
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 ...
- 31
4
votes
1
answer
331
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
, ...
- 7,114
0
votes
2
answers
1k
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 ...
- 261
0
votes
1
answer
2k
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 ...
0
votes
2
answers
205
views
Difference in duration of SP:Completed and sum(SP:StmtCompleted) [closed]
I have a stored procedure, which sometimes displays a big difference in duration for the overall execution time and the execution time for each of its statements. The procedure consist of 4 statements,...
6
votes
2
answers
1k
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 ...
- 419
1
vote
0
answers
151
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 ...
- 11
1
vote
2
answers
346
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 ...
- 66
9
votes
1
answer
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.
...
- 185
2
votes
1
answer
1k
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 ...
- 21
4
votes
2
answers
787
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,193
2
votes
1
answer
270
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
1
answer
203
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,
...
- 2,193
3
votes
1
answer
3k
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 ...
- 33
2
votes
1
answer
821
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 ...
- 979
1
vote
0
answers
55
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 have ...
Muhammad Irfan Rasheed Malik
7
votes
2
answers
203
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 ...
- 532
34
votes
3
answers
45k
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 I'm still confused about it. According to MSDN:
Specifies that the query is optimized for fast ...
2
votes
0
answers
835
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,152
3
votes
2
answers
1k
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 ...
- 31
4
votes
3
answers
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 ...
- 2,501
15
votes
1
answer
3k
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 ...
- 15.4k
7
votes
2
answers
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 ...
- 15.4k
1
vote
2
answers
1k
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 ...
- 1,405
7
votes
2
answers
28k
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 ...
- 213
4
votes
2
answers
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 ...
- 41