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 →

How to fix System.OutOfMemoryException when using SSMS

Question: When executing a statement through SSMS returning a large recordset , I’m getting a System.OutOfMemoryException error. The error occurs before the recordset fully returns. Why is this error occurring and what is the workaround? I’m using SQL Server 2012 Enterprise Edition . On a 64 bit Windows 2008 server. The full error message is : An error occurred while executing batch. Error message is: Exception of type 'System.OutOfMemoryException' was thrown. Answer: SSMS is a 32 bit process. It is limited to 2GB memory.When using Grid Mode there is a 64 kb limit per database field. If the resultset is... Read more →