Here is an easy-to-implement suggestion to optimize your setup right out of the gate: SQL Server runs best on a computer by itself, with ENOVIA V6 running on a separate physical computer.
Why separate servers?The short answer—because it will make your life easier. The long answer—for these reasons:
RAMSQL Server has its own memory management that pages database resources from the hard disk into RAM. This is because the more data cached in the RAM, the faster SQL Server can respond. For an enterprise application like ENOVIA V6, SQL Server will effectively use all available RAM on the computer, paging the most-often accessed data off of the hard disk.
UpdatesIn addition, running SQL Server on a separate computer lets you apply Windows updates and SQL Server patches on the computer separate from the ENOVIA V6 application. Based on requirements from Dassault Systèmes, the hotfixes and updates might need a different deployment schedule than the one SQL Server follows. We’ll have more information about Windows updates in a later post.
Hard disk configurationSQL Server makes extensive use of the hard disk, and we’ll cover configuring the hard disk arrays to work with SQL Server in a post down the road. However, running SQL Server on a separate computer reduces the complication of monitoring and tuning the hard drive configuration.
SecurityRunning SQL Server on a separate computer can reduce the attack surface of the computer, creating a more secure database. Depending on your security environment, you can lock down the computer that is running SQL Server with different requirements from the servers that are running ENOVIA V6. Locking down the database server might be as simple as restricting access by domain accounts to who has access to log on or restricting what ports are exposed for data access. Port restrictions are greatly simplified with a single-purpose computer.
Hardware upgradesHaving SQL Server on its own computer allows you to have separate hardware upgrade paths from ENOVIA V6. Depending on your organization, the database size might grow disproportionally from the data access requirements. Separating the servers allows you to scale the database independently—either upgrading it entirely in the future or adding more RAM.
Share your experienceHave you already installed SQL Server and ENOVIA V6 on the same computer or on separate computers and want to share your experience? Speak up in the comments.
For Dassault Systèmes ENOVIA V6 on SQL Server and Microsoft news, events, and further information, see the Dassault Systemes and Microsoft Alliance page.
Follow Tier1OnSQL on Twitter