santhosh411 (9/3/2013)
Is any issues with performance and if my SQL server is running state and configured SQL with min5GB and Max 6GB and the windows team suddenly decreed OS memory from 7GB to 4GB what will happen to SQL Server.
I already explained how it'll work. After SQL restarts (after the memory removal), it can't reach 5GB so the min server memory will never take effect. If the decrease in memory is permanent, you should go back and change the memory settings, but it'll be no different from a server with the default memory configuration of max server memory being 2000 or so TB.
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