E9 Reporting very slow

Yahoo Archive
1

SSRS reports?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 06, 2016 9:34 AM
To: yahoogroups
Subject: [Vantage] E9 Reporting very slow

 




Good Morning All,

 

I would appreciate any input any of you could give me. 

 

The Problem:

 

Version: 9.05.702A

Database Type: Progress to SQL

System Setup: 2 server (1 SQL Server, 1 Application Server)

 

The problem is with reporting. Reports can take several minutes to hours to complete. For example, the Shop Load report takes 5 minutes to generate 12 pages of data. The only clue I have is the Task Agent needs to be restarted every few days or it stops working and has to be forced to stop. 

 

Everything else seems fine. Information to the screens comes fairly quick. No one locks up. dashboards work fine. 

 

I've eliminated any hardware issues. Both servers have enough RAM (256GB of RAM). Both servers are using (4) E7540 Intel Xeons. CPU usage rarely gets above 40% on the heaviest of days. Drives are 15K SAS RAID 10 and about 20K IOPS. 

 

Any suggestions? I appreciate the help.

 

Jonathan Lang

I.T Manager

Database Engineer

 




2
Good Morning All,

I would appreciate any input any of you could give me. 

The Problem:

Version: 9.05.702A
Database Type: Progress to SQL
System Setup: 2 server (1 SQL Server, 1 Application Server)

The problem is with reporting. Reports can take several minutes to hours to complete. For example, the Shop Load report takes 5 minutes to generate 12 pages of data. The only clue I have is the Task Agent needs to be restarted every few days or it stops working and has to be forced to stop. 

Everything else seems fine. Information to the screens comes fairly quick. No one locks up. dashboards work fine. 

I've eliminated any hardware issues. Both servers have enough RAM (256GB of RAM). Both servers are using (4) E7540 Intel Xeons. CPU usage rarely gets above 40% on the heaviest of days. Drives are 15K SAS RAID 10 and about 20K IOPS. 

Any suggestions? I appreciate the help.

Jonathan Lang
I.T Manager
Database Engineer

3

I sent you my collection of Epicor answer books on this offline.

 

Greg

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 06, 2016 9:34 AM
To: yahoogroups
Subject: [Vantage] E9 Reporting very slow

 

 

Good Morning All,

 

I would appreciate any input any of you could give me. 

 

The Problem:

 

Version: 9.05.702A

Database Type: Progress to SQL

System Setup: 2 server (1 SQL Server, 1 Application Server)

 

The problem is with reporting. Reports can take several minutes to hours to complete. For example, the Shop Load report takes 5 minutes to generate 12 pages of data. The only clue I have is the Task Agent needs to be restarted every few days or it stops working and has to be forced to stop. 

 

Everything else seems fine. Information to the screens comes fairly quick. No one locks up. dashboards work fine. 

 

I've eliminated any hardware issues. Both servers have enough RAM (256GB of RAM). Both servers are using (4) E7540 Intel Xeons. CPU usage rarely gets above 40% on the heaviest of days. Drives are 15K SAS RAID 10 and about 20K IOPS. 

 

Any suggestions? I appreciate the help.

 

Jonathan Lang

I.T Manager

Database Engineer

 



CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6240 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."