MSSQL: Whitch database used most memory
With this query, you can see whitch database that is using most memory
Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
With this query, you can see whitch database that is using most memory
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 go sp_configure ‘max server...
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 server memory’, 256 reconfigure...
Sidste kommentar