The Performance Analysis of Logs (PAL) tool is a free tool from CodePlex. It parses and analyzes Windows Performance Monitor logs to find performance bottlenecks. The PAL tool can help you find performance bottlenecks in SQL Server running Teamcenter by aggregating and evaluating the hundreds of Performance Monitor counters that are associated with SQL Server. The PAL tool reads in a Performance Monitor counter log in any known format and then analyzes the log by using the thresholds in the tool. The thresholds are based on the thresholds that Microsoft product teams and members of Microsoft support have defined. The PAL tool generates an HTML-based report that graphically charts important performance counters and alerts you when the thresholds are exceeded. You can use this tool to analyze the logs of many different dedicated software installations that run on Windows Server, including the logs of servers that run SQL Server, Microsoft BizTalk Server, and Microsoft Exchange Server. For Teamcenter, we are going to look at how the PAL tool can diagnose performance issues for a SQL Server installation.
How to Install the PAL ToolThe PAL tool requires several additional components to be installed. Therefore, you should install the PAL tool on a workstation and not on the computer that is running SQL Server. (A best practice is to not install anything on a dedicated computer that is running SQL Server unless it is required for SQL Server to run.) The PAL tool runs on 32-bit operating systems only. Before you install the PAL tool, you need to install the following items from the Microsoft Download Center:· Log Parser 2.2· Microsoft Office Web Components 2003· The Microsoft .NET Framework 2.0 After you install these items, you can install the PAL tool from the following CodePlex Web site:http://pal.codeplex.comThe installation of the prerequisites and the PAL tool is the hardest part of the whole process. After this, the PAL tool makes it very easy to collect and analyze the log files. Read more: Siemens Teamcenter on SQL Server
How to Install the PAL ToolThe PAL tool requires several additional components to be installed. Therefore, you should install the PAL tool on a workstation and not on the computer that is running SQL Server. (A best practice is to not install anything on a dedicated computer that is running SQL Server unless it is required for SQL Server to run.) The PAL tool runs on 32-bit operating systems only. Before you install the PAL tool, you need to install the following items from the Microsoft Download Center:· Log Parser 2.2· Microsoft Office Web Components 2003· The Microsoft .NET Framework 2.0 After you install these items, you can install the PAL tool from the following CodePlex Web site:http://pal.codeplex.comThe installation of the prerequisites and the PAL tool is the hardest part of the whole process. After this, the PAL tool makes it very easy to collect and analyze the log files. Read more: Siemens Teamcenter on SQL Server