SQL server 100% CPU usage fix

This issue is very common and commonly faced by DBA, developers and server management team on production server i.e. SQL server leads into 100% CPU usage and also start consuming all available memory. Now most of the time you have seen technical people restarting sql services, or killing long running processes and even restarting complete server, and they can avoid this situation. Before starting any thing I would like to discuss a common myth people have that this is happening because of long running queries only. Which is not all ways true, some times:
Longer running query can be problem
Query having maximum worker time are also problem
Query execution count can also cause problem
For script check below link:
www.techsapphire.in/index/sql_...

[@shiwanginishishulkar4744]

very well explained. Much appreciated.

[@dbalukehuang163]

Hi Techsapphire, This is a really helpful video. Thank you for your sharing!

[@techsapphire]

Thanks for your comment. You can check this video too. It will help you more ua-cam.com/video/mGUR5Sw6T8Y/v-deo.html

[@nidhijain7942]

You have covered very useful information in your video. Thanks!

[@techsapphire]

Thank you for your comment Nidhi.

[@saikarthik3443]

Gud explanation, do u provide online course...nyc info we need more on issues.. pls let me know.. with live project..

[@charandaspatil607]

Thanks for sharing video on cpu utilization goes beyond threshold

[@techsapphire]

Thank you for your comment.

[@Rastyz]

Very helpfull, thank for sharing the knowlegde

[@P5toraskar1986]

Superb explanation. Thank you so much. if you have more notes then please let me know.

[@techsapphire]

Thanks for your comment. You can check this video too. It will help you more ua-cam.com/video/mGUR5Sw6T8Y/v-deo.html

[@madhusudhanguptanamboorisu1722]

Hi,
Thanks for the video, it was very useful.
One observation, narration is bit fast, try to reduce it in future videos.

[@techsapphire]

Hi, thank you for your comment, I will try to improve in future video. I provide private session on performance optimization. If you feel to join, feel free to contact me on my email: [e-mail]

[@Sri3051]

Excellent

[@kanchangupta719]

Very Help full Sir Than You for sharing...

[@techsapphire]

Thank you for your feed back. You can learn query optimization using my lecture ua-cam.com/video/t2R0-xcKw44/v-deo.html

[@satyaranjanrout9733]

Hi this vedio is very useful for me.............thankx for sharing

[@srinivasavula7268]

very good explanation....

[@Anuj78642]

How to read execution plan in correct way. Please create video on step by step using example of stored procedure

[@thummareddy5611]

superb sir

[@pankajkhaspriya6177]

Very well explained.

[@techsapphire]

Glad it was helpful!

[@jinrajinfo]

Very Informative! BUT, it would have been looked more complete if you would have continued with practicals of reducing the CPU usage by applying the solutions you suggested in the Method 2.
Please share the link if you have uploaded the video or suggest me any referral inks. Thank you

[@techsapphire]

Thanks for watching video Jinraj, I am planning to make one video for query optimization. I will share link soon.

[@nagesh969]

Awesome,can we have query optimization video link?

[@rayview2264]

Thanks for the video

[@techsapphire]

Our pleasure!

[@cliffordpatel]

This video helped me!!!!!!!!!!!!!!!!!!!!!!!!!!. Thank you very much

[@techsapphire]

Thanks for your comment. You can check this video too. It will help you more ua-cam.com/video/mGUR5Sw6T8Y/v-deo.html

[@ludhiana6576]

thank you

[@techsapphire]

Thank you for your feed back. You can learn query optimization using my lecture ua-cam.com/video/t2R0-xcKw44/v-deo.html

[@mohamedmydeen601]

What have to do , if query plan return NULL value ?

[@ravikantverma1642]

I like ur video very much.

[@techsapphire]

Thank you so much 😀

[@miketefera8823]

YOUR BLOG GOT SOME MALWARE!!!! but the video is very helpful! thanks very much

[@vikasvyas6427]

nice video

[@happie88]

if you could also upload a video of SQL Server fine tune to resolve slowness and performance issue.

[@techsapphire]

Thanks for your comment. You can check this video too. It will help you more ua-cam.com/video/mGUR5Sw6T8Y/v-deo.html

[@srinidhiramesh4725]

Nice !

[@techsapphire]

Thanks!

[@innominatesoloist1597]

awesome content

[@techsapphire]

Glad you liked it

[@santanuchakraborty5844]

thnx

[@techsapphire]

welcome :)

[@mohammadhoque51]

thank you so much for showing such a practical way

[@kanagavela1060]

I have a issue in my environment..i am seeing execution plans are not being cached for long time more than 5 or 10mins..i feel because of this cpu usage is more..can you comment on this?

[@techsapphire]

Plan getting kicked out is not because of CPU it is usually because of memory pressure. See if memory is getting full or not. Don't use task manager for it use performance counter to get free memory, target memory, etc.

[@johncopper624]

Sir, I like your video. can I contact you any time.

[@techsapphire]

sure u can

[@babymayby9270]

) ok

[@nagaraj920]

I don't think only execution plan or query. Execution count...

[@techsapphire]

Didn't get your point.

[@ansumantiwari7239]

Can you make video for high memory utilization due to sql server

[@techsapphire]

sure

[@JoseDiaz-yu2in]

why are you speaking so fast? it is very hard to understand your english.

[@techsapphire]

Sorry for my speed, trying to improve in new videos. Please check this video, it might help ua-cam.com/video/t2R0-xcKw44/v-deo.html and ua-cam.com/video/mGUR5Sw6T8Y/v-deo.html

[@prajwalkumar8292]

in UA-cam, you can reduce or increase the speed, try to do it.