@0:50 - code created to make sql have a problem - high cpu usage @1:16 - code to try & find what process is using high cpu, but found OtherProcess record_id=31 at 38% - which record_id is the high cpu usge running on? - is 5% for SQL a lot of process? @2:31 - code to find high cpu usage in sql, this one found the problem. @3:47 - code use to access history data? - how long must the problem code @0:50 need to be running for it to end up un the cache? - @4:11 - can you explain, what we should be looking for in this table?
Hey can you make a video on query store usage and how to identify regressed queries top cpu consuming queries And how can we use to find blocking information from default extended events
Great stuff. Can you make video for best practices for geography data type and filter that data. I have a latitude and longitude data and I want to filter data based on some range km/mile.
Sir, you have been a troubleshooting master. Please now make videos and write articles for SQL server conceptual part. We also want you to write about azure sql, AWS RDS and managed instances.
Hi Pinal, could you please make a video about why Estimated and Actual number of rows are different even after updating statistics with fullscan? Thank you!
Hi Pinal, always love your content , let's say we have always on and the cpu is high due to parallel redo, what you think we should do . Much appreciate your response 🙏
Hi Pinal. I've noticed that in the Step 1 script the [OtherProcess (%)] field occasionally produces a negative number - e.g. [SQL Process (%)] = 20, [SystemIdle] = 87, [OtherProcess (%)] = -7. Is this an error? Harmless artifact?
Hi, i am running a sp in a cluster, wherein the cluster has 5 nodes. the same sp taking different execution time in all the 5 nodes. In node 1 it takes10 seconds, In node 2 it takes 2 mins. Please share your comment on this case..
Hi @Pinal Dave I have got a question for you 🙂. One of my operation cause the CPU spike, using profiler I could find out that it was some simple select * query which is running multiple times. Question is can doing Select * instead of Select column name could cause cpu spike as well?
I love your content.. please make an complete SQL server DBA and SQL Server performance tuning courses in udemy.... It would be very helpful junior DBAs who just started a career as SQL DBA
Hi Pinal, on your first step1: systemidle shows most over 80% idle. is that mean system is idle and quite some time? . next: record id 46/45 sql processes 5 and 5. do you still think that is performance issue? what is your bench mark to investigate system idle figure values ?
Hi Pinal, I have a problem with high CPU utilization where all query taking time. I checked most of the things but couldn't find anything. Finally when I restored 2 week old database then only queries was running fast. Please suggest.
Hello Pinal, Can you provide some info on SQL Server for ML? I have an env where R services are also using the available memory and see that SQL server releasing memory on OS request.
I have a recurring problem. any time I start my machine afresh[total power start] the sql server service gets stopped. I have to go manually restart it to connect to DB engine. everytime. What's a great automated fix for this? On MSSQL 2019. SSMS version 18.10. Any link/resource out there, demonstrating step by step trouble shooting for this? Meanwhile, do visit my channel, watch Like, Share the videos. SUBSCRIBE.
Do you have any troubleshooting tips to find why an index keep getting corrupted? Everytime this error pops up we have to drop and recreate it to resolve this issue.
@@PinalDaveSQLAuthority here is the exact error message."unable to find index entry in index id 37, of the table 1035879503, in database xxxxxxx. The indicated index is corrupt or there is a problem with the current update plan. Run dbcc or dbcc checktable".
You are really a master in SQL - HANDS DOWN - please keep making such videos it helps out others.
Thank you so much!
Thank you Pinal Dave for keeping ur promise on making video on CPU 100% usage....
My pleasure!
Hi Pianl,
Most helpful and lots people expected this video and the last query.
Glad it was helpful!
Dear Pinal ... tq very much for your help and your video making me shine helping alot to prove our self....
My pleasure
@0:50 - code created to make sql have a problem - high cpu usage
@1:16 - code to try & find what process is using high cpu, but found OtherProcess record_id=31 at 38%
- which record_id is the high cpu usge running on?
- is 5% for SQL a lot of process?
@2:31 - code to find high cpu usage in sql, this one found the problem.
@3:47 - code use to access history data?
- how long must the problem code @0:50 need to be running for it to end up un the cache?
- @4:11 - can you explain, what we should be looking for in this table?
5% is not a lot but that is what my machine was running at that time. High CPU time is what we should look into the tables.
Thank you for the great information. I am following you since I started my IT career.
me too bro ...
Thanks!
Thanks alot Pinal, you're great for share your knowledge with us.
My pleasure!
This is one the problem that we face most of the time. Thanks for sharing such helpful video.
Glad it was helpful!
Thanks Pinal, this one was particularly helpful!
Thanks
Thank you so much Mr. Pinal for such a useful video…
So nice of you
Can you do a video regarding the most common table locking scenarios and common effective methods for solving it.?
good idea
Hey can you make a video on query store usage and how to identify regressed queries top cpu consuming queries
And how can we use to find blocking information from default extended events
Good suggestion.
Hi Pinal, I really like this new format, thanks! 😀
Glad you like it!
Another great video. Thanks Pinal :)
Glad you enjoyed it
Great stuff. Can you make video for best practices for geography data type and filter that data. I have a latitude and longitude data and I want to filter data based on some range km/mile.
Great suggestion!
Really Nice suggestion
you are Great! Thanks with Luv.
You are so welcome
Hi Pinal,
In the third query it should be ordered by total worker time rather than total logical reads. Just an observation.
true.
Thanks Pinal, you are a great guy 👍
Thank you too
Very nice ! Subscribed ! 😁✌🏻
Awesome thank you!
Sir, you have been a troubleshooting master. Please now make videos and write articles for SQL server conceptual part. We also want you to write about azure sql, AWS RDS and managed instances.
yeah we’re greedy for more pertinent material! we need azure sql, managed instance content etc! feed us! 😉
Sure!
Will do my best.
Thanks Pinal, great help!😀
Happy to help!
Thank you sir for sharing your knowledge with us.could you share videos how to troubleshoot queries based on wait type and creating good index
Sure.
Brilliant Hats off
Thanks
Thanks a lot, sir. Can you please make the video for the Memory usage identification
Sure
I have small question, why the .TUF is not created when we configure the logshipping secondary Db in RESTORING mode..
Please answer...
Sorry, this one I do not know.
Thanks for the tips, by the way is it Dangerous Dave that you were playing. Can you please let me know all above scrips valid for AWS RDS ?
Yes scripts are valid.
very helpful, thanks for sharing with us
My pleasure
Can you release a course in Udemy for full sql server? You are amazing in teaching
Ok
Thanks a lot Pinal, some reason second query returns the query itself. Not listing the index query
May be your server is not under load.
great information.! could you provide a video about how to handle tempdb full due to active transaction
Yes I can
Hi Pinal, could you please make a video about why Estimated and Actual number of rows are different even after updating statistics with fullscan?
Thank you!
That is usually the case. It is where you need to fine tune your index for the query. There are few videos on that topic in channel.
Hi Pinal, always love your content , let's say we have always on and the cpu is high due to parallel redo, what you think we should do . Much appreciate your response 🙏
Absolutely
Thanks a lot Pinal👍...
My pleasure 😊
Hi Pinal. I've noticed that in the Step 1 script the [OtherProcess (%)] field occasionally produces a negative number - e.g. [SQL Process (%)] = 20, [SystemIdle] = 87, [OtherProcess (%)] = -7. Is this an error? Harmless artifact?
I believe it is harmless. However, I have not seen it much.
Hi, i am running a sp in a cluster, wherein the cluster has 5 nodes. the same sp taking different execution time in all the 5 nodes. In node 1 it takes10 seconds, In node 2 it takes 2 mins. Please share your comment on this case..
This is difficult to find.
Hi @Pinal Dave I have got a question for you 🙂. One of my operation cause the CPU spike, using profiler I could find out that it was some simple select * query which is running multiple times. Question is can doing Select * instead of Select column name could cause cpu spike as well?
* often uses clustered index or heap.
I love your content.. please make an complete SQL server DBA and SQL Server performance tuning courses in udemy....
It would be very helpful junior DBAs who just started a career as SQL DBA
I have blogs on this topic.
@@PinalDaveSQLAuthority Thanks for ur reply
Hi Pinal, on your first step1: systemidle shows most over 80% idle. is that mean system is idle and quite some time? . next: record id 46/45 sql processes 5 and 5. do you still think that is performance issue? what is your bench mark to investigate system idle figure values ?
This is my demo system and did not had real world load.
@@PinalDaveSQLAuthority Hi Pinal what s your comment when SQL process 95% and systemidle is 0 for last 1 hour
Awesome video
Glad you enjoyed it
Hi Pinal, I have a problem with high CPU utilization where all query taking time. I checked most of the things but couldn't find anything. Finally when I restored 2 week old database then only queries was running fast. Please suggest.
This requires investigation. I am not sure about the answer at this moment.
@@PinalDaveSQLAuthority could you please share some tips to troubleshoot.
Thanks for this
My pleasure!
Explain about max DOP option usage.. pls
I have already created some video on this topic.
Hello Pinal,
Can you provide some info on SQL Server for ML? I have an env where R services are also using the available memory and see that SQL server releasing memory on OS request.
Great topic for the future.
I have a recurring problem.
any time I start my machine afresh[total power start]
the sql server service gets stopped. I have to go manually restart it to connect to DB engine.
everytime.
What's a great automated fix for this? On MSSQL 2019. SSMS version 18.10.
Any link/resource out there, demonstrating step by step trouble shooting for this?
Meanwhile, do visit my channel, watch Like, Share the videos.
SUBSCRIBE.
Do you have any troubleshooting tips to find why an index keep getting corrupted? Everytime this error pops up we have to drop and recreate it to resolve this issue.
What do you mean by index corruption?
@@PinalDaveSQLAuthority Same thing I said when I seen the sql error. I will reply again with the exact error message.
@@PinalDaveSQLAuthority here is the exact error message."unable to find index entry in index id 37, of the table 1035879503, in database xxxxxxx. The indicated index is corrupt or there is a problem with the current update plan. Run dbcc or dbcc checktable".
Pinal are you based in UK, would love to meet you
Meeting on TH-cam
The game is Contra. I lost many hours to that game back in the day.
It was so much!
Sir,
How to Solve CPU utilization ?
You can search at SQLAuthority.com for solutions.
Do you have any course in udemy?
On Pluralsight.
Thanks🙏🏽
Thanks
hi , sql server occupy 80% ram .pls recommend any steps to reduce
Using more memory is good thing
@@PinalDaveSQLAuthority thanks , coz of the server wont crash ?
@@ashokkumarperumal2811 I have never seen it.
@@PinalDaveSQLAuthority ok thank u somuch
Thanks Pinal
You are welcome
Can i run this query to all Databases or only on master???
On master
Can we use resource governor to control CPU?
Sure that means less CPU and eventually less performance.
I used to play contra growing up.
We all did.
Thanks a lot
Most welcome
Is the game Double Dragon?
Not actually.
The game is Contra?
Oh yeah
Very interesting..
Glad you think so!
SQL GURU
Thank you!
Guess about the game. Contra!
True.
Hi Pinal, are you awesome or are you awesome? Jk, you are awesome awesome!
You rock!
Game is Contra😊
Well Said.
Game is Contra :)
Very true.
Game - Contra
agree
Contra
true
Pitfall
Ha ha
Game is contra
Very true.
Good evening sir please suggest any book for performance tunning