You don't have to be a SQL Server technical guru to
know that too much database contention
causes problems. Like random deadlocks.
Fortunately, implementing Data Mart ETL can reduce
the pressure on your database and keep things
For details, read my post:
Data Mart ETL Basics
Random deadlocks are just one of several common problems
that impact reporting and analysis.
Other common issues include
Slow Response, and
Proper use of Data Mart ETL can go a long way
toward eliminating all of these problems. It really is a multi-faceted solution.