I enjoyed watching this video and recommend to others Host explains the content very clearly and looks knowledgeable. Thanks for educating the community and appreciate your volunteership. Thanks a lot
Hi, My server hits cpu nearly 100%, Even i'm not able to login to the server, So for this situation how can i run all these things what you showing in you video. but at that situation i know we have one option called DAC connection. My question is can i run all these stuffs in DAC connection....????
There could be multiple reasons - check following - SQL server memory setup, how much it is using and asks during different load tines ( committed, committed target(this one it is asking) ) - check indexes needs as well as fragmentation if its too high you need to see if your rebuild and reorganize is actually taking place - check I/o read and write, see SQL server is waiting to write or taking longer to read - frequent tour to read data from disk isn’t really good that means it is not keeping enough pages in memory ( indicates memory is low) if your PLE is too low, you are hurting for memory - now finally check deadlocks and block
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
I enjoyed watching this video and recommend to others
Host explains the content very clearly and looks knowledgeable.
Thanks for educating the community and appreciate your volunteership.
Thanks a lot
Thank you, I have learned so much from your videos.
you are very welcome. Thanks for support.
Aamir thank you so much for educating us.
Kind Regards
can u share a query in sql server to get cpu percentage
Hi,
My server hits cpu nearly 100%, Even i'm not able to login to the server, So for this situation how can i run all these things what you showing in you video. but at that situation i know we have one option called DAC connection.
My question is can i run all these stuffs in DAC connection....????
Our sql server usage increased at all time.. its not decreased. And finally server going to hang.. please reply me if u know what is the resone??
There could be multiple reasons - check following - SQL server memory setup, how much it is using and asks during different load tines ( committed, committed target(this one it is asking) ) - check indexes needs as well as fragmentation if its too high you need to see if your rebuild and reorganize is actually taking place - check I/o read and write, see SQL server is waiting to write or taking longer to read - frequent tour to read data from disk isn’t really good that means it is not keeping enough pages in memory ( indicates memory is low) if your PLE is too low, you are hurting for memory - now finally check deadlocks and block
Thnqqq