We have the following configuration .
Windows Server 2008 Enterprise SP 2
64 Bit. 32 Gb Ram.
B: Drive 40000 Mb. Used for backup purposes.
C: Drive - OS 20000 Mb.
E: Drive - SQL Server installed on this drive. No page file.
This server runs SQL only. Currently it runs very slowly with the memory usage at a constant 97 %, which is SQL.
What page file configuration would give the best performance?
Any help would be appreciated.