Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-04 : 08:05:10
|
| Steve Anischenko writes "We have a Shop Floor data Collection system (client Server) app running on SQL Server 2000. It's running on a dell PowerEdge 1400SC (Pentium 3 1G processor with 256 meg of ram).Server aand clients are all win2k.there are approximately 20+ clients. Hald of them processing transactions and half for reporting (Crystal Reports).We seem to be having performance problems. Do you think we have emough memory / processing power?How can I find out if the bad performance is due to cpu/memory?How would I know if a memory upgrade or additional CPU will make a difference and how much of a performance increase can I expect?Thanks,Steve" |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-04-04 : 08:28:52
|
| its pretty difficult to tell about your percentage of performance increase.i think additional ram should help you. load your system with as much RAM as possible.-------------------------------------------------------------- |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-04-04 : 08:39:30
|
The first sign of trouble here is the fact that you don't mention in any way the server's disk subsystem. It is the 2nd most critical subsystem of the 4 in a server.( the four being: memory, network, disk, cpu ).Database servers with well designed databases do not use large amounts of CPU. In most performance situations, the type or # of processors isn't even relevant.I'll bet you've got some desktop machine there with IDE hard drives you've tried to masquerade as a "database server" ... if you do, post back and I'll make some suggestions.quote:
Steve Anischenko writes "We have a Shop Floor data Collection system (client Server) app running on SQL Server 2000. It's running on a dell PowerEdge 1400SC (Pentium 3 1G processor with 256 meg of ram).Server aand clients are all win2k.
quote:
We seem to be having performance problems. Do you think we have enough memory / processing power?
setBasedIsTheTruepath<O> |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-04 : 09:19:41
|
quote:
I'll bet you've got some desktop machine there with IDE hard drives you've tried to masquerade as a "database server"
Only if Dell changed the specs recently:http://www.dell.com/us/en/biz/products/model_pedsc_1400sc_back_2_pedge_1400sc.htmThe network can also be a bottleneck, especially if the clients open connections to the database and never close them, and/or create multiple connections. How do the people who are processing transactions process them? Is it a custom VB/C++ app? A web app? Enterprise Manager? And how is Crystal Reports used? Canned reports, or the users create ad-hoc reports? |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-04 : 14:11:39
|
| My first guess would be RAM. 256 MB is barely enough to run a respectable Win2K server, much less SQL Server on top of it. RAM is comparitively cheap and can't hurt the system. You should definitly look at the rest of the bad performance flags, but I'd go order that RAM now.Jeff BanschbachConsultant, MCDBAEdited by - efelito on 04/04/2002 14:12:07 |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
|
|
|
|
|
|
|
SQL Server Performance