Networks

Ask something
Discussion Locked

WEB clients/hardware

0 helpful
3 replies

by jim.brown 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm needing to find out what sort of load 5000 users attaching to a SQL database through a web front end will place on the Proc and Memory. and how much memory will i need and how many procs will i need

Thanks in advance

3 replies

by stillatit

You do not have enough information to even guess at an answer. You will need to have estimates of the following:

Number of queries per second
Number of database records
Type of query (can all queries be handled by the index entries, without reading each record in a subset?)
How much data will be returned by each query
What response time do you need?
Will any queries block other queries

With all the information, you look for bottlenecks, turn the crank, and find out that the answer still is a guess.

General recommendations --

1. Max out the memory. SQL server will use as much as it can get its claws into, and the more you have to swap, the slower things are.

2. Processors are cheap in a box set up to handle multiple processors. Buy as many as you can afford, up to what the box can handle.

3. The fastest disks and controllers you can get your hands on, with the disks on multiple spindles.

4. Your OS must handle the multiple processors -- NT Enterprise or W2K Data Center.

5. Dedicated 100mbps network between the two servers. Separate NIC's to handle traffic to the rest of your network.

Good luck.

This discussion is closed to new replies.