plan text pipe active  print deadlock information

Chapter 5: Setting Configuration Parameters

plan text pipe max messages

Summary information

Default value

0

Range of values

0–2147483647

Status

Dynamic

Display level

Comprehensive

Required role

System Administrator

Configuration groups

Memory Use, Monitoring

plan text pipe max messages determines the number of query plan text messages Adaptive Server stores per engine. The total number of messages in the monSQLText table will be the value of sql text pipe max messages times the number of engines running.





Copyright © 2005. Sybase Inc. All rights reserved. print deadlock information

View this book as PDF