In today’s blog posting I want to talk more about the Wait Statistics in SQL Server and how they can help you understand why your SQL Server is currently slow. For me the Wait Statistics are the most important concept in SQL Server when it comes to performance troubleshooting. Why Queries are Waiting Every time …
On May 11th I will deliver a precon about SQL Server 2014 Performance Improvements at the SQLDay Poland conference in Wroclaw/Poland. I have already done intensive work on SQL Server 2014 and helped various customers around Europe to move their workload to SQL Server 2014. In this precon I will talk about the various performance …
Learn about SQL Server 2014 Performance Improvements + read more
Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in SQL Server. Thanks for watching! -Klaus
A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data Structures in SQL Server. Fortunately my 2.5 hour long non-stop session was recorded, and is now finally available at Youtube for watching. Enjoy! -Klaus
During the SQLRally conference in Copenhagen/Denmark, Brent Ozar (Blog, Twitter) and I had a very interesting conversation regarding Statistics on UNIQUEIDENTIFER columns. It seems that SQL Server shows some very nasty behavior here. Let’s have a look. The repro To show you the behavior we have complained about, I created a new database with the …
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
