Configuring the amount of SQL text retained in memory  SQL commands not represented by text

Chapter 11: Diagnosing System Problems

Enabling Adaptive Server to start saving SQL text

After you allocate shared memory for SQL text, Adaptive Server saves a copy of each SQL batch whenever you enable an Adaptive Server Monitor event summary that includes SQL batches.

You may also have to reconfigure Adaptive Server Monitor’s event buffer scan interval for SQL text. See the Adaptive Server Monitor documentation for more information.





Copyright © 2005. Sybase Inc. All rights reserved. SQL commands not represented by text

View this book as PDF