performance
- I'm Speaking at 'Philadelphia Azure DataFest: Advanced Analytics and Big Data Conference' on May 11 (25 Apr 2018 )
- Other MySQL Performance Management Tooling (11 Oct 2015 )
- Introduction to the MySQL Performance Schema (10 Oct 2015 )
- Monitoring Disk Latencies with PerformanceCollector (24 Feb 2015 )
- PerformanceCollector and the Heisenberg Uncertainty Group (24 Apr 2014 )
- PerformanceCollector AddIns (23 Apr 2014 )
- PerformanceCollector.BlockAndWaitMonitor (22 Apr 2014 )
- PerformanceCollector Part 2: How It Works (21 Apr 2014 )
- PerformanceCollector: a performance monitoring tool for SQL Server (18 Apr 2014 )
- Buffer Pool Extensions in SQL 2014 (11 Feb 2014 )
- Just How Expensive is a Bookmark Lookup in a Query Plan (03 Jun 2013 )
- Just How Expensive is a Sort Operator in a Query Plan (02 Jun 2013 )
- They Should Call Them Evil Spools (21 May 2013 )
- SCHEMABINDING Performance Considerations (21 May 2013 )
- Eager Spools in Query Plans and the Halloween Problem (17 Feb 2013 )
- SQL Server: Get the Actual SQL from a Prepared Execution Call (01 Aug 2012 )
- Find Cached Query Plans Containing the Given SQL Text (22 Jul 2012 )
- Buffer Pool Health (16 Jul 2012 )
- IOPS Guidance (06 Jul 2012 )
- Retrieve the Query Plan from the Cache for a Given Stored Procedure (04 Jul 2012 )
- Latency and IOPs (02 Jul 2012 )
- Most Important Missing Indexes (01 Jul 2012 )
- EAGER Spools, Lock Escalations, and Optional Parameters (11 Jul 2011 )
- SOA AntiPatterns for the Data Architect (13 Jun 2011 )
- The Problems with the Missing Index DMVs (09 Jun 2011 )