balasaukri (7/22/2013)
then I found Virtual memory was configured 4 GB only. It was increased to 110 GB.
If you mean the page file, then 4GB is probably fine and 110 probably wastefully high. SQL doesn't use the page file (and if windows forces SQL's memory into the page file, you have a much larger problem).
On a dedicated SQL server, the page file only needs to be large enough for a crash dump, and that's a mini dump or kernel dump, not a full memory one.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability