Last week I blogged about Implicit Conversions that cause Index Scans, and showed two charts for where implicit conversions could result in an index scan operation instead of an index seek during query execution. As a part of writing that blog post I thought it would be interesting to also look at the performance overhead [...]
Jonathan Kehayias
The Rambling DBA
New Article – How expensive are column-side Implicit Conversions?
Posted on: April 15, 2013 5:20 pm
New Article: Performance Problems with SQL Server 2012 Enterprise Edition Under CAL Licensing
Posted on: November 28, 2012 10:51 am
My latest article on SQLPerformance.com was published yesterday and highlights the potential for performance problems while using the default configuration of SQL Server 2012 using the Enterprise Server+CAL upgrade licensing under Software Assurance. http://www.sqlperformance.com/2012/11/system-configuration/2012-cal-problems
New Article: Tracking Database File AutoGrowth with Event Notifications
Posted on: November 6, 2012 4:00 pm
My latest article on SQL Server Central was published live today. This article shows how to use Event Notifications to monitor and alert on database file auto growth events inside of SQL Server and is another edition to the series I committed to writing on using Event Notifications in SQL Server to automate common DBA [...]
New Article on SQLPerformance.com comparing “Observer Overhead” of Trace vs Extended Events
Posted on: October 24, 2012 12:20 pm
I have been so busy this week that I didn’t get a chance to blog about this yesterday when it happened, but I had a new article published on SQLPerformance.com that compares the performance impact or "observer overhead" of using SQL Trace and Extended Events. I had a lot of fun running different benchmarks for [...]
New Article on Tracking Tempdb Contention in SQL Server 2012 with Extended Events
Posted on: July 12, 2012 11:37 pm
My latest article on Simple-Talk was published recently. In this article I dig into how to track allocation bitmap contention in tempdb in SQL Server 2012 using Extended Events. The method described in this article redefines how you troubleshoot this type of problem, leveraging the advanced diagnostic capabilities of Extended Events to track the problem. [...]
New Article Online – Great SQL Server Debates: Buffer Cache Hit Ratio
Posted on: January 19, 2012 4:28 pm
My latest article on Simple-Talk was published this morning. In this article I dig into the actual meaning of one of the performance counters I often see mentioned on the forums, but in a completely incorrect context. Great SQL Server Debates: Buffer Cache Hit Ratio
New Article Online – Great SQL Server Debates: Lock Pages in Memory
Posted on: December 14, 2011 8:36 am
After a recent discussion about Lock Pages in Memory on Twitter, I wrote an article that talks about the history of Lock Pages in Memory and the differing opinions on the appropriate usage of Lock Pages in Memory for 64 bit instances of SQL Server. Great SQL Server Debates: Lock Pages in Memory Thanks to [...]
