# Report Performance Issue

**URL:** <https://www.dynamicsuser.net/t/report-performance-issue/47460>\
**Category:** Developers Forum\
**Created:** [August 6, 2013, 11:18am UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460 "2013-08-06T11:18:34Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![shruti.deshpande](https://avatars.discourse-cdn.com/v4/letter/s/ba8739/32.png) [@shruti.deshpande](https://www.dynamicsuser.net/u/shruti.deshpande)\
**Post date:** [August 6, 2013, 11:18am UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460/1 "2013-08-06T11:18:34Z")

</div>

Hi All,

Aged Accounts Receivable report suddenly taking much time to run.

report has not changed from Oct’12.

Hardly one or two persons are running the report.

What may be the reason for report performance slow down.

If we say data, then it should slows slowly not suddenly & that is also 30-40 min.

Is there any other reasons like Hardware, services or any thing else? What should I check?

Document Posting taking normal time.

thanks,

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [August 8, 2013, 10:35am UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460/2 "2013-08-08T10:35:33Z")

</div>

Hi Shruti,

Is this the classic or the RTC report?

---

<div class="post-metadata">

**Author:** ![amol\_salvi](https://avatars.discourse-cdn.com/v4/letter/a/ac91a4/32.png) [@amol\_salvi](https://www.dynamicsuser.net/u/amol_salvi)\
**Post date:** [August 8, 2013, 11:03am UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460/3 "2013-08-08T11:03:16Z")

</div>

What is Database Size ??

Is any maintenance done on database ???

Is it customized report or standard report ???

---

<div class="post-metadata">

**Author:** ![shruti.deshpande](https://avatars.discourse-cdn.com/v4/letter/s/ba8739/32.png) [@shruti.deshpande](https://www.dynamicsuser.net/u/shruti.deshpande)\
**Post date:** [August 9, 2013, 6:07pm UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460/4 "2013-08-09T18:07:11Z")

</div>

Hi Erik,

Its RTC report.

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [August 14, 2013, 9:22am UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460/5 "2013-08-14T09:22:12Z")

</div>

Shruti,

Fine, and what’s the answers to Amols questions?

---

<div class="post-metadata">

**Author:** ![shruti.deshpande](https://avatars.discourse-cdn.com/v4/letter/s/ba8739/32.png) [@shruti.deshpande](https://www.dynamicsuser.net/u/shruti.deshpande)\
**Post date:** [August 19, 2013, 10:31am UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460/6 "2013-08-19T10:31:03Z")

</div>

Hello Amol,

Database size is about 20GB,

No one maintenance process on Database or machine.

Standard report but some customization are done in it.

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [September 8, 2013, 11:43am UTC](https://www.dynamicsuser.net/t/report-performance-issue/47460/7 "2013-09-08T11:43:34Z")

</div>

If customizations are done to the aging report, then I’ll suggest that you try to run the unmodified standard report, and if this report is not also very slow, then you contact the developer who created the customized report.

Also if no maintenance is done on you SQL Server, then you should have it looked at also. A SQL Server is not something you just install and leave “AS-IS”, but something which needs to be maintained on a weekly basis. There are lots of posts here on DUG explaining the different jobs you should schedule on your server to get optimal performance.