Confirming Processor Usage

After installing the SQL Server 2000 Standard Edition, how
can one tell that all processors and memory are being used
by SQL Server?
I realize that applications should receive a faster
response time, but there must be a way to check on the
server box itself (or within SQL Server) that it is
utilizing all available processors (or whatever the
maximum number of processors that SQL Server 2000 Standard
Edition is capable of using).
Can someone please let me know as I'm hard pressed right
now to find anything out there that indicates a way of
checking this item.
Thanks.
HouseYou can use the performance monitor tool that comes with Windows. I think
it's actually called System monitor now. There are lots of counters related
to the processors, disks, sql server etc. These may get you going:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly
SQL Server MVP
"Jason House" <jason.house@.ns.sympatico.ca> wrote in message
news:052301c34be0$0143bd80$a101280a@.phx.gbl...
> After installing the SQL Server 2000 Standard Edition, how
> can one tell that all processors and memory are being used
> by SQL Server?
> I realize that applications should receive a faster
> response time, but there must be a way to check on the
> server box itself (or within SQL Server) that it is
> utilizing all available processors (or whatever the
> maximum number of processors that SQL Server 2000 Standard
> Edition is capable of using).
> Can someone please let me know as I'm hard pressed right
> now to find anything out there that indicates a way of
> checking this item.
> Thanks.
> House