This blog post is a follow-up blog post on the subject of Instant File Initialization (IFI). I suggest you read the following blog posts before you continuing this blog post. Today we will learn how to Turn On / Enable Instant File Initialization?
SQL SERVER – Observation: ROWLOCK Hint and Slow Performance
During my recent Comprehensive Database Performance Health Check Developer showed me a slow query which used ROWLOCK hint. The common understanding is that with the help of ROWLOCK hint SQL Server only locks a single row which eventually leads to performance but in their case, it was actually very much opposite. Let us see this scenario with a simple example.
Practical Real World Performance Tuning – Class Preparation and Setup
This blog post is a follow-up a blog post in the series of the blog post I am writing for my most popular online class Practical Real World Performance Tuning with Brent Ozar. In this blog post, we will discuss how do I do class preparation and setup.
Practical Real World Performance Tuning – Fun and Reviews
Unless you are staying under the rock, you would be familiar with Practical Real World Performance Tuning course. This is the second part about behind the scene story. You can read my first part here – Practical Real World Performance Tuning – Before the Class Announced. In this part of the blog series let us discuss about the reviews we received for this classes and fun we have during the session.
Practical Real World Performance Tuning – Before the Class Announced
I recently completed delivering Practical Real World Performance Tuning for Brent Ozar Unlimited and it was great 3 days of delivery. Here are my thoughts about my entire experience and how everything worked out. Let us go on the journey to Behind the Scenes for Teaching Online Class.
SQL SERVER – Optimal Value Max Worker Threads
During Comprehensive Database Performance Health Check, one of the DBas asked what is the most optimal value for Max Worker Threads. The question was indeed asked when my customer looked at the value of Max Worker Threads in the Processor sections of the Server Property, they were really worried. The default value of the Max Worker Threads is always set to zero.
SQL SERVER – Performance Comparison IN vs OR
Some questions never get old and some question and I believe we will be discussing them for many more years in the future. Just other days, I received this question during my SQL Server Performance Tuning Practical Workshop. The question was about Performance Comparison IN vs OR. Though personally, I have answered this question quite a many times before, let us answer it once again, it never hurts to repeat the truth multiple times.