Category : System Configuration - SentryOne Team Blog

Category: System Configuration

Glenn Berry : AMD's new CPUs may challenge Intel again

Glenn Berry : AMD's new CPUs may challenge Intel again

Glenn Berry talks about some upcoming AMD processors, which he says may change the server processor landscape.

Glenn Berry : Intel Xeon Scalable Processors and SQL Server 2017

Glenn Berry : Intel Xeon Scalable Processors and SQL Server 2017

Glenn Berry of SQLskills walks through the next iteration of Intel Xeon processors, and how they suit SQL Server 2017.

Glenn Berry : Choosing a Processor for SQL Server 2016 Standard Edition

Glenn Berry : Choosing a Processor for SQL Server 2016 Standard Edition

Glenn Berry (@GlennAlanBerry) explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.

Introducing the SQL Server Database Experimentation Assistant

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server. READ MORE… Originally Posted February 08, 2017

Make Life Easier Using the Environment Health Overview

Make Life Easier Using the Environment Health Overview

The Environment Health Overview health score indicates the overall health of your entire environment; Jason Hall (@SQLSaurus) explains how to use it to make work easier.

Glenn Berry : Memory/Storage Technology Hierarchy and SQL Server

Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers.

Configuring a PolyBase Cluster

David Benoit (@SQLTentMaker) walks through the process of configuring a scale-out PolyBase cluster with SQL Server 2016 and Azure Blob Storage.

Glenn Berry : Storage Spaces Direct for SQL Server

Glenn Berry (@GlennAlanBerry) discusses a new feature in Windows Server 2016, Storage Spaces Direct, and how SQL Server will benefit.

SQL Server 2016 : Getting tempdb a little more right

Aaron Bertrand (@AaronBertrand) explains how SQL Server 2016 improves tempdb configuration and performance, and how there is still room for improvement.

Glenn Berry : Practical Processor Selection for OLTP Workloads

Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.

Enabling "super admin" on Windows 10

Aaron Bertrand (@AaronBertrand) explains how he worked around a recent problem with Windows 10 and its not-so-administrator administrator account.

Tim Radney : SQL Server 2016 – Introduction to Stretch Database

Tim Radney (@tradney) walks through the configuration of a new SQL Server 2016 feature, Stretch Database, and discusses some of its limitations.

DBTA – StretchDB, a Cool New Feature in vNext SQL Server

Originally appearing in my monthly column at Database Trends & Applications magazine. When it comes to cloud-based database management, there are really only two players: Amazon, the value leader, and Microsoft, the innovation leader. Amazon has carved out a niche as the value leader in cloud-based database management, supporting not only its own implementations of

Glenn Berry : Using Microsoft DiskSpd to Test Your Storage Subsystem

Glenn Berry gives a thorough guide on using DiskSpd, a command-line tool that measures the performance characteristics of your storage subsystem.

What I mess up whenever I install SQL Server on a new VM

Aaron Bertrand (@AaronBertrand) talks about two things that force him to stop in his tracks when he tries to install SQL Server on a new VM.