Sybase ASE allows users to be assigned specific tempdb databases - this allows for better process segregation and contention reduction.
-- Create a custom temp db, and assign user jsmith to it, also application cognos
create temporary database tempdb_app
on tmp004 = "4G",
tmp005 = "4G"
log on tmp006 = "4G"
go
sp_tempdb 'bind','lg','jsmith','db','tempdb_app'
go
sp_tempdb 'bind','app','cognos','db','tempdb_app'
go
-- Show the assigments
sp_tempdb 'show'
go
|
|