OS Hang or Out of Memory due to SQL Ser... No Wait, it's SQL Analysis Services (SSAS)
First published on MSDN on Jan 12, 2018 Recently, we have observed a number of cases where DBAs or application developers are complaining about out-of-memory errors or even machine not responding (hangs) despite the fact that there is plenty of available memory on the system.Memory Grants: The mysterious SQL Server memory consumer with Many Names
First published on MSDN on Jan 01, 2013 The Memory Consumer with Many NamesHave you ever wondered what Memory grants are? What about QE Reservations? And Query Execution Memory? Workspace memory? How about Memory Reservations?As with most things in life, complex concepts often reduce to a simple one: all these names refer to the same memory consumer in SQL Server: memory allocated during query execution for Sort and Hash operations (bulk copy and index creation fit into the same category but a lot less common).SQL Server : Large RAM and DB Checkpointing
First published on MSDN on Jun 29, 2017 SQL Server : large RAM and DB Checkpointing Hi everyone,This post’s purpose is to establish a summary of the specific behaviors with relation to DB Checkpoint that may happen within SQL Server when running with a large quantity of allocated memory and when applicable, how to best address them.
SQL Server 2016 crashes
Hey Guys, I am facing really weird issue with MS SQL 2016 crashes. Every so often there is a crash dump generated: SqlDumpExceptionHandler: Process 105 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. This information is very vague so you cannot really determine what is the cause of it. I was playing with the dump file a bit An I got into the module that is causing the crash: ntdll!NtWaitForSingleObject+0x14: 00007ffb`d5255ac4 c3 ret SQL is working the cluster with 4 nodes. Two nodes are in one site and two other nodes are in the second site. Network is working fine. There are no error logs inside the system event viewer or Failover Cluster operational logs. I have noticed that we are running on older version of ODBC drivers which is 17.3.1.1 and the newest one is 17.4.2.1. Do you think this might be related? Regards, WojciechLocked Pages in Memory and User Rights
First published on MSDN on Dec 12, 2012 A colleague had the following question not too long ago Question: Does SQL Server check for “OS permissions” such as Locked Pages In Memory (LPIM) and if so does it use the Windows “macro-style” constants for them – such as SE_VOLUME_MANAGE? The reason I ask is that I’m still wanting to determine “major things” that would break if a particular OS user right is not granted to the account running SQL Server.
