HW Sizing

Does anybody know any article about HW sizing?
I need calculate for a SQL server with a maximun of 1000 transactions by
minute, but I don't know how to make the correct sizing of CPU and RAM.
Thanks"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:5BC4A673-9D64-4B9C-A62F-9E3E71C5BF32@.microsoft.com...
> Does anybody know any article about HW sizing?
> I need calculate for a SQL server with a maximun of 1000 transactions by
> minute, but I don't know how to make the correct sizing of CPU and RAM.
>
The cheapest way to do this is also, in many ways, the best. See if this
works for you:
Start with your desktop. Run your application and see what kind of
throughput you get. If the throughput is not sufficient on your desktop,
then improve your application until it is.
David|||You need to give more details!
Keep in mind thatthere is a limitation with SQL 2000 Server version for the
RAM (2 GB). I have seen few clients having 3+ GB of ram on their SQL2k server
box...
"Julio" wrote:
> Does anybody know any article about HW sizing?
> I need calculate for a SQL server with a maximun of 1000 transactions by
> minute, but I don't know how to make the correct sizing of CPU and RAM.
> Thanks|||"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:5BC4A673-9D64-4B9C-A62F-9E3E71C5BF32@.microsoft.com...
> Does anybody know any article about HW sizing?
> I need calculate for a SQL server with a maximun of 1000 transactions by
> minute, but I don't know how to make the correct sizing of CPU and RAM.
>
I believe MS Press has a book on this. Don't recall the title.
1000 transactions/minute doesn't help much. How complex are the
transactions?
How much I/O?
You can start with some basics like how much data will transferred.
If say each transaction is writing 10 bytes per transaction, that's 10,000
bytes/minute or 10Kb/min. That's not much at all. A simple IDE drive might
be able to keep up and the CPU may not matter much.
If on the other hand each transaction is reading 100,000 bytes of a text
field, doing a search and replace and writing it back, each transaction is
now doing 200K of I/O (split between reads and writes) and you're now doing
200 MB/minute which is a bit higher than before.
If you're simply writing data, but doing lots of math work, etc, you may now
need faster CPUs, etc.
> Thanks|||Hi Julio,
You're best bet is to go to the HP website and check the HP SQL Server
Rightsizer (or some sort of name to that effect). The tool interviews you
for a lot of details and then suggests exactly what type of server will fit
the bill. It's a very good tool for HW sizing.
Check http://h71019.www7.hp.com/ActiveAnswers/cache/70729-0-0-225-121.aspx
Best regards,
-Kevin
SQL Server MVP
"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:5BC4A673-9D64-4B9C-A62F-9E3E71C5BF32@.microsoft.com...
> Does anybody know any article about HW sizing?
> I need calculate for a SQL server with a maximun of 1000 transactions by
> minute, but I don't know how to make the correct sizing of CPU and RAM.
> Thanks