STReddy
Say Hey Kid
Points: 672
More actions
November 24, 2006 at 6:39 am
#116353
Hi,
Can any one tell me which xp/sp is calculating the CPU idle condition as per the SQL Agent cpu idle condition.
I need to find out the cpu load on the system in the application useing tsql/vbscript.
SQL ORACLE
One Orange Chip
Points: 27807
November 24, 2006 at 5:30 pm
#673875
In order ot dig out up to the tsql/vbscript, you may have to use SQL Server Profiler, I believe.
Pankaj Khanna
Points: 707
November 27, 2006 at 11:37 pm
#674229
select @@cpu_idle will gv u wht u r looking for.
Pankaj KhannaDatabase Administrator - SQL Server 2000
Keep hope to keep you intact...
November 28, 2006 at 10:05 am
#674454
PlusSELECT * FROM master..sysprocesses
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply