search

trimble-oss / dba-dash

DBA Dash - SQL Server Monitoring Tool
MIT License
266 stars 63 forks source link

System Memory in Configuration #1131

Open aachaemenes opened 4 hours ago

aachaemenes commented 4 hours ago

Currently DBA dash under configuration for all the servers shows SQL server settings for MAX and MIN memory. The system memory information is captures under hardware info which is great but If I want to see a quick report on how much ram has been assigned to Windows I have to go back and forth between the tabs. It would fantastic if we can see that info there also. Thanks.

DavidWiseman commented 2 hours ago

I think you might already have what you need on the Hardware tab bar the min server memory. The highlighted column is the max server memory & it calculates how much this is as a % of the physical memory and also what is left for the OS in GB.

image

For min server memory - I would just leave this set to the default value unless you have a good reason to change it. link

aachaemenes commented 57 minutes ago

Yes we do but the problem is I have to do back and forth. I have 400 servers. Want to able to see how much ram windows has. We found servers that only had 2 gb ram left and was causing issues.

On Fri, Nov 15, 2024, 8:19 AM David Wiseman @.***> wrote:

I think you might already have what you need on the Hardware tab bar the min server memory. The highlighted column is the max server memory & it calculates how much this is as a % of the physical memory and also what is left for the OS in GB.

image.png (view on web) https://github.com/user-attachments/assets/c09dc946-390e-4e9e-8eb9-e2baaecf0c65

For min server memory - I would just leave this set to the default value unless you have a good reason to change it. link https://dba.stackexchange.com/questions/47640/sql-server-min-server-memory

— Reply to this email directly, view it on GitHub https://github.com/trimble-oss/dba-dash/issues/1131#issuecomment-2479341625, or unsubscribe https://github.com/notifications/unsubscribe-auth/BGN5RX37YLHWVKL4KHZUG7D2AYNJBAVCNFSM6AAAAABR3IWPJSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINZZGM2DCNRSGU . You are receiving this because you authored the thread.Message ID: @.***>