Category : Performance - SentryOne Team Blog

Category: Performance

Slides and Scripts: Architectural Choices That Impact Performance of Microsoft SQL Server

Want to download the slide deck and T-SQL scripts for the presentation "Architecture Choices that Impact Performance of Microsoft SQL Server?" Get them here!

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.

Adaptive Query Processing in SQL Server 2017

The next release of Microsoft SQL Server, announced as SQL Server 2017, is available for download in CTP2 at http://tinyurl.com/SQLvNextLinux and offers many cool new features. One set of features that I really want to focus on is adaptive query processing. These new features speed processing of workloads, especially those that have historically been the

Slides and Scripts: Baltimore SQL Server User Group

Slides and Scripts: Baltimore SQL Server User Group

Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.

SQL Server Optimizer Secrets With Trace Flag 86xx

SQL Server Optimizer Secrets With Trace Flag 86xx

Kevin Kline (@kekline) provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of trace flags.

Derik Hammer : Myths : Table variables are always in-memory

Derik Hammer : Myths : Table variables are always in-memory

Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.

A new series on performance-related SQL Server myths

A new series on performance-related SQL Server myths

Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.

SQL Server Named 2017 DBMS of the Year

Way back in the summer of 2014, I told you about how I used DB-Engines.com to determine the popularity of various data management tools and vendor platforms. Plus, by adding in an analysis Google Trends I can see where the overall trends that I'm interested in are headed. Staying up with the trends isn't just

The Relativity of Server Health

The Relativity of Server Health

Maintaining a good server health status is critical to your SQL estate performance. Jason Hall discusses why 'healthy' is not a relative measurement.

Image credit clipartsgram.com.

Overview of Columnstore Indexes in SQL Server

Overview of Columnstore Indexes in SQL Server

Melissa Coates provides an overview of in-memory technologies in SQL Server, including columnstore indexes and memory-optimized tables, with an emphasis on columnstore indexes.

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

15 SQL Server Performance Counters to Monitor

15 SQL Server Performance Counters to Monitor

When monitoring SQL Server for performance, you should know which counters matter, and why. MVP Allen White explains 15 common and relevant counters.

Major Feature Reconfiguration For SQL Server 2016 Service Pack 1

One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also true for other lower editions of SQL Server such as Web Edition and Express Edition. But there's big news in the air! READ MORE… Originally

Erin Stellato : Capacity Planning Using Performance Data

Erin Stellato : Capacity Planning Using Performance Data

Erin Stellato (@erinstellato) discusses the types of performance data needed to help with capacity planning.

SQL Server 2016 is Simply Faster… A Lot Faster

I had the pleasure to spend some time with my old friend Mark Souza, a general manager in the Data Platform team at Microsoft, while speaking at the SQL Saturday event in Dublin, Ireland last summer. Now keep in mind that Mark and I have known each other since the 1990s when SQL Server was