HI,

please excuse if any wrong suggestions

In my environment in[banking domain ] which my application is running with [.net and sql server 2005 ]

1. in my deep monitoring from 9 months i have seen maximum of 420 concurrnet users in the job activity monitor.

2. due to the most hits from the concurrent users " tempdb " issues happend so many times later we increased more space to tempdb (files ) containing drive .

3. in this mean while before increasing space i workedout as per microsoft recommendations 16 processors should run in 24 gb ram but in my environment it is runig in 2gb instead of increasing the ram sapce is allocated for tempdb

4. to solve the rapid growth of tempdb in most concurrent users

5. i have link sorry to say this activity happend before 6 months but iam unable to find that mail once i found i'vl send by that u can see the process to check details of processors using ram

6. depending on the first point i said " you calculate as per ur requirement "

Thanks

Rohit