Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 278 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Queuing Reports ?
burguetjf
Member Posts: 2
Hi everyone
Has anyone tried to implement a report queue to improve system performances ? Just like a shared network printer has a queue, I am thinking about the same concept to manage heavy reports.
If report A and report B are very processing intensive and need to work on the same data, the total running time to finish report A + report B is smaller if they are ran one after the other, no ?
Because of our business cycle, many of our Navision Attain 3.7 users need to launch very heavy reports on the same two or three days of the months. Our system (which works fine with 150 concurrent users during the rest of the month) obviously becomes extremely slow.
When our system becomes slow, everyone has to wait without knowing how long to wait. Managing users expectations is of course another of my goals. A nicely implemented queue could show them which/whose reports is waiting in the queue in front of theirs.
A further raffinement could allow a finetuning: how many reports can actually start running in parallel. Just one during busy times, more during calmer days...
We are already using a second server with a copy of the DB to run those heavy reports which are OK with yesterday's data. We need a solution for those reports running on "fresh" data from our main system.
We just started our reflexion, wondering if running the scheduler on a separate PC might the be the way to manage the queue.
Your ideas or suggestions would be most welcome. Thanks a lot !
Has anyone tried to implement a report queue to improve system performances ? Just like a shared network printer has a queue, I am thinking about the same concept to manage heavy reports.
If report A and report B are very processing intensive and need to work on the same data, the total running time to finish report A + report B is smaller if they are ran one after the other, no ?
Because of our business cycle, many of our Navision Attain 3.7 users need to launch very heavy reports on the same two or three days of the months. Our system (which works fine with 150 concurrent users during the rest of the month) obviously becomes extremely slow.
When our system becomes slow, everyone has to wait without knowing how long to wait. Managing users expectations is of course another of my goals. A nicely implemented queue could show them which/whose reports is waiting in the queue in front of theirs.
A further raffinement could allow a finetuning: how many reports can actually start running in parallel. Just one during busy times, more during calmer days...
We are already using a second server with a copy of the DB to run those heavy reports which are OK with yesterday's data. We need a solution for those reports running on "fresh" data from our main system.
We just started our reflexion, wondering if running the scheduler on a separate PC might the be the way to manage the queue.
Your ideas or suggestions would be most welcome. Thanks a lot !
0
Comments
(sorry that I insert URL to another forum site... ) 8-[ )
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.