SQL Server Performance Tuning and Query Optimization

[eeda]

really good one.... explained in detail... keep going, , , , most of the people may not comment after watching the video. but, your videos are really very useful for all out there... good job, keep moving.. i will look forward to see so many video from U!!! Thanks.

[suhradtrangadia]

I was reffered lots of videos but not satisfactory, your Tutorial It is very helpful for me, it made my concept clear, thank you sir..

[ashugoel]

Too good !!
I was reading a book on SQL Server performance tuning and tips, but you have explained the whole stuff in just 1 hour. Great. Thanks Kranthi!!

[behenkabhai]

AMAAAZING!! This is the best video on tuning ever! Great explanation and video quality.

[SQLSERVERONLINE]

Hello Everyone,  

I added another new course called  “ SQL Server 2012 : Performance Tuning in Action with 100 million + rows”.




Technical Highlights:

• Analyze performance bottlenecks
• Analyze the SQL query Performance
• Design an effective index strategy
• Database Engine Tuning Advisor
• Analyze Dynamic Management Views (DMVs)
• Analyze Statistics and Fragmentation levels
• Diagnose and avoid blocking and deadlocks
• Analyze execution plans
• Develop efficient queries and stored procedures
• Analyze and Design the effective query to INSERT a large volume of data ( 100  Million + rows)
• Analyze and Design the query to  UPDATE  the large volume of data ( 100  Million + rows)
• Cursor Cost Analysis vs SET based Analysis
• Limitations on MERGE statement
• How to manage and deal with Enterprise Production server issues


Thanks,
Kranthi
Microsoft Certified Professional

[ameerbashasd]

Hi Kranthi Sir,
The way u r explaining is really good.

[chrgbhtt]

Awesome Collection .!! Simply explained. Covers lot of good examples.

[sandeshshinde]

Hi Kranthi Sir, Your videos are really useful...Thanks a ton.

[aschetop]

I found it very useful, good job! Looking forward to see your upcoming videos.

Thanks a lot!

[YousifAshwal]

you've done the best dear Kranthi, looking forward to see your upcoming Vids,

[FrugalHack]

Thank you sir... the way you're explaining is excellent..

[nikhartare]

In no flow of Plan in Cache what is the first block?

[DK-euhp]

it is really good when i am found this video on you tube. it is very use ful

[anuasu]

hey its good, but u should use some sort of pointer or mouse arrow to show which part of slide u r talking about, make the video considering those who has very little knowledge, many time dont know what table or part u r talking, think of UNDERSTANDING EXECUTION PLAN slide, but I appreciate ur work

[rishugarg]

Really nice and knowledgeable Stuff.... 

[rriaz]

Good one. I really like it. I have some suggestions, if you really want others to benefit from your videos then please do not upload videos which are more than 20 min in length. Do not discuss more than 2-3 topics in detail in one video. People have a attention span of 5-10 minutes and then cannot focus on long videos, esp. ttheory subjects.
I suggest, divide this video into subtopics and create a playlist so that everything is in one place. Example, search for koushks on youtube

[aryansena]

U didn't tell abt column stored index and other many types

[bill]

Misleading Title, it's only about "Query Optimization" NOT about PT.

[raghuveera]

Can u post those dmvs queries the resoulution is kind of low to read 
I sincerely appreiciate that
Thanks in advance

[praveennsv]

Your video has good stuff and its good source of learning. I have an advice on your video. I am not sure , why this is happening when i am maximizing the screen the video clarity is coming down and i am not able to see your query clearly that your are running in the window. Can you please take care of this .