Oracle and SQL on same server memory contention??? How to fix

Posted on 2007-07-31
Last Modified: 2013-12-18
I had a server running an oracle database. Performance was good. I then installed SQL on the same machine and now performance appears to suffer even when I am not hitting the server hard via SQL.  I notice that I can set Maximium Server Memory via the properties.   What are some of the ramifications relatesd to making such a change and will it be effective in this situation?
Question by:DylanJones1
    LVL 6

    Accepted Solution

    Changing the maximum server memory is often necessary in situations like this because SQL Server will suck up all the memory it can get its hands on and rarely lets it go.

    The downside is if it doesn't have sufficient memory it will begin paging which may increase your I/O. I would recommend lowering it to a reasonable amount in keeping with the expected usage. Then monitor to see if it is affecting the overall server performance with the increased paging and I/O.

    If you have a baseline of the amount of memory being consumed before you installed SQL Server, that would be helpful in determining how much to allow.

    After changing the memory allocation you may have to restart the SQL services to free up the extra memory.
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    >After changing the memory allocation you may have to restart the SQL services to free up the extra memory.
    no. sql server will get down automatically, but not instantly.

    but that setting is the correct one, and for oracle database, you will need to check/configure the same, there you configure the sga.
    the memory for both together will have to be less than the RAM available, you have to consider the os to need also some 200-300MB.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now