This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 57.00000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi ,
We have an issue at our SQL Server 2012 version server , Microsoft Dynamics AX - application team raising slowness concerns while validating from database perspective. we couldn't find any table locks in activity monitor or blocking sessions and no other jobs are running to produce conflicts with other queries . Even we have configured daily Reorg & Update stats job and weekly Rebuild index job . But still the application team facing slowness issue daily , also checked with other sides network and server end no issues found .
Particularly for there are two tables (Sales order and sales line ) they are trying to use from application end and during that time if execute update stats for those table , the issue resolves temporarily.
Could any one advise what would be the solution to fix this permanently .
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Seelan, Sathiya
Here is a document you may want to refer to for troubleshooting issues where your entire SQL Server or database application appears to be slow: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-entire-sqlserver-slow?tabs=highcpu.
If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.
Best regards,
Aniya
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 72%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hi Aniya , We have tested the steps which are mentioned on the above link .. OS part network part .. memory and CPU usage all tends to be normal for both application and database servers. Only one thing we haven't tired thats application layer we haven't took any of those queries and run it manually. The application team complaining the whole application console is slow . If they entered any of request from application end it's taking more time to execute.
The application team complaining the whole application console is slow . If they entered any of request from application end it's taking more time to execute.
That sounds more like an issue with the application server, network or similar than SQL Server. But with the very terse description you have shared, the issue could really be anything.
From the information you have shared, there is nothing we can do to assist, but give some advice for troubleshooting.
You will need to get hold of which queries that are also. You say that updating statistics helps. It would then be a good idea to get the query plan before and after the statistics update. It may not be the case that the statistics update really matters. Next time just do "sp_recompile tbl" and see if this has any effect. That would suggest that it is a parameter-sniffing issue.
What the actual solution would be is to early to say. You need to find information first.