How much page file you need is tricky. It is not only for storing stuff that gets kicked out of RAM but it also determines how much Virtual Memory Windows has. Virtual Memory usage can be really high even for processes which use relatively small amounts of actual memory.
I would not recommend turning off the page file. There are some things that make use of the page file outside of the normal memory related uses. Memory dumps during blue screens are done to the page file, for example.
There is an elegant solution to this problem though. Windows allows you to set a custom range for the page file. You can set the initial size as something small, like 512MB, and the max size to 8193MB. This way the page file will start out at 512MB, and remain at 512MB, unless Windows needs more. If Windows needs more it will grow the page file as needed, up to the limit of 8193MB. The page file will be reset back to 512MB next time you reboot.
Growing of the page file does cause it to be fragmented. This could cause performance problem on a hard drive, but with an SSD it is not a problem.