September 24th, 2009, 04:03 PM
Windows 2003 server + Oracle, slow
I have GP ML-350 with 5 disk RAID5 + 1 Hot Spare
1 Xeon 3.2 Processor
I have Windows 2003 Server Sp2 + Adapted RAID 2120s Controler
Oracle 10g Version.
My problem is that the Database is very very slow, i have checked the performance monitor, and the avg. Disk queue length is at the top almost all the time.
When the users use the Front Office to write something down on the data base, is taking a very long time, the consulting is a bit more quicker, but not fast enough.
I have already shutdown all the services i didn't needed, i tried to manual insert the Paging files and put "windows choise", but it's still very slow.
I asked my database administrator, but the are also having trouble to speed up the database.
When there is only a few users connected to the database, the system is kind of fast, but when everyone is connected at the same time, it's practically impossible to work.
at first i tough it could be from the network, but if i run the front office locally and try to do something, it is still very very slow, so my guess is, it's not from the network.
This can be only 2 things bad oracle configuration, or something with the server configuration.
Maybe RAID Controller drivers??
What do you guy's think it could be?
Last edited by yuris; September 24th, 2009 at 05:04 PM.
September 25th, 2009, 05:25 AM
Performance will ALWAYS be restricted by the bottleneck.
If the server is performing well, and at least you have tried to bunk it down as much as you can - start looking outside the server. Network card speed? Switch? Workstation?
I would also recommend downloading wireshark or some other packet sniffer and watching if any large number of packets are being dropped between the server and workstations when accessing the database. I have seen this quite a bit.
What is the network infrastructure like between the server and workstations?
"Any intelligent fool can make things bigger and more complex... It takes a touch of genius --- and a lot of courage to move in the opposite direction."
- Albert Einstein
September 25th, 2009, 01:06 PM
I managed to speed up the database. I have cleaned all temp tables and changed the básic configurtion. It is working very fast now, the main problem, i guess, it was all the trash inside the tables that was slowing down everthing.
By cheyenne1212 in forum Miscellaneous Security Discussions
Last Post: February 1st, 2012, 02:51 PM
By gore in forum Microsoft Security Discussions
Last Post: September 19th, 2006, 12:57 PM
By nightcat in forum The Security Tutorials Forum
Last Post: May 28th, 2005, 03:47 AM
By gore in forum Operating Systems
Last Post: June 9th, 2004, 03:44 AM
By hatebreed2000 in forum AntiOnline's General Chit Chat
Last Post: March 14th, 2003, 06:36 AM