Category: Performance

Paul White discusses performance spools, and how they can be used by the optimizer to reduce the estimated cost of nested loops joins.
September 25, 2019 | SQLPerformance.com | Performance 0
Paul White takes a deep-dive look at the internals of batch mode data normalization and how it can affect execution plans and performance.
September 5, 2019 | SQLPerformance.com | Performance 0
Paul White takes a deep dive into SQL Server batch mode bitmaps revealing undocumented details that can greatly impact performance.
August 23, 2019 | SQLPerformance.com | Performance, SQL Server 0
MSPs are smart to choose database solutions, including monitoring tools, that offer the same performance regardless of whether their clients' databases are located on-premises or in the cloud.
Spending too much time determining who and what is at fault for poor database performance? Richard Douglas shares how SentryOne can help you to end the blame game.
In his inaugural SentryOne Community Omnibus post, Kevin Kline shares the latest SentryOne webinars, resources, blogs, and press releases.
Richard Douglas delivers a new blog series designed to help users and evaluators gain greater productivity through the SentryOne data performance management products.
The SentryOne monitoring solution has been reengineered with the latest features & technology available from Microsoft SQL Server to dramatically increase performance for the largest customers while reducing storage and compute needs.
Partner Spotlight: Sarpedon Quality Lab.
Steven Wright digs into some of the new enhancements in the BI Sentry dashboard, which focus on highlighting VertiPaq memory issues in Tabular mode.
Glenn Berry explains how the Spectre/Meltdown issues (and their patches!) may affect SQL Server performance, and provides a handy list of mitigation steps to keep your servers protected.
March 1, 2018 | SQLPerformance.com | Performance 0
Steven Wright explains how to diagnose performance issues in Microsoft APS and Azure Data Warehouse with SentryOne Alerts and lists some custom Advisory Conditions (AC) that many people find useful...
Kevin Kline describes a new Webinar featuring Sabin IO. If you're a DBA who must remedy poor performance on a SQL Server then you'll want to check this out.
Glenn Berry explains several manageability and performance improvements relevant to those of you running SQL Server 2012 and SQL Server 2014.
January 2, 2018 | SQLPerformance.com | Performance 0
Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about.
December 18, 2017 | SQLPerformance.com | Performance, Fragmentation 0
1 2 3 4

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More