Results 1 to 3 of 3

Thread: Windows 2003 server + Oracle, slow

  1. #1
    Senior Member
    Join Date
    Apr 2005
    Posts
    123

    Windows 2003 server + Oracle, slow

    Hello.

    I have GP ML-350 with 5 disk RAID5 + 1 Hot Spare
    6GB RAM
    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?

    Thanks.
    Best Regards.
    Last edited by yuris; September 24th, 2009 at 04:04 PM.

  2. #2
    Keeping The Balance CybertecOne's Avatar
    Join Date
    Aug 2004
    Location
    Australia
    Posts
    660
    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?


    CTO
    "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

  3. #3
    Senior Member
    Join Date
    Apr 2005
    Posts
    123
    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.

Similar Threads

  1. Windows Error Messages
    By cheyenne1212 in forum Miscellaneous Security Discussions
    Replies: 7
    Last Post: February 1st, 2012, 02:51 PM
  2. How to REALLY hack hotmail
    By gore in forum Microsoft Security Discussions
    Replies: 59
    Last Post: September 19th, 2006, 11:57 AM
  3. Apache, PHP, MySQL with basic security settings.
    By nightcat in forum The Security Tutorials Forum
    Replies: 9
    Last Post: May 28th, 2005, 02:47 AM
  4. OSs / Need feedback
    By gore in forum Operating Systems
    Replies: 13
    Last Post: June 9th, 2004, 02:44 AM
  5. ports
    By hatebreed2000 in forum AntiOnline's General Chit Chat
    Replies: 1
    Last Post: March 14th, 2003, 06:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •