|
SunSystems Performance Optimization |
|
|
|
|
Page 3 of 3
2. Microsoft SQL Server performance optimization
Microsoft SQL Server performance can be monitored using the same tools we described in the “Operating system performance optimization”: System Monitor, Performance Logs and Alerts. You simply choose one of the SQL Server performance objects and counters associated with the object:
Another useful tool enabling you to trace the Microsoft SQL Server is SQL Profile which is part of the Microsoft SQL Server management tools. SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of Microsoft SQL Server. You can capture and save data about each event to a file or SQL Server table to analyze later. For example, you can monitor a production environment to see which stored procedures are hampering performance by executing too slowly.
Use SQL Profiler to monitor only the events in which you are interested. If traces are becoming too large, you can filter them based on the information you want, so that only a subset of the event data is collected. Monitoring too many events adds overhead to the server and the monitoring process and can cause the trace file or trace table to grow very large, especially when the monitoring process takes place over a long period of time.
After you have traced events, SQL Profiler allows captured event data to be replayed against an instance of SQL Server, thereby effectively reexecuting the saved events as they occurred originally.
3. SunSystems performance optimization
SunSystems performance optimization greatly depends on how you have succeed in optimizing your operating system, Microsoft SQL Server and hardware. On top of that it’s vitally import that you apply all the recent patches and service packs released by Infor.
II. Hardware performance optimization
Based on your software performance findings you can plan you hardware performance optimization strategy. Hardware performance optimization is probably the most costly of the two and can include:
1. Buying more powerful CPU, or buying two separate servers one for SunSystems application server and the other for the database server
2. Installing more RAM,
3. Installing RAID system
4. Upgrading your network infrastructure with new more powerful routers, hubs etc.
Discuss in forum
Only registered users can write comments.
Please login or register.
|
Sun Documentation 
