How can I make ot faster?
Hi there,
I've a software based on SQL database, the problem is the data base cann't carry alot of orders.
when 1 user or 2 or 3 or 4 working in same time there is no problem, but when the 5th user logs in the problem appears.
the problem is that database stops responcing, the CPU usage becomes 100% the other computers (users) cann't work (database freez).
when I close the SQL server and run it again the problem disappear but when 5 users log in the problem appears and so on.
Server Config:
OS: Windows 2000 Pro SP4
Processor: P4 2.8 GHz
Memory: 1 GB
by the way, I'm using the software in a WLAN.
what can I do to make this database faster and prevent freezing ? does increasing memory solve my problem ? or is there anyway to make database responce faster and doesn't freez ?
thank all of you,
Transporter
# 1 Re: How can I make ot faster?
If you look at the SQL profiler, is the problem because you are perfoming too many queries against the database and you don't have the bandwidth to complete them?
If so, you'll need to refine your queries to only pass around the minimal amount of data.
It its not an SQL problem, do you have a bottleneck somewhere that "breaks" at 5 users?
Davey at 2007-11-9 13:38:38 >
# 2 Re: How can I make ot faster?
Hi Davey,
first of all thank you for help.
second, I didn't catch your idea completely but let me explain few things to make them clear.
yes each user do alot of queries (around 6-7 queries per click) and they are working together all the time without stopping.
actually I have that problem only in one case, sometime when only one or two users are working but doing alot of queries the database hangs in one query and freezs and the CPU usage becomes 100% then I should restart my program again.
does upgrading the OS to Windows 2003 Server change any thing in this case ?
I increased the memory up to 1.5 GB but nothing changed except the process became faster (about 20% more).
sadly, I don't know alot about SQL databases or it's techniques and dealing with them.
thanx
Transporter
