Performance Tuning is always the most interesting subject when we talk about software application. While I was recently discussing performance tuning with my friend, we started to talk about the best practices for TempDb. I also pointed my friend to the excellent blog post written by Cindy Gross on the subject: Compilation of SQL Server TempDB IO Best Practices. One of the discussion points was that we should put TempDB on the drive which is always giving better performance.
SQLAuthority News – Win Surprise Gift at TechED 2011 Sessions – Wait Types and Extended Events
A quick note for all – If you are attending my TechEd sessions today here are few notes for you. Session Time Sessions Date: March 25, 2011 Understanding SQL Server Behavioral Pattern – SQL Server Extended Events Date and Time: March 25, 2011 12:00 PM to 01:00 PM SQL Server…
Read MoreSQL SERVER – Tomorrow 2 Sessions on Performance Tuning at TechEd India 2011 – March 25, 2011
Tomorrow is the third day of the TechED India 2011 at Bangalore. I will be speaking on two very interesting sessions. If you are developer, database administrator or just want to learn something new and interesting, I suggest you attend my two sessions tomorrow. Here is the details of the…
Read MoreSQLAuthority News – Solid Quality Journal – Importance of Statistics
My article on “Important of Statistics” has been published in Solid Quality Journal. Statistics are a key part of getting solid performance. In this article we will go over the basics of the statistics and various best practices related to Statistics. We will go over various frequently asked questions like…
Read More
SQL SERVER – Summary of Month – Wait Stats and Wait Type – Day 28 of 28
I am glad to announce that the month of Wait Types, Wait Stats and Queues is very successful. I am glad that it was very well received and there was a great amount of participation from the community.
SQL SERVER – Signal Wait Time Introduction with Simple Example – Wait Type – Day 2 of 28
In this post, let’s delve a bit more in depth regarding wait stats. The very first question: when do the wait stats occur? Here is the simple answer. When SQL Server is executing any task, and if for any reason it has to wait for resources to execute the task,…
Read MoreSQL SERVER – Wait Stats – Wait Types – Wait Queues – Day 0 of 28
This blog post will have running account of the all the blog post I will be doing in this month related to SQL Server Wait Types and Wait Queues. SQL SERVER – Introduction to Wait Stats and Wait Types – Wait Type – Day 1 of 28 SQL SERVER – Signal…
Read More