SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Realtime Report


Realtime Report

Author
Message
A K Balamurugan
A K Balamurugan
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 15
Hi
What are the pros and cons between Realtime and Near-Realtime Report.
w.r.t.. BAM(Bisness active monitor).
jim.powers
jim.powers
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4627 Visits: 890
This all depends upon your business rules. If your business requires realtime data (ie traffic officer pulling a warrant search for a traffic stop), you need to make sure your reporting server has the resources to respond as required. The complexity of the reports also plays into this equation. If your report is only pulling minimal information, the discussion may be a moot point. However, your CIO is trying to pull accounting history for the last year on your entire account tree, ouch (does she REALLY need it realtime?)!

We do run all of our reports realtime. However, it doesn't hurt since we are a small company and our database is only 50GB in size. Will this practice change in the future? NO. Our business rules require realtime reporting so we will have to do what is necessary on our part to make sure the application meets the business rule. There are reports that we are able to run in batch mode overnight as well. We don't have all of this well defined at this point but will in the near future.

All of this to say - define your business rules first. Unless something is absolutely critical to know realtime, obtain buy-in for a near realtime solution.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search