• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 208
  • Last Modified:

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

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?
0
DylanJones1
Asked:
DylanJones1
1 Solution
 
DantheDBACommented:
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.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now