How do I improve performance by dedicating database memory for MSSQL?

NOTE: 

The contents of this page have been incorporated into a more comprehensive page at https://culturatech.atlassian.net/wiki/x/AQAXJQ.  Please use that page.

Problem

MSSQL is not running as fast as it should...  Where should I look?  

Solution

Check your Database properties in Microsoft SQL Server Management Studio.

Size = current size that the MSSQL database is holding. 

Space available = Should be set to consider a standard "reserved" area to not require MSSQL to continually increase the database size. 

Your memory available for a MSSQL server should always be Total ram - 4GB for OS operations as a guideline. 

• Page:
  MSSQL Server and Client Configuration Recommendations and Requirements
• Page:
  How to remove MSSQL records associated with a failed dataset migration or dataset copy - Generate Delete Data from All Tables by TenantID
• Page:
  MSSQL How To find the active connections to the database. (system or users)
• Page:
  MSSQL Transaction Timeout and Rollback
• Page:
  MSSQL Maximum server memory setting - How do I determine if MSSQL is using too much memory or storage space?