What is internal memory and external memory?

Can you let me know what is internal and external memories?

more ▼

asked Mar 28, 2011 at 03:00 AM in Default

avatar image

Shyam prasad
132 13 13 17

Please explain where you are seeing these terms.

Mar 28, 2011 at 03:32 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

5 answers: sort voted first

I, like Slick84, am not entirely sure what you mean by internal versus external memory. The closest thing I can think of to internal memory is a cache, which would make all other memory external.

CPUs tend to have a small cache that they work with which is physically internal to the processor die, this is distinct from the main system memory which is located on discrete hardware (normally DIMMs) and accessed by the system bus. Similarly, certain types of storage like harddrives sometimes have a cache to reduce physical accesses to the disk, and many video cards have their own onboard memory.

more ▼

answered Mar 29, 2011 at 08:52 AM

avatar image

15.6k 22 51 38

@Timothy Nice guess work:-)

Mar 29, 2011 at 12:23 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left

Another way of looking at internal vs. external is RAM and DISK.

RAM is "internal" to the system and operates at nanosecond speed.

Drives are "external" and operate at millisecond speed (not counting SSDs in this).

Based on these definitions it is a benefit to perform operations in RAM - the faster medium - but for persistence you require the slower, external "memory".

more ▼

answered Mar 30, 2011 at 05:16 AM

avatar image

12k 30 35 42

I've never heard of them referred to as internal and external memory, but it does make sense in a way.

Mar 30, 2011 at 10:51 AM TimothyAWiseman
(comments are locked)
10|1200 characters needed characters left

Another possibility with internal and external is in the realms of internal and external memory for a process.

This would be where SQL Server has N GB RAM (where N = Installed RAM - O/S Overhead). SQL Server then has access to the "internal" memory of the process, whilst there is still "external" memory out there being used by the O/S and other processes.

The terms internal and external are also used when talking about memory pressure, how an external process is starved of RAM and wants to (re)claim some from other processes. This happens on 32 Bit systems with SQL Server when memory management has not been performed properly.

more ▼

answered Mar 30, 2011 at 06:19 AM

avatar image

26.2k 18 34 48

Just shows... until the OP clarifies what they are after we can pull the IT DEPENDS card.

Mar 30, 2011 at 06:42 AM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

You can check about Memory structure in SQL Server

http://msdn.microsoft.com/en-us/library/ms178067(v=SQL.100).aspx - Link

more ▼

answered Mar 28, 2011 at 12:51 PM

avatar image

basit 1
509 56 65 91

There's something with paranthesis and OSQA that automagically creates links (which are unfortunately broken). I've added a bit.ly-link that works.

Mar 28, 2011 at 01:27 PM Magnus Ahlkvist

Magnus it works with < and >

Mar 29, 2011 at 12:49 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

I'm not sure where you are getting your Internal/External terminology.

However, SQL Server Database Engine is a RAM hungry application. When it's not feeding off of the RAM, its going to the disk.

As common knowledge, its more expensive from a performance perspective to read from your disks (more i/o) than compared to the RAM (Random Access Memory).

On a 64-bit system, my current production SQL server which does 5+ million transactions a day has about 64gigs of ram.

more ▼

answered Mar 28, 2011 at 12:53 PM

avatar image

1.3k 75 104 147

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 28, 2011 at 03:00 AM

Seen: 6202 times

Last Updated: Mar 28, 2011 at 03:00 AM

Copyright 2016 Redgate Software. Privacy Policy