SQL Server Performance

sqlservr.exe memory usage

Discussion in 'Performance Tuning for DBAs' started by marcgale@yahoo.com, Jan 15, 2003.

  1. marcgale@yahoo.com New Member

    While running a large query, the memory used by sqlservr.exe blossoms to include almost all of the machines RAM. The query finishes, but the memory used by sqlservr.exe does not decrease. How does one convince sql server to give it back?
  2. Chappy New Member

    You dont <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br />Subsequent sql operations will reuse the now allocated memory within sql server.<br />If the memory is needed by other processes (ie, not sql server), you ought to consider limiting the maximum amount of memory sql server is permitted to reserve for itself (see server properties in EM)
  3. bradmcgehee New Member

    If your SQL Server is a dedicated server, and if memory is set to dynamic (the default), I wouldn't worry about this. And even if you have another app running on the same server, if memory is set to dynamic, and the other app needs more memory, SQL Server will give it up, but only if has to, and if it doesn't need it. If you need to allocate specific memory to another app, then you may have to manually prevent SQL Server from using all the available RAM. But again, if SQL Server wants this memory, and you don't allow SQL Server to take it, this SQL Server's performance may suffer.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

Share This Page