cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

MS SQL Recomendation

jtilipman
13-Aquamarine

MS SQL Recomendation

Did anybody has any configuration/tuning recomendation for the MS SQL server?
2 REPLIES 2

Jerry:

We have done a few. I can check into it for you.

DF

For starters, you should locate the data file for the tempdb on your fastest disk, and separate the windchill database data and transaction log files to separate disks for better I/O. Unfortunately the PSI and SCUputs these latter two in one directory with no option to relocate during initial installation, so you'll need to move them afterwards using scripts (see http://support.microsoft.com/kb/224071).

The tempdb is very important for performance, and it is recreated every time you restart the server. You should set the initial size of the tempdb to match whatever size it grows to after your Windchill server has been running for a few days.

EDC group at PTC isworking on a document onSQL Server w/Windchillinitial planning and installation that should be available soon, and Microsoft is also working on a best practices document for SQL Server w/Windchill.

Tim Atwood

PTC Enterprise Deployment Center

Top Tags