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.
30
questions
6
votes
3answers
589 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 ...
0
votes
1answer
46 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 ...
0
votes
1answer
100 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 ...
0
votes
1answer
81 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
0answers
40 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
289 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
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 ...
0
votes
1answer
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
2answers
181 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
2answers
936 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
135 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
332 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
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 ...
4
votes
2answers
758 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
266 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
191 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
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 ...
2
votes
1answer
805 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 have ...
7
votes
2answers
199 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 ...
34
votes
3answers
44k 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
0answers
811 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
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 ...
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
998 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
27k 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 ...
