Hello,

Can Sybase look into creating a per connection or per process sort space?
That is, I would like to be able set a number of bytes for sort space per
process.

For Example)
EXEC sp_configure "connection sort space", 8192
go

The memory that would be required for the sort space would then be (NUMBER
OF CONFIGURED CONNECTIONS) * (CONNECTION SORT SPACE).

I like the multiple tempdbs and would still use them, but for sort space I
would like a tempdb database to be only used for overflow of the
"connection sort space". Is this possible?

Thanks,
Ryan Putnam