top of page

SQL memory and update usage

  • Repost - originally posted 12-09-2012
  • Oct 23, 2017
  • 1 min read

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...

 
 
 
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...

 
 
 
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...

 
 
 

Comments


bottom of page