The MemoryAllocatedToMemory OptimizedObjectsInKB error popped up while I was teaching a workshop. It is a permissions issue, and one command fixes it.
How to List Queries With Memory Grant and Execution Plan? – Interview Question of the Week #154
A workshop customer suspected one of their queries used too much memory. Here is the script I gave them to list running queries with Memory Grant and plan.
Msg 41379: Restore Fails on Insufficient Memory in the Default Resource Pool
Msg 41379 stopped a restore because the default resource pool had insufficient memory for a database with In-Memory OLTP tables. We raised the memory available to the default pool to 90 percent, and the error disappeared.
Optimize for Ad Hoc Workloads: When to Turn It On
Optimize for Ad Hoc Workloads shrinks the memory that one-time queries take in the plan cache. This post builds a demo of single-use plans, measures their share of the cache, and shows how to read the result. It also covers the cost of the setting and why parameterized queries are the better fix.
SQL SERVER – How to Enable Lock Pages in Memory?
Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.
How to Find SQL Server Memory Use by Database and Objects? – Interview Question of the Week #121
Which database uses the most buffer pool? Queries on sys.dm_os_buffer_descriptors to find SQL Server Memory use by database and by object.
SQL SERVER Management Studio – Exception of type ‘System.OutOfMemoryException’ was thrown. (mscorlib)
Copying a huge result set from the SSMS grid threw ‘Exception of type System.OutOfMemoryException was thrown’. Why it happens and a better way to export.