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 |
|
Asanka
Starting Member
2 Posts |
 Posted - 2005-08-11 : 07:55:18
|
Hi all,When 60 users are connected & working in my system, performance go down heavily, Timeout expired errors are coming, system is getting slow, when I am writing datas to temporary files to get complex reports. Is there any one who can help on regarding this ??? I am using Pentium III, with 1 GB RAM, 1.13 GHz Processor, Using SQL 2000 version. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-11 : 07:59:09
|
| Your server is a little light for that kind of traffic, and unless your database code is exquisitely tuned and efficient you're likely to see continued slow performance. Since you're "writing datas to temporary files to get complex reports" I'm assuming the tuning is not there yet. Best thing to do is get a bigger server with multiple CPUs and a LOT more RAM, and a better disk I/O system. |
 |
|
|
Asanka
Starting Member
2 Posts |
Posted - 2005-08-11 : 08:18:23
|
| even for direct reporting (crystal reports), system is giving timeout expires message. For the tuning, is there any recommended ways of doing it, using the existing hardware ??? |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2005-08-11 : 10:11:43
|
quote:
even for direct reporting (crystal reports)
You say this as if it is a surprise. It depends on the sophistication of who developed the real time reports. Reporting in general can be a huge load.I wish someone would start an Official XML Rant Thread. |
|
|
|
|
|
|
|
|
SQL Server Performance - URGENT