Monthly Archives: March 2021

Modify SQLServr.exe memory

Posted on March 11, 2021 by cottse

A DirSync server hosting Azure AD Sync was hogging memory. Typically Azure AD connect installs an express version of SQL – minus any gui interface. So from an elevated command prompt: SQLCMD -E -S \\.\pipe\Microsoft##WID\tsql\query Then exec sp_configure ‘show advanced … Continue reading →

Posted in server 2019, sql, Uncategorized | Leave a comment