I am getting a performance degradation error in one of my cluster production server. The error is like that
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 608612, committed (KB): 1204128, memory utilization: 50%.
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 619280, committed (KB): 1226552, memory utilization: 50%.
And My working Environment is like that
OS - Microsoft Windows Server 2012 R2 Standard Hardware information - VMware, Inc, VMware Virtual Platform Processors - Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz Installed memory (RAM) - 4 GB
And MS SQL Server version is
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.2 (Build 9200: ) (Hypervisor)
After execution of this TSQL The 'max degree of parallelism' & 'max server memory' is like that
exec sp_configure 'max degree of parallelism'; Name minimum maximum config_value run_value max degree of parallelism 0 32767 1 1 exec sp_configure 'max server memory'; Name minimum maximum config_value run_value max server memory(MB) 128 2147483647 6144 6144
I have also gone through the StackExchange and found a similar question SQL Server R2 Standard Edition MAXDOP setting, but didn't get the proper answer there. That's why I ask the question.
And I am getting this error from yesterday (i.e; 27/12/2015).
Any suggestion will be appreciated.