How to reduce timeouts in SQL Server?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Karan (k_karan_at_hotmail.com)
Date: 07/08/04 

Date: 8 Jul 2004 15:25:35 -0700

Hi,

We have designed a system which processes millions of transactions a
year. There are a couple of tables in the system which are heavily
used. These 2 tables gets about 30,000 rows inserted into them
everyday at an average. The inserts are done through stored procedures
after perfomring some complex logic. There are also a few scheduled
jobs that run every night which accesses these 2 tables. In addition,
there are a few reports that run in the web system which acces these
table for ad-hoc reporting. In the last few months, the number of
transactions have increased quite a bit and system started giving us
problems such as a lot of timeouts and a few deadlockks everyday.

I am thinking that if I can somehow replicate these tables every 6
hours or so and then use the new tables for all reporting purposes, my
timeouts might decrease. Could you suggest on how I could go about
replicating these 2 tables in an efficient way? and whether this would
help my situation?

Any other suggestions on how I could improve my system would be
appreciated.

Thanks,
Karan

Relevant Pages

  • RE: How to reduce timeouts in SQL Server?
    ... "Karan" wrote: ... > table for ad-hoc reporting. ... > transactions have increased quite a bit and system started giving us ... > I am thinking that if I can somehow replicate these tables every 6 ...
    (microsoft.public.sqlserver.server)
  • Re: Question Re: Patriot Act
    ... >>because his radar detector went off or he spotted the checkpoint) ... except for possible ways around the reporting. ... as a series of transactions at or less than $10,000. ... avoid the reporting, and the bank notices it, they get both a CTR ...
    (misc.legal)
  • Re: Cable TV News badly misreported Gov. Spitzers case
    ... Transaction reporting: The requirement for banks to report routine ... transactions over $10,000 applies to CASH only. ... That law applied to forced transport, ... I would suggest anyone interesting in the actual facts, ...
    (rec.arts.tv)
  • CashBook 1.20 Released
    ... Following its launch at the Wakefield Show this weekend, ... CashBook is a home accounts application, ... Repeating transactions, such as standing orders, direct debits or salary ... An integral reporting system is included, ...
    (comp.sys.acorn.announce)
  • Re: WLM - Goal Management Doubt
    ... If the purpose of defining two identical service classes is to get more granular reporting, ... As Ed implied in his reply, the more work in a service class, the better WLM's ability to manage it reponsively. ... 10 transactions will be assigned with service class A and 1 transaction will ...
    (bit.listserv.ibm-main)