Capacity plannaing (Was Re: Algorithm Question)

[Cross-posting to a more relevant group with title changed.]
Peter Kim
This posting is provided "AS IS" with no warranties, and confers no rights.
"Poch Reyes" <pochreyes@.hotmail.com> wrote in message
news:e6S0%23oz1DHA.2480@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Hi Peter,
> Thanks for this info. We have a client here in the Philippines. Can you
> direct me to good SQL Server data mining sites outside of the MSFT site?
> Also, I would also like to ask for your comments on capacity planning
> against current hardware solution of our client. Please see below the
> details:
> System Capacity Requirements
> - 1 million transactions per day
> - Daily refresh of reports, reports available by 9am every day
> - Keep up to 2 years of historical data
> - Recommendation system should be able to process a minimum of 150
> transactions per second
> Solution should run on the following hardware/software platform
> - 2 x Dual Processor Intel PIII 1.13GHz Servers with
> - 512 MB Memory
> - 500 GB Shared Storage
> - Windows 2003 Server
> What do you think, will these type of server with specs indicated hold?
> Thanks,
> Poch
> "Peter Kim [MS]" <peterkim@.online.microsoft.com> wrote in message
> news:e8DUXet1DHA.2000@.TK2MSFTNGP11.phx.gbl...
> need
the[QUOTE]
cases[QUOTE]
> calculated
may[QUOTE]
more.[QUOTE]
> rights.
used[QUOTE]
> probability,
> Confidence
>

---

I think the current question is about the capacity issue outlined below?
Are the server specs good enough? It really depends on how taxing those 1
million per day transaction are... are they expensive or cheap statments?
It's reasonable to think a dual box as described below could handle the
job. But there's no way to know without better understanding the transaction
mix... also depends on how well tuned (indexes, etc...) the db is...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Peter Kim [MS]" <peterkim@.online.microsoft.com> wrote in message
news:%23pDhO8g2DHA.1720@.TK2MSFTNGP10.phx.gbl...

quote:

---

> [Cross-posting to a more relevant group with title changed.]
> --
> Peter Kim
> This posting is provided "AS IS" with no warranties, and confers no

---

rights.

quote:

---

> "Poch Reyes" <pochreyes@.hotmail.com> wrote in message
> news:e6S0%23oz1DHA.2480@.TK2MSFTNGP10.phx.gbl...
if[QUOTE]
but[QUOTE]
> the
> cases
> may
> more.
to[QUOTE]
the[QUOTE]
> used
>

---