watch the cpu time in sysprocesses as this is accumulative and doesn't actually relate to cpu % use.

I don't know which sql tools run against 64bit sql, we nearly went...

It is actually possible that sql server doesn't need to use any more memory - it will only use what it needs - are your database(s) user base small ?

I never touch this - been asked many times though -  e.g. "wouldn't it be better to limit SQL Server to the first 6 procs and leave the other 2...

The zeon 4's will leave your zeon 3's standing and give you hyperthreading too. I wouldn't worry too much about the procs and get as much ram as you can....

Thats quite tricky and would require heavy profiler usage, I've been asked for the same information and I suggested it would be a very intensive task even with profiler. You'd...

The theory is that your disk controller attempts to arrange random i/o into sequential i/o for writes thus making the process better, it's all explained in Kalen delany's book inside...

Add more spindles to increase disk i/o  

To use the memory on your sql server you must set the min and max memory and set awe on

exec dbo.sp_configure 'min server memory',27500

exec dbo.sp_configure 'max server memory',27500

exec dbo.sp_configure 'awe...

SQL Counters are stored in the sysperfinfo table you can use this.

Frank  you're an absolute wonder with your references - do you have a sql database to store them ??????

Well you could look at your indexing, I've just done an indexing check on one of my prod databases and adding a dozen indexes dropped the cpu by over 50%.

One...

Yes the alter could be a way .. The production system is very controlled ( by the DBA team including me ) I might be able to do that. Generally...

The user connecting to view the system table sysjobs in msdb database does not have sufficient level of permissions to view it, as I would probably expect.

Either grant explicit permissions,...

I don't think you need to worry about this unless your other counters are giving rise to concern. It's not a counter i monitor.

covered under   serverproperty

SELECT  'LicenseType',

         (CASE WHEN CONVERT(char(20), SERVERPROPERTY('LicenseType')) = 'PER_SEAT'

                  THEN 'Per Seat Mode'

               WHEN CONVERT(char(20), SERVERPROPERTY('LicenseType')) = 'PER_PROCESSOR'

                  THEN 'Per Processor Mode'

               ELSE 'Disabled'

          END)