Tag Archives: administration

Mitigate Issues Early

Posted on November 28, 2018 by way0utwest

This is a great postmortem from Basecamp with a detailed explanation of a problem and how they are hoping to avoid issues with their service. Basecamp is a Software as a Service tool from 37 Signals that had an outage recently. Actually, the service … Continue reading →

Posted in Editorial | Tagged | Comments Off on Mitigate Issues Early

Moving to Query Store

Posted on November 26, 2018 by way0utwest

In SQL Server 2016, Microsoft introduced the Query Data Store (QDS) as a tool that would capture data about the execution of queries inside of your database. This was a project that had been in the works for a number of years, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Moving to Query Store

New Database Options

Posted on November 16, 2018 by way0utwest

I saw recently that Azure SQL Database is getting a few more Database Scoped Options for that platform. These are intended to give more control over the way in which the engine behaves, without requiring each database on a server to function … Continue reading →

Posted in Editorial | Tagged , | Comments Off on New Database Options

Two Types of Performance Counters

Posted on June 11, 2018 by way0utwest

I had an issue where an instance of SQL Server was only showing the XTP (In Memory) performance counters. None of the other SQL Server counters were available, so I followed the procedure I’d written about previously. Once that was … Continue reading →

Posted in Blog | Tagged , | Comments Off on Two Types of Performance Counters