I have an SQL server that is a VM (running in Vsphere) and has 8GB allocated to a database instance. We sometimes encounter performance issues in an application that has databases withing this instance and we want to find out if there are any memory bottlenecks / if we need to look at increasing the memory allocated to the DB instance.
I have run the DBCC memory status command and have attached a screenshot of the results (Main results at the top, there are more figures when I scroll down so I can see if there is a way to export the data if need be) but i'm not sure what the results determine. Please can you point me in the right direction in terms of which column names? & figures to check?