Follow

SQL Configuration and Performance Guide

Trent Upchurch

Enterprise PDM: SQL Server Configuration Guide

TITLE:

Guide to Configuring SQL server for reliability and performance

DATE:

6/2015

SUBJECT:

SQL Server software and Hardware configuration

ABSTRACT:

Overview of SQL components and best practices for their setup

 

The proper configuration of a SQL server is central to obtaining the best performance of EPDM. This guide is meant to give a general overview of SQL components and how best to setup a SQL server’s hardware and software. For the general configuration of SQL server for compatibility with SolidWorks Enterprise PDM please see the Enterprise PDM installation guide – link at the end of this document.

This guide will focus on RAM and disk configuration to optimize SQL server. The recommendations contained here are based on information provided by SolidWorks and customer experience.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments