We wanted to change the memory setting for a SQL Server Instance on a particular server. The settings for the way our SQL Server 2008 Instance uses memory was set to minimum 0 to maximum 10GB so we changed it to minimum 5GB to maximum 10GB. When the Sys Admin monitored this server after making the change it was not using minimum 5GB. We did not restart the SQL Server 2008 services or reboot the server after making the SQL Server 2008 memory change. Why isn't grabbing and holding the minimum of 5GB?
how are you checking the memory usage?
this is an accurate code to check it:
(sum(multi_pages_kb) +sum(single_pages_kb)+ sum(virtual_memory_committed_kb) + sum(virtual_memory_reserved_kb)+sum(awe_allocated_kb)
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…