You have contacted Customer Support to review performance issues and no issues with the program can be found.īecause Microsoft SQL is not a LexisNexis product we do not make any specific recommendations regarding which edition to use.

You have reviewed and implemented the Juris Workstation Connectivity.

Potential performance issues increase directly with the number of users, particularly if the users are very active. If you are experiencing performance issues with your LexisNexis ® Practice Management software, upgrading to a full version of Microsoft SQL may help, provided you meet the below criteria: However, the further you move above and beyond the below guidelines, the more likely that you will encounter the limitations of the free version of Microsoft SQL Express. Upgrading to a full version of Microsoft SQL is not guaranteed to improve your performance and is not required for Juris ®. These limitations are not present in the full version of SQL available for purchase from Microsoft, as documented on the SQL Server Editions web page.

For example, SQL Express 2014 is limited to a 10 GB database, can only use up to four cores of one physical processor, and most importantly, can only use 1 GB of RAM regardless of the installed memory available.

Microsoft SQL Express, as a free product, has limitations that can cause performance scaling issues as the amount of traffic increases.

Sql server express 2014