dbcc memorystatus will give you some clue. Pay special attention to the Dynamic memory manager section. I did have memory leak problem on SQL2K 2 years ago which was...

Are you offshore your DBA job !! Bad idea....

Doesn't seems to.

I do try to use EM to generate script, but somehow a lot of job doesn't seems parse the statement correctly. It seems it always mispalce the '. Do any...

We only move selective DB over to the new server. There are approx. 50 jobs been identified need to move to the new servers. Backup/restore msdb may not work, we...

I do agree with the HTT may be the cause of the problem. I saw several cases that enabling HTT cause problemduring heavy load.

One catch with Eric's recommendation. 10 1GB is great, but you may need enable flag -T1118 and disable auto grow on each file. If you don't, SQL server always...

I believed the SQL task manager is keep checking the incoming queries request and cpu utlization to decide the cpu resource allocation. During the heavy load, the query that use...

Do you know parallelism been use within this SQL ? Check your query plan ? I believed SQL task may swapped out too fast cause high CPU utilization.

There is bug in DBHammer, you have to fixed themin VB code

I'm pretty inline with what Steve says. Few things you need consider also includes: How many controllers you plan to have? Are you plan with SCSI vs Fiber ? ...

Do you know the caching strategy on your controller ? Is paging size is et correct ?

I believed LOG Explorer is the one you need. It read the transaction log backup you created

Do you have /pae /3GB on the boo.ini and AWE enable on the SQL ?

Thanks, for all your reply. Our goal is try to maximized the throughput. The databases are all same but serving different clients Apps should works in both situation.