We allocated 1 GB fixed memory to SQL Server out of 2 GB (Physical Memory). However on startup SQL Server does not show all the allocated memory. It shows approximately 20 MB out of 1 GB allocated. Memory starts to climb with use but does not approach the allocated level.

We are running SQL Server 7.0 with SP 2.0 on Windows NT 4.0 with SP6. Hardware is Compaq (4 way) Quad Processor.

Is this normal SQL behavior or should it show the whole allocation of 1 GB on startup?

Thanks!
Kumar.