Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

> Which somehow explains why even Microsoft doesn't use its own technology
> under its SAP financial system: Right?

A tad out-of-date on that one, they migrated to the beta of SQL Server 2005 in August 2004.

http://www.microsoft.com/technet/technetmag/issues/2006/01/RunningSAP/default.aspx

"With 60,000 employees and operations in 89 countries, Microsoft has plenty of financial and operational data to track. The company's SAP R/3 system handles the Microsoft treasury, material management, payroll, worldwide sales, FINANCE, human resources, operations, as well as other mission-critical functions. In fact, the company's business depends on SAP R/3 being available.
For enterprises that depend on SAP, SQL ServerT 2005 provides three features of immediate benefit: online indexing to allow index maintenance while remaining online, SQL Server Dynamic Management Views to simplify administration, and database mirroring to enable hot standby failover with zero transaction loss. Microsoft began running its SAP R/3 environment on the beta edition of SQL Server 2005 in August 2004."

Can you provide a link to a reference that states Microsoft uses something else.

-- 
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"DA Morgan" <damorgan_at_psoug.org> wrote in message 
news:1140542565.495333_at_jetspin.drizzle.com...


> Serge Rielau wrote:

>

>>> What any and all financial systems require is the ability to produce a

>>> result set consistent to a point-in-time ... preferably without locking

>>> tables. Something impossible to do with previous versions of SQL Server.

>>

>> That's what timestamps are there for.  You rarely need to see the whole 

>> database in snapshot mode. If you want to sum the POS data up for the day 

>> a simple WHERE clause will do.

>> To solve concurency issues READ COMMITTED IMHO is plenty good.

>> Anything beyond that is 99% religion, 1% actual requirement.

>>

>> Cheers

>> Serge

>

> Which somehow explains why even Microsoft doesn't use its own technology

> under its SAP financial system: Right?

> -- 

> Daniel A. Morgan

> http://www.psoug.org

> damorgan_at_x.washington.edu

> (replace x with u to respond)