I have MS SQL 2000 Standard edition licensed in "per device" mode on a dual xeon. However the properties->Processor tab on EM only list 1 cpu (CPU 0) and has "use all available processors" selected and the use [#] is greyed out.
Anybody else experience this? Is it really using both processors? Or do I have some limited product key? I called MS tech support but they were like, "um that'll be $295 to open a support instance" <*click*>.
first thing to look at is that your Windows actually sees both processors, if you added the processor after installing Windows you may be using the Uniprocessor kernel, in which case Windows and SQL Server would only see one proc... kind of hard to say without knowing more about your system