MSSQL: Whitch database used most memory
admin With this query, you can see whitch database that is using most memory
memory
Limit SQL Server maximum memory SQL instance
Start SQL Server Management Studio Connect to you SQL server instance Start a “New Query” And then put this into you SQLQuery1.sql window sp_configure ‘show advanced options’,1 reconfigure with override…
Limit SQL Server maximum memory SQL of WSUS
Start SQL Server Management Studio Connect to \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query Start a “New Query” And then put this into you SQLQuery1.sql window sp_configure ‘show advanced options’,1 reconfigure with override go sp_configure ‘max…