SQL Server Performance Tuning Made Easy

SQL Server Performance Tuning is still a mystery to many. Quite often even an experienced SQL Server DBA, often gets confused as to how to figure out where to start with this entire process. In this module we are going to learn about how to get started with SQL Server Performance Tuning. We will go over some very important scripts which will help us to get started with the SQL Server Performance Tuning exercise. At the end of the session the author will share his three important scripts which he uses at his customer sites all the time.

Pinal Dave has been a part of the industry for more than eleven years. During his career he has worked both in India and the US, mostly working with SQL Server Technology – right from version 6.5 to its latest form. Pinal has worked on many performance tuning and optimization projects for high transactional systems. He received his Master of Science from the University of Southern California and a Bachelors of Engineering from Gujarat University. Additionally, he holds many Microsoft certificates. He has been a regular speaker at many international events like TechEd, SQL PASS, MSDN, TechNet and countless user groups.

Links to PASS and our Site:

Use our discount code VGDISM843 to save $150.00 off the full price of PASS

[bvbberserk]

Pinal is great as usual, good session.

[marsrocket]

Pro tip: watch this at 2x speed or you’ll fall asleep between the few bits of good information presented

[tapasbehura]

Why more than 1 hour session ... which can be optimise to @30 min

[hiteshl]

Pinal, Need to cut down on talking. Need to present topic else good session.
Thanks

[hiteshl]

Questions:
1. Why Limiting CPU increases Performance?
2. Why Setting States ON increases Performance, Does it not have to do more work to save States in DB?
3. What if View doesn't need DISTINCT rows and needs to add one more COLUMN in VIEW? How Do we solve VIEW Problem now?
Thanks in advance and appreciate any help to answer the above questions.

[nachoci]

Hey removing the Debug button is easy!

[whymizan]

no doubt you are an educated person but please watch the youtube video and try to learn how to present, please. too much trash talk on your video, this is not comedy show

[remyb]

An hour of video to explain something that could have been said in just 10 minutes... In other words, use the latest version of SQL because it's faster and use views the way they are originally designed for. This is not really "tuning made easy"

[arijitroy]

Pinal too much trash talks.... i love ur blogs though..

[gauravjain]

Pinal is irritating. Too much talks and unnecessary drama.

[greendesert]

WTH is up with the accent. I'm deaf, use cochlear implants and it is extremely hard to understand you, I speak a handful of languages, you 're a SQL Server expert, but learning to pronounce english is too complicated?