Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-07-22 : 07:35:36
|
| praveen writes "How is cpu performance related with profiler?i.e When conducting a load test the cpu is running at 70%, what is cpu % processor time when started with profiler at this moment?" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-22 : 12:36:20
|
| Performance Monitor is the tool that you want to view this information.Tara |
 |
|
|
kannipraveen
Starting Member
13 Posts |
Posted - 2003-07-28 : 00:26:40
|
| I would like to know that , if i start sql profiler the %processor time decreases, why is it so?i.e my %processor time for sql is 70%, when i start profiler the %processor time drops to 50 or 60 %.why is it so? |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2003-07-28 : 03:30:05
|
Obviously, Processor now has to deal with Sql Profiler too apart from the other proceses ,dividing processor time. so the percentage of attention it gives to other proceses decreases. quote:
when i start profiler the %processor time drops to 50 or 60 %.why is it so?
-------------------------What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson |
|
|
|
|
|
|
performance