I get asked this question over and over again: “I have a SQL Server that is performing badly. How can I find the worst performing queries?”. So in today’s blog posting I want to give you some information and guidance that will let you answer this question very easily. Ask SQL Server! The nice thing …
How to find your worst performing SQL Server queries + read more
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
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.
