Tags » Buffer Pool

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

Database

Examine The Contents Of The Buffer Pool

Examine the current state of the Buffer Pool:

SET ANSI_NULLS, QUOTED_IDENTIFIER ON
GO
-- Get total buffer usage by database
SELECT
CASE WHEN bd.database_id = 32767 THEN 'Resource' ELSE d.name END as DatabaseName…
584 more words

Scripts

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

MySQL Performance Tuning

Five things every DBA must know

1> The Slow Query Log – Learn how to activate the Slow Query Log on MySQL. The Slow Query Log is responsible for keeping track of long running queries with the time it took to run them.   502 more words

Technical

Have you enabled Lock Pages in Memory?

Firstly for those that already know about this feature of Windows, have you enabled this permission to your SQL Server service account? If not why not? 356 more words

DBA

Fixing Page Life Expectancy (PLE)

What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows many database servers, and it’s often something you can fix with tuning and not spending extra money on better disks or more memory. 4,240 more words

SQL Server