Tags » Buffer Pool

TempDB memory leak?

I found a bug where I’m seeing TempDB use more memory than it should on multiple versions of SQL Server, especially on servers set up with common best practices. 1,862 more words

SQL Server

Indexing Strategy

What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced by as many pertinent, well-tuned, consistently written queries as is reasonable. 5,263 more words

SQL Server

Data Compression

Data compression is often misunderstood to cost CPU in exchange for smaller size on disk.  Somewhat true, but that simple explanation ignores other savings that often result in net drop in CPU utilization. 1,158 more words

SQL Server

SQL Server buffer pool

No matter how much memory you put in a system, SQL Server will use all it can get until it’s caching the whole database in memory.  530 more words

SQL Server Memory

Thinking of getting a bigger pool?

SQL Server 2014 introduced us to a number of great new features, one that’s often overlooked but can quite easily improve the performance of read-heavy OLTP workloads, especially on resource constrained hardware, is Buffer Pool Extensions (BPE). 225 more words

Mircosoft

Azure SQL Database Memory Limits By Service Tier

Background

The new service tiers in Azure SQL Database provide different levels of performance, by offering more of the following at each higher service level: 1,584 more words

Azure

MySQL Crashing on Amazon AWS

I run quite a lot of website servers and one particular problem I have been running into over the last few days was our MySQL databases coming in as corrupt. 168 more words

Linux