Thresold in MS SQL

hi

can any tell me what are the typical values of threshold that we can configure in the app manager for ms sql 2000 and 2005

thanks,
sameer