Tag Archives: sql server 2012 performance tuning cookbook

SQLHub News: Interview of Ritesh Shah is published on PACKT website


There is a big difference between writing a book and writing a blog. I understand this when I have started writing a book “SQL Server 2012 Performance Tuning Cookbook”.
SQL Server 2012 Performance Tuning Cookbook

SQL Server 2012 Performance Tuning Cookbook

As soon as PACKT proposed me to write the book on this subject, I have started deciding the topics to cover in this book with my co-author Bihag Thaker. It was a big challenge to decide the content of this book because performance tuning is a big topic and covering all aspects under the one book is little difficult but finally we have managed the book in three following parts.
1.)  Performance Monitoring
2.) Performance Tuning
3.) Performance Management
Each topic covered the practical recipe for hands-on experience of the readers. PACKThas conducted my interview regarding my journey of this book writing process. Further reading the interview, please click here.
Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile
Microsoft SQL Server Blog. Fight the fear of SQL with SQLHub.com. Founder is Ritesh Shah

Implementing physical Database Structure in SQL Server

Our book “SQL Server 2012 Performance Tuning cookbook” is published this week. This book is based on the concept of performance tuning in SQL Server 2012. We have one chapter “Implementing physical Database Structure” in our book “SQL Server 2012 Performance Tuning cookbook”. Following article is completely based on the chapter we have in our book “SQL Server 2012 Performance Tuning cookbook”.
Database structure is one of the important factor which affects performance of your database. Your database performance heavily depends on how you have physically placed your database objects and how you have configured your disk subsystem. Designing the physical layout of your database correctly is the key factor to improve the performance of your database queries and thus the performance of your database. However, the correct decision on a physical design structure of the database depends on the available hardware resources that you might have. This includes the number of processors, RAM, and storage resources, such as how many, disks or RAID controllers you might have in your database environment. The best thing while designing physical layout of the database is to have multiple physical disks for your database. If you configure your database in such a way that it spreads across multiple disks, it can benefit from parallel I/O operations.
The following are some of the decisions that influence your database performance:
  • Where do you place data files?
  • Where do you place log files?
  • Where do you place large objects?
  • Where do you place indexes?
  • Where do you place the tempdb database?
You can control the physical location of database objects within the database by using files and filegroups.
To read complete article kindly click here.
Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile
Microsoft SQL Server Blog. Fight the fear of SQL with SQLHub.com. Founder is Ritesh Shah

350 Article on the blog and SQL Server 2012 book release

I have completed 350 articles on this blog and apart from that my book “SQL Server 2012 Performance Tuning Cookbook” has released yesterday officially.
I would like express my deepest gratitude to all my blog readers and online SQL Server community which always inspire me to work hard and returning back to the community.
In today’s blogpost I am not going to discuss any technical stuff but I would like express my truthful thanks to few person who has always played an important role in my life. Though I have expressed my thankfulness to them in the “Acknowledgement” section of my book, I can’t stop my temptation to express my gratitude blogpost.
I would sincerely like to thank Packt Publishing, for showing their confidence in me and providing the invaluable opportunity of being a part of this book. Individuals at Packt whom I am deeply grateful to, are Kedar Bhat, Sai Gamare, Madhuri Das, Ashwin Shetty, Apoorva Bolar, and Dhwani Devater. They have been very co-operative and supportive at all the stages of this book. I am extremely thankful to Michael Zilberstein (Blog) and Maria Zakourdaev (Blog, Twitter) and Satya (Blog,Twitter) the technical reviewers, for their excellent work of getting the accuracy of the technical details of the book in perfect shape.
I wouldn’t have been able to author this book alone, so thanks should go to Mr. Bihag Thaker, as well, as he agreed to co-author this book with me and has worked even harder on it than I have myself.
Two individuals to whom I am indebted and whose disciple I have always been are Mr. Pinal Dave(Blog, Twitter) and Mr. Jacob Sebastian (Blog, Twitter). I have learnt a lot from them, and they are the reason I’m part of the IT community today.
1.) Pinal Dave, who blogs at SQLAuthority.com and is an author of several SQL Server books. Currently, he is working as a Technology Evangelist at Microsoft.
2.) Jacob Sebastian, who blogs at BeyondRelational.com  and is a SQL Server MVP, book author, well-known speaker in SQL Server technology, and much more.
Without my family support, a task such as writing a book would not have been achievable. I would like to heartily thank my parents, Mr. Ashwinkumar Shah and Mrs. Divya Shah. It is because of them that I exist, and I cherish their blessings, which are always with me. I would also like to thank my one-and-a-half-year-old son, Teerth, who used to often start crying at midnight, because of which I would lose my sleep and, not being able to get it back so started researching more on the subjects that helped me write this book. Last but not least, I would like to thank my wife, Alka Shah!
Finally I would appreciate help and support of all my friends who has directly and indirectly helped me a lot.
Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile
Microsoft SQL Server Blog. Fight the fear of SQL with SQLHub.com. Founder is Ritesh Shah

SQL Server 2012 Performance Tuning Cookbook

We are leaving in the world of data now a day. RDBMS systems make it easy to manage data properly with validations and integrity even it needs expertise to keep database operation smooth so that you can get performance benefit. Everybody hates to wait for receiving information. No matter, whether they are waiting for response from internet, database, report or anything else.
It is a duty of database personnel in the company to make users of the database or software happy by not keeping them waiting for the information they require. In a business world, sometime, late information can create disaster for the company. This is the time when Performance Tuning in database comes into the picture.
SQL Server 2012 Performance Tuning Cookbook
Basically I have started my career as a Developer 10 years back and I used to work mostly with .NET technology for web & windows application. Later on I have shifted my interest towards database technology to maintain performance of my applications as even today, many companies do not afford expert database developer or administrator so they expect that .NET developer manage the show in that situation.
While working with database and performance tuning, I learned a lot by self learning or from the online community. Finally I decided to share my knowledge with the community in proper format. This is the wish which lead me towards writing a performance tuning book name “SQL Server 2012 Performance Tuning Cookbook” which will be available from June 2012..
After thinking to write something about performance tuning, me and my co-author Bihag Thaker had a long discussion about the architecture of the book and we finally decided to divide the book in three main topic.
Performance Monitoring: This supposes to be the first step when you think to tune anything in the database or in SQL Server. Without monitoring, you will not be able find the bottleneck which is creating hazard for performance.
Performance Tuning: Once you find the bottleneck, it is time to overcome that. You have to find different ways to eliminate that bottleneck and make performance faster. We are having many different chapters which are discussing this topic.
Performance Management: “Prevention is better than cure” this is what I believe so it is better to know some common mistakes which may lead to your system towards slow performance. If you know these, you can manage it even before it starts creating an issue for you.
I have always received overwhelming response and welcome from the online community in blog and from the forums I am active in. I am expecting the same response from the community for my book.
Happy Reading!!!
Reference: Ritesh Shah
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of http://www.SQLHub.com
Ask me any SQL Server related question at my “ASK Profile
Microsoft SQL Server Blog. Fight the fear of SQL with SQLHub.com. Founder is Ritesh Shah