After my last post, I was contacted by email about the usefulness of query_hash in actual troubleshooting scenarios since the query_hash value is based on
This spring at SQL Connections, I presented a pre-conference seminar with Kimberly on the new features in SQL Server 2012, including Availability Groups. While on
While working on a chapter I am writing, I was going through the ALTER SERVER CONFIGURATION topic in the Books Online and noticed some really
This topic came up on a forum post recently, and after responding a couple of times to the thread I had to jump into one
In my last blog post, I provided a script that queried the XML for the resource monitor ring buffer entries in sys.dm_os_ring_buffers to identify when
Properly configuring SQL Server is an important factor in having a stable environment that performs well. While there is a lot of good guidance available
I’ve been asked questions about these two features a number of times in the last year where the specific concepts for them have been severely
Traditionally questions about how much memory SQL Server needs were aimed at how to appropriately set the ‘max server memory’ sp_configure option in SQL Server,
While teaching last week at our Tampa Immersion Event, I mentioned the support for SMB as a storage in SQL Server 2012, which is allows
Yesterday I was asked by email about a problem that someone encountered associated with a SQL Server Failover Cluster configuration that I have run into
For the most part I have been relatively quiet about the coming changes in SQL Server 2012 with regards to Extended Events. Primarily this has
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
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.