Question, will you be running other services on the server, i.e. SSIS,SSRS,SSAS etc.?

😎

With 160Gb memory on the server, I would suggest to set the SQL Server Max Memory to 128Gb /131072 Mb and monitor both the SQL Server and the OS for memory related pressure.

For fun, here is an easy way of converting between units

DECLARE @SIZE_IN_BYTES NUMERIC(38,6) = 137438953472.0;

SELECT

'BYTES' AS SCALE

,@SIZE_IN_BYTES AS SIZE

UNION ALL

SELECT

'KILOBYTES'

,@SIZE_IN_BYTES / POWER(2.0,10)

UNION ALL

SELECT

'MEGABYTES'

,@SIZE_IN_BYTES / POWER(2.0,20)

UNION ALL

SELECT

'GIGABYTES'

,@SIZE_IN_BYTES / POWER(2.0,30)

UNION ALL

SELECT

'TERABYTES'

,@SIZE_IN_BYTES / POWER(2.0,40)

Output

SCALE SIZE

--------- --------------------

BYTES 137438953472.000000

KILOBYTES 134217728.000000

MEGABYTES 131072.000000

GIGABYTES 128.000000

TERABYTES 0.125000