Microsoft Dynamics AX (Archived)

Report server high CPU issue

(0) Share

Report

Posted on by Hassan_rulz

3,801

Hi All,

We have 6 AOS (2 Batch servers) servers in our environment with 2 SQL servers.

We have created a configuration file (with all the AOS servers ) and placed it at the following location,

C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\bin\Microsoft.Dynamics.AX.ReportConfiguration.axc

Now issue is that we are getting high CPU issue more than 90% of CPU is consuming on the only one AOS server and all other AOS servers are not even using 10% of CPU.

We are able to find that the issue is with report server and we have swap AOS servers sequence in configuration file. Always the first AOS in report server config is facing high CPU issue.

Can anybody guide me how to troubleshoot this issue or get more details?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

If you intend to load balance your SSRS workload across all of your AOS servers, have you considered a cluster arrangement? Either a dedicated AOS load balancer, or better yet a Windows NLB cluster?

Was this reply helpful? Yes No
Hassan_rulz 3,801 on at

Like (0)

Report

Hi Brandon,

We have implemented AOS non dedicated load balancing.

Regards,

Hassan

Was this reply helpful? Yes No
Hassan_rulz 3,801 on at

Like (0)

Report

Hi Crispin,

This idea can work but we want to identify which reports or processes causing high CPU. We want to enhance tuning for those reports/processes.

However, Your idea is great but we can't implement as this is our production environment. We need concrete evidence to perform such activities.

Regards,

Hassan

Was this reply helpful? Yes No
sri17 346 on at

Like (0)

Report

Hi All ,

We have similar issue and need some insights that who to track that which reports or processes cauing high CPU .

Kindly help here or share more insights on this.

Was this reply helpful? Yes No
sri17 346 on at

Like (0)

Report

Hi All ,

We have similar issue that Reporting services consuming high CPU and need some insights that how to track that which reports or processes causing high CPU .

Kindly help here or share more insights on this

Was this reply helpful? Yes No
Suggested answer

JII SAADUDDIN 1,832 on at

Like (0)

Report

Hi! Hassan Raza, We have this issues lately. but what we did is by separating TempDB, SSRS report server, and the main database server to a different Storage drives. Now our Server is still green and easy loads

Was this reply helpful? Yes No
Suggested answer

ObiOne on at

Like (0)

Report

Hi Hassan,

I would read through these articles and make sure your MS SQL Server instances are set correctly. They are very detailed but very useful articles.

blogs.msdn.microsoft.com/.../ax-performance-checking-key-sql-server-configuration-and-database-settings

blogs.msdn.microsoft.com/.../ax-performance-analyzing-key-sql-server-configuration-and-database-settings

blogs.msdn.com/.../ax-performance-troubleshooting-checklist-part-1a-introduction-and-sql-configuration.aspx

blogs.msdn.microsoft.com/.../ax-performance-troubleshooting-checklist-part-2

Good Luck.

Was this reply helpful? Yes No