Thursday, June 22, 2017
Updates from SQL Server CSS Team @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

You may see “out of user memory quota” message in errorlog when you use In-Memory OLTP feature

Wednesday, June 07, 2017

Recently we got an inquiry from a customer who received the following message in errorlog and wanted to know why. [INFO] HkDatabaseTryAcquireUserMemory(): Database ID: [7]. Out of user memory quota: requested = 131200; available = 74641; quota = 34359738368; operation = 1. This is my first time to see this error.  As usual, I relied...

Unable to issue alter table for a memory optimized tables

Wednesday, May 10, 2017

Recently I assisted on a customer issue where customer wasn’t able to alter a memory optimized table with the following error Msg 41317, Level 16, State 3, Procedure ddl, Line 4 [Batch Start Line 35]A user transaction that accesses memory optimized tables or natively compiled modules cannot access more than one user database or databases...

Memory optimized table variable and cardinality estimate

Wednesday, May 10, 2017

  In a previous blog, I talked about memory optimized table consumes memory until end of the batch.   In this blog, I want to make you aware of cardinality estimate of memory optimized table as we have had customers who called in for clarifications.  By default memory optimized table variable behaves the same way as...

Unable to restore a backup – Msg 3241

Wednesday, April 12, 2017

I worked on an interesting issue today where a user couldn’t restore a backup.   Here is what this customer did: backed up a database from an on-premises server (2008 R2) copied the file to an Azure VM tried to restore the backup on the Azure VM (2008 R2 with exact same build#) But he got...

Why am I getting so many checkpoint files when I have In-Memory OLTP enabled?

Sunday, March 05, 2017

Recently, I looked an In-Memory OLTP issue with Principal Software Engineer Bob Dorr who is still my office neighbor.  After restoring a database that had just one memory optimized table, we dropped the table. Even without any memory optimized tables,number of checkpoint files keep going up every time we issue a checkpoint.  For a while,...

A few new things in XML plan to help you troubleshoot query performance

Tuesday, February 28, 2017

  In this blog Added per-operator level performance stats for Query Processing, Senior PM in QP talks about extending operator level performance stats.  They include stats related to reads, CPU and elapse time.  These are very helpful to track down query performance issues.  We worked on recent case where we put ActualElapsedms in a good...

Be aware of 701 error if you use memory optimized table variable in a loop

Tuesday, February 21, 2017

In blog “Importance of choosing correct bucket count of hash indexes on a memory optimized table”,  I talked about encountering performance issues with incorrect sized bucket count.  I was actually investigating an out of memory issues with the following error. Msg 701, Level 17, State 103, Line 11There is insufficient system memory in resource pool...

Importance of choosing correct bucket count of hash indexes on a memory optimized table

Saturday, February 18, 2017

  I was working with a customer to troubleshoot memory optimized table issues.  In this scenario, our customer uses a memory optimized table variable.  He put 1 million rows of data into the table variable and then process it.  Based on what he said, I tried to come up with a repro to see if...

Solving SQL Connectivity issues: A new guided walk through just got published

Saturday, January 28, 2017

We recently published a new document that provides a one stop shop for solving majority of connectivity issues that you may run into when working with SQL Server. This can be accessed here: Solving Connectivity errors to SQL Server In addition to providing a quick checklist of items that you can go through, the doc...

Pssdiag & Sqldiag Manager update

Wednesday, January 11, 2017

We are releasing a new version of Pssdiag & Sqldiag Manager which supports SQL Server 2016.   It was originally published on But we just moved it to github under Microsoft organization repo. New location is at  In the “Releases” tab, you can download latest binaries.   Go to getting started wiki to learn how...

Copyright [2014] by SQLCOMMUNITY.COM