| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2007-08-23 : 16:32:58
|
| I have a friend who is doing a voting application for one of his customers and they are concerned about the volume that sql server can handle. He's looking a single sql server 2005 with plenty of hd space and 4gb of memory. The app will look to see if you voted and then insert a record accordingly. Are there any papers out there or apps that can show the amount a server can handle?thanks. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-23 : 16:37:34
|
| What do you mean by "the amount a server can handle?"Amount in terms of what? database size? Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2007-08-23 : 16:43:38
|
How many transactions per Hour. quote:
Originally posted by dinakar
What do you mean by "the amount a server can handle?"Amount in terms of what? database size? Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
|
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-23 : 16:44:31
|
| That depends on your hardware configuration.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2007-08-23 : 16:51:14
|
So lets say I have 1 Box with plenty of space configured the appropriate way with RAID. I also have 4gb of memory. Where could I anticipate bottlenecks? I will run the same insert / lookup statement throughout the day. My application side will be running .NET 2.0.quote:
Originally posted by dinakar
That depends on your hardware configuration.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
|
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-23 : 16:58:28
|
| That is very generic description even for a desktop. You have to look into how many processors, what is the anticipated load, what is the DB size and anticipated growth for DB. Past all this, inspite of having the best configuration, it comes down to your application. If you have poor code, no hardware is going to help.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-23 : 22:36:35
|
| If you know amount of data and transaction rate, you can go to server vendor's web site to get server spec based on your info. |
|
|
|
KenS
Starting Member
6 Posts |
Posted - 2007-08-27 : 08:21:30
|
| How many concurrent connections do you anticipate and how are those connections made? Are they pooled and resued? Connections consume resources. Good planning in this area can really help. I worked at a company that had a large e-commerce site and we handled tremendous numbers of reads. We did not do as many writes as reads, but we still did a fair volume. One of the biggest factors is how simple or complicated are your queries. From your description, they sound simple. That is good. Once the queries get elongated, performance will degrade. You should also review your locking scenario/plan. Do you allow users to read from the table as it is being written to? Can you use NOLOCK on your reads? How much of the overall time is spent in the transactions?Dinakar is absolutely correct in saying that poor code can overrule good hardware. I mentioned only some of the factors you need to consider in driving performance.If you find the white paper you are looking for, you need to ask yourself ... How close is my application to the one used in the white paper? You can get a wide variation of results on the same hardware.Good luck.Ken |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
|
How much can sql 2005 handle