Memory Configuration RRS feed

  • Question

  • which buffer pool is used by the SSIS and SSRS. SQL Server or OS? What memory configuration required for data ware house(SQL Server 2016)?


    • Edited by Naresh Mali Tuesday, December 3, 2019 5:25 AM
    Tuesday, December 3, 2019 5:24 AM

All replies

  • Not clear what you are looking for? The database engine buffer pool is an internal mechanism which serves every client request, independend of the application, which SSIS and SSRS also are.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, December 3, 2019 7:59 AM
  • There is no "sharing of memory" between these services. So, they will compete for memory. That can be fine, for instance a large SSIS execution requiring memory and SQL server doing a fallback from its max server memory setting. But, as always, it depends.

    Tibor Karaszi, SQL Server MVP (Web Blog)

    Tuesday, December 3, 2019 12:59 PM