Transcript
Best Practices for Running SiemensTeamcenter on SQL Server Maximize value and operational efficiency in support of world-class product lifecycle management Microsoft CorporationPublished: May 2010 Technical Reviewers: Art Rask – Mentor, Solid Quality MentorsRichard Waymire – Mentor, Solid Quality MentorsChristopher Gill – Teamcenter Centers of Excellence, Siemens PLM Software Abstract Product lifecycle management (PLM) is an enterprise, business, and information strategy that enablesdevelopment and delivery of world-class products. Siemens PLM Software’s Teamcenter® powersinnovation and improves productivity by connecting people with the product and process knowledge theyneed to effectively function in a globally oriented product lifecycle. Teamcenter’s proven lifecycle management solutions are built on an open PLM foundation.This white paper provides best practices for configuring and running Teamcenter 8.1 on the Microsoft SQLServer database platform. This paper complements the detailed support documentation provided on theSiemens support Web site. Implementing these best practices can help you avoid or minimize commonproblems and optimize the performance of Siemens Teamcenter on SQL Server. 2 Copyright Information The information contained in this document represents the current view of Microsoft Corporation on theissues discussed as of the date of publication. Because Microsoft must respond to changing marketconditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoftcannot guarantee the accuracy of any information presented after the date of publication. This whitepaper is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED, ORSTATUTORY, AS TO THE INFORMATION IN THIS DOCUMENT.Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rightsunder copyright, no part of this document may be reproduced, stored in, or introduced into a retrievalsystem, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, orotherwise), or for any purpose, without the express written permission of Microsoft Corporation.Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual propertyrights covering subject matter in this document. Except as expressly provided in any written licenseagreement from Microsoft, the furnishing of this document does not give you any license to thesepatents, trademarks, copyrights, or other intellectual property.© 2010 Microsoft Corporation. All rights reserved.Microsoft, SQL Server, Hyper-V, MSDN, and Windows are trademarks of the Microsoft group of companies. All other trademarks are property of their respective owners. 3 Table of Contents OVERVIEW ............................................................................................................................................... 5 S IEMENS T EAMCENTER : T HE S OLUTION FOR P RODUCT L IFECYCLE M ANAGEMENT ........................................................ 5 SQL S ERVER : A N E NTERPRISE -R EADY D ATABASE P LATFORM FOR T EAMCENTER .......................................................... 6 B ETTER T OGETHER : T EAMCENTER ON THE SQL S ERVER D ATABASE P LATFORM ........................................................... 6 THE TEAMCENTER ARCHITECTURE ........................................................................................................... 7 C LIENT A PPLICATION T IER ................................................................................................................................. 7 W EB A PPLICATION T IER ................................................................................................................................... 7 E NTERPRISE T IER ............................................................................................................................................. 8 R ESOURCE T IER .............................................................................................................................................. 8 T WO T IER T EAMCENTER D EPLOYMENTS .............................................................................................................. 8 BEST PRACTICES FOR RUNNING TEAMCENTER ON SQL SERVER ............................................................... 9 P LANNING AND I NSTALLING THE SQL S ERVER I NSTANCE ......................................................................................... 9 Use a Dedicated Database Server and SQL Instance ............................................................................. 9 Select the Appropriate SQL Server Edition ............................................................................................. 9 Options for High Availability ................................................................................................................ 11 Which Features to Install ..................................................................................................................... 11 Setting the Service Account for SQL Server .......................................................................................... 12 Setting the Server Collation at Install Time .......................................................................................... 15 Choosing the Security Mode ................................................................................................................ 17 Deciding Which Services to Auto-Start ................................................................................................ 18 Proper Placement of the tempdb Database ......................................................................................... 19 Configuring Memory for SQL Server .................................................................................................... 23 Maximum Degrees of Parallelism ........................................................................................................ 26 I NSTALLING THE T EAMCENTER D ATABASES ......................................................................................................... 27 File Placement on the Disk Subsystem ................................................................................................. 27 Sizing Data Files Up Front .................................................................................................................... 28 Spread the PRIMARY Filegroup across Files on Multiple Disks (optional) ............................................ 28 Use Data Compression (Enterprise Edition only) ................................................................................. 29 A DJUSTING SQL S ERVER AND D ATABASE S ETTINGS .............................................................................................. 29 Verify Database Collation .................................................................................................................... 29 Automatic Statistic Updates, Auto Shrink, and Other Options ............................................................ 30 Choosing a Database Recovery Model ................................................................................................. 31 O NGOING M ANAGEMENT ............................................................................................................................... 32 The Database Backup Plan .................................................................................................................. 32 Synchronization of Teamcenter Database and File Backups ............................................................... 34 Monitor Index Fragmentation and Defragment When Necessary ....................................................... 35 Run the Teamcenter Index-Verifier Tool .............................................................................................. 36 Periodically Check Database Integrity ................................................................................................. 36 4 Monitor Space Used ............................................................................................................................. 37 Use SQL Server Agent Jobs and Alerts .................................................................................................. 37 T OOLS FOR M ONITORING D ATABASE S ERVER P ERFORMANCE ................................................................................ 37 SQL Server Activity Monitor ................................................................................................................. 37 Standard Database Reports in Management Studio ........................................................................... 39 Performance Monitor .......................................................................................................................... 39 CHECKLIST .............................................................................................................................................. 42 SUMMARY ............................................................................................................................................. 43 LINKS FOR FURTHER INFORMATION ...................................................................................................... 44
