May 25, 2022 at 3:59 am
Hi
How we can check in a Instance which process is consuming more memory.
Can we release memory without re-starting Sql Server
Thanks
May 25, 2022 at 1:36 pm
have a look at "Glenn's SQL Server Diagnostic Queries" ( Diagnostic Information Queries )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
May 25, 2022 at 5:10 pm
Hi
How we can check in a Instance which process is consuming more memory.
Can we release memory without re-starting Sql Server
Thanks
What specifically are you trying to do or solve?
Unless you have set the max memory settings, you will always see 100% CPU usage. SQL Server is designed to use all memory that is available.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply