MSSQL Server Configuration Recommendations

Minimum Requirements.

SQL 2014

Resources:

News you can use... Curious about testing using MSSQL express. We find that in most cases the typical AGRIS database set exceeds the capacity for SQL Server Express.

SQL Server 2014 Express - Limitations: Microsoft SQL Server Express supports 1 physical processor, 1 GB memory, and 10 GB storage.
https://msdn.microsoft.com/en-us/sqlserver2014express.aspx

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?

MSSQL Server Configuration Recommendations

Related articles