diff between CPU time and elapsed time?

Hi,
What is the difference between the CPU time and the Elapsed time as
seen in the TKPROF results?
Thanks,
SantoshI don't know what TKPROF is, but:
CPU time is the time that the CPU was doing job for you. Elapse time is the
amount of time from
start of processing to end of processing. During this period, the CPU could
have done things for
somebody else.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<j.santosh.shenoy@.gmail.com> wrote in message
news:1135847807.311256.275360@.g44g2000cwa.googlegroups.com...
> Hi,
> What is the difference between the CPU time and the Elapsed time as
> seen in the TKPROF results?
> Thanks,
> Santosh
>|||> What is the difference between the CPU time and the Elapsed time
CPU time is how much time the CPU spent actually doing work. Elapsed time
is total time... not all of your time was necessarily spent doing CPU work,
it could have been waiting on other tasks, it could have spent time in I/O
(reading/writing to disk) or bandwidth...

> as seen in the TKPROF results?
What on earth is TKPROF? (I don't really need to know the answer, that was
bordering on rhetorical...)|||Hi Santosh
Although the explainations posted by others are probably still valid, you
may want to post this to an Oracle newsgroup!
John
<j.santosh.shenoy@.gmail.com> wrote in message
news:1135847807.311256.275360@.g44g2000cwa.googlegroups.com...
> Hi,
> What is the difference between the CPU time and the Elapsed time as
> seen in the TKPROF results?
> Thanks,
> Santosh
>sql

devenv.exe hangs up with alomost 100% cpu usage

For some reason my visual studio with SSIS project hangs up with almost 100% cpu usage sometimes immediately after opening the studio.

Any resolution?

Thanks

I'm having the same problem and it is driving me nuts! I do a lot of BI work and this has disrupted my project timelines significantly.

As best as I can tell. it seems to have start after applying a patch to the .NET framework 2.0. The patch is defined in the KB922770. I'm not sure if this is the culprit by itself or if there are others factors re-enforcing the problem.

Let me know if you come up with a resolution.

Thanks, Darryl

darryl_jewett@.msn.com

|||

We were able to reduce the occurrence of hangup by 90% with two settings... particulary with the first one.

1. Project property -> Configuration Manger - > Build = UNCHECK (This gets checked mysteriously even though we Uncheck and save in TFS - so we verify for this setting frequently when we open the project). If it is checked - all packages in the project are built/compiled irrespective of package you are working on and if there are 100's of packages - compiling all of them takes hell of time.

2. Tools->Options->Environment->AutoRecovery - Save autorecovery information... = UNCHECK. (I did this bz I saw in the status bar of VS the message: Saving autorecovery details.. when it gets stuck)

Hope it helps you as well (if above setting are not important to you ).

But the problem has not gone altogether.... it still hangs up once in a while.

Thanks

devenv.exe 100% of CPU

As soon as I start to use RS 2005 in Vs 2005 devenv.exe starts to use 100% of CPU ?

I'm also experiencing issues with devenv.exe using 100% of my CPU. I have a simple report, but when I go to preview it, my computer will freeze and I have to reboot. I have already upgraded my memory to 2G. Rebooting does not help. I have the data set returning a single row of data.

devenv.exe 100% of CPU

As soon as I start to use RS 2005 in Vs 2005 devenv.exe starts to use 100% of CPU ?

I'm also experiencing issues with devenv.exe using 100% of my CPU. I have a simple report, but when I go to preview it, my computer will freeze and I have to reboot. I have already upgraded my memory to 2G. Rebooting does not help. I have the data set returning a single row of data.