Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Klaus Aschenbrenner

Klaus Aschenbrenner provides independent SQL Server Consulting Services across Europe and the US. Klaus works with the .NET Framework and especially with the SQL Server 2005/2008 from the very beginnings. In the years 2004 - 2005 Klaus was entitled with the MVP award from Microsoft for his tremendous support in the .NET Community. Klaus has also written the book Pro SQL Server 2008 Service Broker which was published by Apress in the Summer of 2008. Further information about Klaus you can find on his homepage at http://www.SQLpassion.at. He also twitters at http://twitter.com/Aschenbrenner.

Introduction to Wait Statistics in SQL Server

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…

Read more

0 comments, 45 reads

Posted in Klaus Aschenbrenner on 13 April 2015

Learn about SQL Server 2014 Performance Improvements

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… Read more

0 comments, 38 reads

Posted in Klaus Aschenbrenner on 9 April 2015

SQL Server Quickie #23 – Plan Cache Pollution

Today I have uploaded the 23th SQL Server Quickie to YouTube. This time I’m talking about Plan Cache Pollution in SQL Server.

[viral-lock message=”Like or share to get the source code.” tweet=”SQL Server Quickie #23 – Plan Cache Pollution by @Aschenbrenner:” url=”http://www.SQLpassion.at/archive/2015/04/07/sql-server-quickie-23-plan-cache-pollution”]You can find the script used during the demonstration… Read more

0 comments, 27 reads

Posted in Klaus Aschenbrenner on 7 April 2015

Latches, Spinlocks & Lock-Free Data Structures Recording

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

Read more

3 comments, 31 reads

Posted in Klaus Aschenbrenner on 30 March 2015

Statistics on UNIQUEIDENTIFIER columns

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… Read more

6 comments, 30 reads

Posted in Klaus Aschenbrenner on 16 March 2015

Why I don’t (yet) recommend In-Memory OLTP to my customers

Ok, some of you will hate me after this blog posting, but it has to be said. Over the last months I have done a lot of work in the area of In-Memory OLTP, and I also had a lot of customer requests regarding this amazing new technology. Unfortunately none… Read more

10 comments, 29 reads

Posted in Klaus Aschenbrenner on 11 March 2015

Transaction Logging in In-Memory OLTP (Hekaton)

In today’s blog posting I want to talk in more detail about how In-Memory OLTP logs transaction log records into the transaction log. As you might know, In-Memory OLTP offers you 2 durability options for your Memory Optimized Tables:

  • SCHEMA_ONLY
  • SCHEMA_AND_DATA

I don’t want to talk more about SCHEMA_ONLY Read more

0 comments, 27 reads

Posted in Klaus Aschenbrenner on 9 March 2015

In-Memory OLTP & Deadlocking – my SQLBits sessions

After speaking at the SQLRally conference in Copenhagen earlier this week, my next stop was at the SQLBits conference in London, where I have presented 2 sessions:

  • In-Memory OLTP
  • Deadlocking

As promised at the end of both sessions, you can download the slides & samples for your further reference.

If… Read more

0 comments, 22 reads

Posted in Klaus Aschenbrenner on 7 March 2015

Latches, Spinlocks & Lock-Free Data Structures – my SQLRally Nordic session

Whew, this was an intensive session about Latches, Spinlocks & Lock-Free Data Structures at the SQLRally Nordic conference in Copenhagen. I hope you have enjoyed this session as much as I have enjoyed it to present it in front of a fully packed room – with an engaging audience

As… Read more

2 comments, 25 reads

Posted in Klaus Aschenbrenner on 4 March 2015

SQL Server Quickie #22 – The Buffer Pool

Today I have uploaded the 22th SQL Server Quickie to YouTube. This time I’m talking about the Buffer Pool in SQL Server.

[viral-lock message=”Like or share to get the source code.” tweet=”SQL Server Quickie #22 – The Buffer Pool by @Aschenbrenner:” url=”http://www.SQLpassion.at/archive/2015/03/02/sql-server-quickie-22-buffer-pool”]You can find the script used during the demonstration… Read more

2 comments, 36 reads

Posted in Klaus Aschenbrenner on 2 March 2015

Why do we need UPDATE Locks in SQL Server?

(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.)

Today I want to talk about a specific question that I almost get every time when I… Read more

6 comments, 9,547 reads

Posted in Klaus Aschenbrenner on 28 July 2014

SQLBits recap

(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.)

Wow, what an intensive last week! Last week I attended the SQLBits conference in Telford/UK – in… Read more

0 comments, 302 reads

Posted in Klaus Aschenbrenner on 22 July 2014

My upcoming speaking schedule

(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.)

Over the next weeks and months I have an incredible speaking schedule around the whole world. You… Read more

0 comments, 320 reads

Posted in Klaus Aschenbrenner on 14 July 2014

SQL Server Quickie #15 – Merge Join Operator

(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.)

Today I have uploaded the 14th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 388 reads

Posted in Klaus Aschenbrenner on 7 July 2014

Introduction to Spinlocks in SQL Server

(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.)

In last weeks blog posting I have talked about Latches in SQL Server. At the end I… Read more

2 comments, 955 reads

Posted in Klaus Aschenbrenner on 30 June 2014

Introduction to Latches in SQL Server

(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.)

In today’s blog posting I want to talk about a more advanced, low-level synchronization object used by… Read more

0 comments, 864 reads

Posted in Klaus Aschenbrenner on 23 June 2014

SQL Server Performance Tuning & Troubleshooting Workshop in Antwerpen/Belgium

(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.)

I’m very happy to announce today that I also run my famous SQL Server Performance Tuning &… Read more

0 comments, 480 reads

Posted in Klaus Aschenbrenner on 19 June 2014

Configuring the In-Memory OLTP File Group for High Performance

(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.)

In todays’ blog posting I want to talk about the memory optimized file group used by In-Memory… Read more

6 comments, 1,163 reads

Posted in Klaus Aschenbrenner on 16 June 2014

Announcing the SQL Server Query Tuning Workshop

(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.)

Today I’m very happy and proud to announce my brand new SQL Server Query Tuning Workshop that… Read more

0 comments, 797 reads

Posted in Klaus Aschenbrenner on 9 June 2014

SQL Server Quickie #14 – The Tipping Point

(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.)

Today I have uploaded the 14th SQL Server Quickie to YouTube. This time I’m talking about the… Read more

0 comments, 486 reads

Posted in Klaus Aschenbrenner on 2 June 2014

Older posts