Category: Performance

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
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!
December 6, 2017 | Kevin Kline | Performance, T-SQL, Community, Slide Decks 1
Microsoft MVP Kevin Kline and Charles Kim, founder of Viscosity North America talk about SQL Server running on Vmware in Ten Surprising Performance Killers on Microsoft SQL Server on this October 12th
September 19, 2017 | Kevin Kline | Performance, SQL Server, Virtualization 0
Glenn Berry talks about some upcoming AMD processors, which he says may change the server processor landscape.
Adaptive Query Processing in SQL Server 2017.
Get the slides and Transact-SQL demo scripts from my recent presentation at the Baltimore SQL Server user group meeting.
Kevin Kline provides his slides and scripts from his new SQLBits session describing the deep internals exposed by the 86xx series of SQL Server trace flags.
Guest author Derik Hammer dismisses the common myth that table variables perform better than #temp tables because they are always in memory.
Steve Wright explains a hefty set of Advisory Conditions you can add to SentryOne to help you monitor, diagnose, and optimize SSAS...
Find out what new features have been released for the SentryOne Cloud, including a new Performance Dashboard!
March 14, 2017 | Mike Wood | Performance, Cloud, SQL Server, SentryOne 0
Aaron Bertrand begins a new series aimed at debunking common myths about SQL Server performance.
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.
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.
When monitoring SQL Server for performance, you should know which counters matter, and why. MVP Allen White explains 15 common and relevant counters.

Top Categories

See all
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