Kbase P38892: Where can I get some documentation to performance tune MS SQL server dataserver?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Where I can find documentation on performance tuning my Progress application connection to SQL Server?
GOAL:
Documentation on How to Improve performance when using MS SQL DataServer
GOAL:
Documentation on Performance improvements with MS SQL DataServer
FACT(s) (Environment):
MS SQL DataServer
MS SQL
FIX:
Go to http://psdn.progress.com
1. DataServer Best Practices
This document is a guide to help project managers and application developers understand and estimate the work involved in adopting the Progress DataServer technology. This document contains advice for the Oracle, MS SQL Server, and ODBC Progress DataServer products.
2. Configuration and Coding Techniques for the Progress DataServer for Microsoft SQL Server
Achieving high performance from your DataServer for Microsoft SQL Server applications involves optimizing the system's configuration and using the most effective querying and transaction management techniques. This white paper explains how to tune every piece of the DataServer architecture and how to write data-access logic that allows you to take best advantage of Progress and SQL Server resources.
3. Progress online Documentation at http://www.progress.com/support
Progress DataServer for Microsoft SQL Server
Chapter "Enhancing DataServer Performance"
-Progress Query Types
-Query Tuning
-Caching Records
-Join by SQLDB
-Writing Queries for Performance
-Modifying the Run-time Schema Check