Kbase P103305: Is it necessary to recreate the schema holder to take the advantage of the Performance enhancements
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/28/2007 |
|
Status: Verified
GOAL:
Is it necessary to recreate the schema holder of MS SQL DataServer when migrating to 9.1E
GOAL:
Is there an alternative solution for recreating schema holder when migrating MS SQL DataServer to 9.1E
GOAL:
Is it necessary to recreate the schema holder to take the advantage of the Performance enhancements introduced in 9.1E
FACT(s) (Environment):
Progress 9.1E
MS SQL DataServer
FIX:
Yes. The SQL Server DataServer in 9.1E has being introduced new features that provide additional support to improve the performance of the Progress DataServer for Microsoft SQL Server applications. These new features are
? Connection Pooling
? Firehose and Fast Forward-Only Cursors
? Cursor and Connection Use Monitoring
So, in order to take advantage of these features you must rebuild your schema holder.
For more information about migrating MS SQL DataServer and recreating the schema holder see solution P23300