Problem:
MSSQL Server consumes high memory due to stored queries in its cache memory (as it is the default behaviour..).
Solution:
The solution to this however very simple:
Just go to services in the "Administrative Tool" then open "Services" (as administrator)
Now just "Restart" "SQL Server (MSSQLSERVER)" service.
There will be a sudden drop in the Memory utilisation on the server.
Note: Sometimes there can come a downtime by this method but it is very minute (approximately for 1-3 seconds).
Here You Go (y) !.
MSSQL Server consumes high memory due to stored queries in its cache memory (as it is the default behaviour..).
Solution:
The solution to this however very simple:
Just go to services in the "Administrative Tool" then open "Services" (as administrator)
Now just "Restart" "SQL Server (MSSQLSERVER)" service.
There will be a sudden drop in the Memory utilisation on the server.
Note: Sometimes there can come a downtime by this method but it is very minute (approximately for 1-3 seconds).
Here You Go (y) !.
It is pretty common for certain information from numerous websites to be kept in the form of cookies and caches while using any browser. Although these cookies and cache do not often affect browsing, it is nevertheless a good idea to erase such data sometimes. It is advised to remove cookies in Google Chrome to prevent any loading or formatting issues. You may now be wondering how to delete cookies and cache on Google Chrome. Here are a few methods that can save your life if you've never cleared your cache or browsing history. Once you take these simple steps, you're done with it.
ReplyDeleteclearing cache on chrome