Test-sqmMaxMemory - sqmSQLTool PowerShell Cmdlet Documentation

Test-sqmMaxMemory

SQL Config sqmSQLTool v1.8.2+

Checks whether SQL Server Max Server Memory is configured correctly.

Examples

Test-sqmMaxMemory -SqlInstance 'MSSQLSERVER'

Test-sqmMaxMemory -SqlInstance 'MSSQLSERVER'

Test-sqmMaxMemory -SqlInstance 'SQL01\INST01' | Where-Object { Test-sqmMaxMemory - sqmSQLTool PowerShell Cmdlet Documentation

Test-sqmMaxMemory

SQL Config sqmSQLTool v1.8.2+

Checks whether SQL Server Max Server Memory is configured correctly.

.Status -ne 'OK' }

Test-sqmMaxMemory -SqlInstance 'SQL01\INST01' | Where-Object { 


    
    
    

    
    Test-sqmMaxMemory - sqmSQLTool PowerShell Cmdlet Documentation
    
    
    
    

    
    
    
    
    
    
    

    
    
    
    
    

    
    

    


    
        
            🛢 sqmSQLTool
            
                Home /
                Commands /
                Test-sqmMaxMemory
            
        
    

    
        
        
            Test-sqmMaxMemory
            
                SQL Config
                sqmSQLTool v1.8.2+
            
        

        
        
            Checks whether SQL Server Max Server Memory is configured correctly.
        

        
        {{EXAMPLES_HTML}}

        
        
                        
                ← Previous Command
                Test-sqmMaxDop
            
                        
                Next Command →
                Set-sqmConfig
            
        
    

    
        sqmSQLTool Documentation · GitHub · powershelldba.de
        PowerShell SQL Server Administration Toolset by dtcSoftware
    

    


.Status -ne 'OK' }

Get-sqmConfig

Get-sqmConfig

Get-sqmConfig -Key 'OutputPath'

Get-sqmConfig -Key 'OutputPath'