Re: Real Time Data

Define real time. If it is for a reporting application in most
situations it is unlikely that you really mean real time.

If you really do mean real time - ie both database completely in sync
all the time, then you need to use distributed transactions. If you
don't need this level of real time you will need to investigate
exactly why the locking is occuring.

Replication is not normally the cuplrit unless you are using high
values for subscriptionstreams, using too many independent agents, or
using running a lot of batch processes on your subscriber.

Make sure all the reporting applications are using the nolock hint -
this is only if you have relaxed real time requirements.

My advice to you would be to try to look at the reporting queries and
see if efficient indexes are in place, make sure the disk io subsystem
is able to support the queries, and use the nolock hint.





On Jul 18, 4:09 pm, "Rick" <rfem...@xxxxxxxxxxxxxxxxx> wrote:
Our company is having issues with reporting on real time data. We are using
SQL Server Reporting Services and SQL Server 2005, our reports are generated
from a Datawarehouse that is poplated using replication. Difficulties we are
running into is, reports that are running on the dataware house sometimes
block replication and then replication is blocking everything behind it, we
are still in the process of analyzing all queries(huge task, lots of
reports). I am not a DBA, but have some SQL server knowledge. I'm just
looking for some direction in how enterprise companies report on real time
data with a large amout of data. What are the best practices for populating
a data warehouse with real time data? Any replication confirguations that
could be recommended? Can anyone point me to some documentation on this?

Thanks in advance,
Rick

.

Relevant Pages

  • Re: Design opinion?
    ... replication is about the best you can do since log shipping takes the DB ... the ETL cycle to avoid blocking and dead locking. ... system and we would like to offload reporting to a reporting schema at a ... real time data available for reporting. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: [PATCH 1/2] Add scaled time to taskstats based process accounting
    ... The "scaled" time is really CPU cycles divided by some arbitrary ... real time rather than cycles, we have to continue reporting real time, ... not scaled time, which is why the existing interfaces report unscaled ...
    (Linux-Kernel)
  • Re: Hamilton and Massa get drive through penalties
    ... Is simply reporting what everyone else can see for themselves ... No. Fuckwits will be fuckwits. ... who have a need to spout about the ... race in real time, would go there, they could have a ball. ...
    (rec.autos.sport.f1)
  • Re: I hate Cardplayer and my apologies to Mark Napolitano
    ... I think the WSOP is just too damn big now (to show real time ... complete reporting). ... Bullshit. ... You have them turn in a chip/slip/whatever with their name. ...
    (rec.gambling.poker)
  • Re: Best practices for reporting: Replicated servers + data warehouse server??
    ... Can you specify requirements for the reporting data? ... servers for our business apps, as well as a data warehouse server. ... server) for real time reporting to alleviate the real time reporting ... burden off the production servers. ...
    (microsoft.public.sqlserver.datawarehouse)