Thursday , November 14 2024

Database-Based Memory Usage Rates in SQL Server

In some cases, we may need to determine the memory rates used by databases. Because some databases using extra memory may be degrading the performance of other databases. For example, a user who wants to generate reports can reduce the performance of critical production database. In this case, we can restrict the user who wants to generate reports with Resource Governor. For more information about resource manager, please read the following article.

“How To Restrict a User’s Resource Usage Using Resource Governor”

When you run the following T-SQL, it will list the database-based Memory usage rates.

 

Loading

About Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *