Monday, March 12, 2012

How to SET STATISTICS ON

Hi Folks,
Under Current Activities > Process Info, the cpu information is 0 when
Set Statistics is off, so I want to set it to be on at the database
level so that I am able to capture all in the cpu info?
Thanks
Ata JohnThe Current Activities > Process Info has nothing to do with SET STATISTICS
on/off. The Process Info is just a GUI display of the information in
master..sysprocesses.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Ata John" <ataJohn@.ata1.com> wrote in message
news:3F6F62CB.C3F2E6FB@.ata1.com...
> Hi Folks,
> Under Current Activities > Process Info, the cpu information is 0 when
> Set Statistics is off, so I want to set it to be on at the database
> level so that I am able to capture all in the cpu info?
> Thanks
> Ata John
>

No comments:

Post a Comment