2013 July

SQL Server Quickie #7 – TempDb Latch Contention

July 23, 2013 By Klaus Aschenbrenner

(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 7th SQL Server Quickie to YouTube. This time I’m talking about Latch Contention in TempDb.

Like or share to get the source code.

Thanks for watching!

-Klaus

Filed Under: SQLServer, SQLServerQuickie

SQL Server Quickie #6 – THREADPOOL Starvation

July 7, 2013 By Klaus Aschenbrenner

Today I have uploaded the 6th SQL Server Quickie to YouTube. This time I’m talking about THREADPOOL Starvation in SQL Server.

Like or share to get the source code.

Thanks for watching!

-Klaus

Filed Under: SQLServer, SQLServerQuickie

Testimonials

Arun from London, United Kingdom

"My day-to-day writing of SQL has gone up a level – I am able to finely tune individual statements or underlying database objects to get the kind of query plan I want. Moreover I know now what sort of plan I am looking for. I have been already able to use this knowledge to address performance issues that came up this week in capacity testing."

5.0

2015-01-13T15:19:20+00:00

(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.) “My day-to-day writing of SQL has gone up a level – I am able to finely tune individual statements or underlying database View Full →

http://www.sqlpassion.at/archive/testimonials/arun-from-londonunited-kingdom/

Bernd from Monheim, Germany

"After attending the 4 days long workshop you know very exactly how SQL Server executed SQL queries on the logical and physical level through execution plans. In addition you will know how you can improve queries by applying the right indexing strategy. This in-deep knowledge was very well explained and presented by Klaus."

5.0

2015-01-13T15:22:12+00:00

(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.) “After attending the 4 days long workshop you know very exactly how SQL Server executed SQL queries on the logical and physical View Full →

http://www.sqlpassion.at/archive/testimonials/bernd-from-monheimgermany/

Carla from Heverlee, Belgium

"The workshop exceeded my expectations! The complete workshop was well structured, all topics were explained very clear with a lot of excellent prepared and documented demos. I definitely will use the knowledge and documentation that Klaus shared with us during the workshop as starting point and guide for my future work."

5.0

2015-01-13T15:10:40+00:00

(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.) “The workshop exceeded my expectations! The complete workshop was well structured, all topics were explained very clear with a lot of excellent View Full →

http://www.sqlpassion.at/archive/testimonials/carla-from-heverleebelgium/

Roger from Hertogenbosch, Netherlands

"During the workshop I have learned a lot about the query optimizer internals and how I can use that knowledge to write optimal performing queries. Klaus obviously knows a lot about these topics and is able to teach them very well. I can’t wait to attend one of his workshops in the near future."

5.0

2015-01-13T15:28:08+00:00

(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.) “During the workshop I have learned a lot about the query optimizer internals and how I can use that knowledge to write View Full →

http://www.sqlpassion.at/archive/testimonials/roger-from-hertogenboschnetherlands/

Filip from Beerse, Belgium

"This training on SQL Server performance tuning was extremely interesting. Klaus taught me lot of things I was not aware of. I especially loved the tips he gave on common mistakes and wrong concepts about SQL Server. Such information, coming from an independent expert (“expert” is still very understimated when talking about Klaus’ knowledge), is a lot more valuable than spending hours reading and googling. This training has a high return on investment and anyone who is seriously working with SQL Server should attend this workshop."

5.0

2015-01-13T15:13:34+00:00

(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.) “This training on SQL Server performance tuning was extremely interesting. Klaus taught me lot of things I was not aware of. I View Full →

http://www.sqlpassion.at/archive/testimonials/filip-from-beersebelgium/

Wim from Heverlee, Belgium

"The SQL Server Performance Tuning & Troubleshooting Workshop exceeded the high expectations I already had. All the separate bits and pieces of SQL knowledge we gathered through the years, were properly tied together by Klaus. He provided us with all the necessary knowledge to tackle the performance issues we will surely encounter in our day to day business. Highly recommended!"

5.0

2015-01-13T15:08:29+00:00

(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.) “The SQL Server Performance Tuning & Troubleshooting Workshop exceeded the high expectations I already had. All the separate bits and pieces of View Full →

http://www.sqlpassion.at/archive/testimonials/wim-from-heverleebelgium/

Ina from Oberhaching, Germany

"Anyone faced with the task to implement queries on complex ERP data structures – for reporting, providing views, or for statistical analysis – comes quickly to its limits without knowledge of the operation of SQL Server. The workshop provides an excellent insight into the technical world of SQL Server, explained with many examples of queries and their optimization."

5.0

2015-01-13T15:21:05+00:00

(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.) “Anyone faced with the task to implement queries on complex ERP data structures – for reporting, providing views, or for statistical analysis View Full →

http://www.sqlpassion.at/archive/testimonials/ina-from-oberhachinggermany/

Bob from Zoetermeer, Netherlands

"The SQL Server Query Tuning Workshop helped me as a developer to realize how important a good indexing strategy is for a responsive application. In my opinion every developer, working with SQL Server, should know how the indexes are build up, and how the query optimizer is getting to his query plan."

5.0

2015-01-22T12:38:33+00:00

(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.) “The SQL Server Query Tuning Workshop helped me as a developer to realize how important a good indexing strategy is for a View Full →

http://www.sqlpassion.at/archive/testimonials/bob-from-zoetermeer/

Thomas from St. Margrethen, Switzerland

"I was lucky enough to attend the 4 day long SQL Server Query Tuning Workshop from Klaus in Zurich. He has presented in a very easy way the performance related internals of SQL Server that will help you to write better performing SQL queries. Based on that knowledge I finally know now why sometimes queries are fast, and sometimes are slow. It was an amazing workshop, which makes the day-to-day work with SQL Server now very easy."

5.0

2015-01-13T15:23:09+00:00

(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 was lucky enough to attend the 4 day long SQL Server Query Tuning Workshop from Klaus in Zurich. He has presented View Full →

http://www.sqlpassion.at/archive/testimonials/thomas-from-st-margrethenswitzerland/

5.0