A server running SBS 2011 is causing me all kinds of headaches. All but 500MB of the 24GB of RAM is in use, mainly for sqlservr.exe. My first idea was to fix the amount of memory SQL could use. But in SQL Server Management Studio, the server can't connect to the database on itself. When the SQL Server Configuration Manager is launched, "Connection to target machine could not be made in a timely fashion." I feel like I'm out of options, every action takes minutes to process because of the low memory.
It's not clear if this database is being used elsewhere in our system so killing it isn't an option. Is there a direct way to limit the memory usage? The underlying problem is likely an authentication issue but I can't solve it when a window takes 5 minutes to load. Thanks for any tips in advance