Greetings -

I am managing a server which runs one large database, over 130 GB, I am getting a lot of IO wait time related to templog and data files wait time. The tempdb size is set to 9.75 MB. We are also getting buffer related errors. The vendor blames on not having the meomry size set correctly on the server. The current mem size is set to defualt (min:0 - Max: 2147483647 MB). Do you have any recommendation to how we need to setup the memory? Please advise.

Thanks,
Lava