[Script Of Apr. 27] How to get SQL Server buffer pool usage to troubleshoot performance issues

  • Article

image

Apr.

27

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-get-SQL-Server-3fc183d8.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

This T-SQL script is used to get SQL Server buffer pool usage. The script will demonstrate how to get the following information:

System memory usage

Memory usage of the SQL Server process

Total buffer usage of databases

The count of pages loaded for each object in the current database

As some people want to know what the buffer pool resource is used for, we provide this script to show which objects are consuming the memory or buffer pool. The output of this script will be put in four tables for reference.

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery