none
Interview Question: What steps you take incase if SQL Server is eating all memory?

    Question

  • Hello All,

     

    Please share some solutions with this question. It was asked to me in interview.

    What steps you take incase if SQL Server is eating all memory?

     

    Thanks in Advance

    Tuesday, November 23, 2010 10:07 PM

Answers

  • None, because this is normal behaviour. SQL Server uses as much memory as it can for caching of data.

    But they probably meant that you can adapt the max server memory setting, which limits the memory use of SQL Server.

    Tom


    Tom Van Zele | Blog | Twitter | LinkedIn
    Tuesday, November 23, 2010 10:14 PM

All replies

  • Check this  The SQL Server Memory Leak Confusion
    Premature optimization is the root of all evil in programming. (c) by Donald Knuth

    Naomi Nosonovsky, Sr. Programmer-Analyst

    My blog
    Tuesday, November 23, 2010 10:14 PM
  • None, because this is normal behaviour. SQL Server uses as much memory as it can for caching of data.

    But they probably meant that you can adapt the max server memory setting, which limits the memory use of SQL Server.

    Tom


    Tom Van Zele | Blog | Twitter | LinkedIn
    Tuesday, November 23, 2010 10:14 PM
  • To handle this issue, goto

    Server properties --> Memory --> Server memory options

    check "Use AWE to allocate memory"

     

    AWE: Address Windowing Extensions

     

    Thanks,

    Bala

    http://sequelqb.blogspot.com/


    Thanks, G Balamurugan
    Thursday, December 02, 2010 5:39 PM
  • What steps you take incase if SQL Server is eating all memory?
    1. Put it on a diet.
    2. Get it to exercise more.
    3. Buy more memory until it gets full and explodes.
    4. Use smaller bits.
    5. Reformat the disk.
    6. Apply a service pack, an ice pack, and fresh batteries.
    7. Move all operations to the cloud.
    8. Call tech support.
    9. Upgrade to 128 bit processors.
    10. Oracle.

    Josh

     

    Friday, December 03, 2010 12:08 AM