• Repost - originally posted 12-09-2012

SQL memory and update usage

A clients servers were having performance issues. As part of the background information we were told that the hosting provider had been having troubles with the underlying virtual hosts in their virtual environment but everything was now resolved. When we looked at the servers, there was 32GB of memory allocated to the server. SQL Server memory was set to a minimum of 20GB and a maximum of 28GB. But the whole server was only using 10GB of memory. We decided to do a dbbcc updateusage on all databases on the server. When this was completed the memory usage for SQL Server was now 20GB and increasing as the load on the server increased. We are unsure what happened with the virtual machine, but until the DBCC was run the memory was not being correctly allocated.

Once the memory allocated was back to normal, performance went back to normal levels. Very strange indeed.


Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t