Does SQL Server require a restart after memory change

Question: I’d like to increase the memory allocated to our SQL Server instances. Once the ‘maximum server memory…’ is increased, are there any SQL services which should be restarted? Answer:-You don’t need to restart SQL Server, adjusting SQL Server’s Max Server memory is an online option . When you do make the change,you’ll highly likely cause data or procs to leave their caches so queries could be slower for a short while after you run it. If your environment is sensitive to performance consider making this change in a non production window. Ensure you leave enough memory on host for... Read more →

Attempted to read or write protected memory.This is often an indication that other memory is corrupt

Question: When attempting to open a table via SSMS 2012 – through the Edit top 200 rows , I get the Exception has been thrown by the target of an invocation , Attempted to read or write protected memory.This is often an indication that other memory is corrupt error message How can I fix? Answer: There are a number of potential fixes to this problem 1)Is the SSMs the correct version? In other words is the SSMS a lower version from the target SQL Server? For example – are you attempting to connect to SQL Server 2016 from a SSMS... Read more →

Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped.

Someone sent me a request to diagnose the error message : Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. A close inspection of the error logs revealed some relate messages. Most importantly There was insufficient memory to run this query Observations: Max Memory not set. It was set with no limit . This means it was competing with OS memory requirements One of the nice features of SQL Server when there is extreme memory pressure is a good level of detail in... Read more →

Chinese build the most powerful computer in the world

Cyber superstardom and the great super power race is on! 93 petaflop Sunway TaihuLight 93,000 trillion calculations per second. 1.31 PB of primary memory Advanced manufacturing, weather forecasting ,Life Sciences & big data analytics 10.5 million locally-made processing cores and 40,960 nodes , running on a Linux-based operating system. As a computer scientist , this must be an amazing challenge to write software which can exploit the capacity. Read a very interesting technical paper written by Jack Dongarra Related articles Find Table Scans in Query Plan Cache Memory grants and execution plans How to find CurrentClockSpeed and MaxClockSpeed using Powershell... Read more →

SQL Memory usage query and cachestore_sqlcp

Question: There was SQL Server memory issue with the Error 701 There is insufficient system memory in resource pool 'internal' to run this query. How can I troubleshoot the source of the error and complete some root cause analysis? Answer: These out of memory errors can be tricky to nail , but there are some basics you can cover to start building a profile on the problem. This sql server message usage query taps into the sys.dm_os_memory_clerks which Returns the set of all memory clerks that are currently active in the instance of SQL Server. SELECT TOP(5) osmc.[type] AS [Memory... Read more →