sql server clock tick length  sql text pipe max messages

Chapter 5: Setting Configuration Parameters

sql text pipe active

Summary information

Default value

0

Range of values

0–1

Status

Dynamic

Display level

Comprehensive

Required role

System Administrator

Configuration group

Monitoring

sql text pipe active controls whether Adaptive Server collects SQL text. If this option is enabled and sql text pipe max messages is set, Adaptive Server collects the SQL text for each query. You can use monSysSQLText to retrieve the SQL text for all user tasks.





Copyright © 2005. Sybase Inc. All rights reserved. sql text pipe max messages

View this book as PDF