Network performance & speed optimization

I have oracle installed on a Windows Server 2003 R2 which runs in a VM.  Querys are running slowly, so i want to optimize settings that would affect communication between clients and  Database through VM.

How can i monitor the network bandwidth utilization and improve it when the network clients query the oracle server for a recordset etc.

I think the issues are network settings or/and VM settings. Querys that are made localy on the server are very fast.

The server has 2 Xeons, 4 GB RAM, 6x15Krpm RAID10.  

LVL 5
deibelAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arrkerr1024Commented:
Of course I don't need to tell you that oracle products are unsupported under vmware (they are supported only under oracle vm).

That said, do you have vmware tools installed on the guest?

Running oracle in a vm, especially vmware, adds a whole new layer of complexity.  Is the trouble with the network at the guest level, the host level, the drive in-between, or the oracle config its self.

What is your host OS, and what version/product line of vmware are we talking about?

Typically you'd use the normal tools that the OS provides for you... which is pretty limited in win2k3 as far as I know.
0
deibelAuthor Commented:
Guest and host are both windows server 2003 and vmware server runing version 1.0.6.

There is a speed difference between network and guest level. i think there is the point to start - but how? Vmware tools are installed on the guest.

 i do know that vmware server performance is not like esx but the difference can´t be so dramatical. im not talking about  1-2 seconds. sometimes it can be about an half minute between klick and see.

is the oracle vm a real alternative compared to vmware regarding on performance? or is it just "not supported" but it works.
0
DavidSenior Oracle Database AdministratorCommented:
Have you considered turning on either a listener trace on the host, or better, a sqlnet client trace?
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

deibelAuthor Commented:
Ho do i do the trace and how can a check dns speed or test the dns speed?
0
DavidSenior Oracle Database AdministratorCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DavidSenior Oracle Database AdministratorCommented:
May I be of any further assistance?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.