1 Reply Latest reply on Mar 30, 2020 7:00 PM by Pavan kumar

    what is the maximum memory usage for the DB(SQLServer) for PowerCenter

    Shu Yamamoto Active Member

      Hello, PowerCenter Users.

       

      what is the maximum memory usage for the DB(SQLServer) for PowerCenter?

       

      My Informatica Arch is here.

      Informatica Domain Servers { AP1,AP2,AP3 }

      DataBase Server {DB}:

           OS:Win2016

           Memory:16GiB(in Testing environment)

           DB:SQLServer2016:now the maximum memory usage setting is default...

       

      There is no other application inthe DB server.

      Could you please share your knowledge on how much value to set.

       

      Best Regards.

      Shu