Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

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

From: Tony Rogerson <tonyrogerson_at_sqlserverfaq.com>
Date: Tue, 21 Feb 2006 17:52:49 -0000
Message-ID: <dtfk0u$e5o$1$8302bc10@news.demon.co.uk>


> 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)
Received on Tue Feb 21 2006 - 11:52:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US