| Author |
Topic |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-06-29 : 08:03:02
|
| Hi,This is only a doubt. If anyone can clear my confusion please...I am observing the CPU utilization through Perforance Monitor.During the month end processes CPU utilization of the database server comes to 100%.But when I open the profiler it will go down to 20, 14 or even 0.The profiler gives perforance overhead, right?Then why it is showing like this? Any idea.... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-29 : 12:20:58
|
| Yes it gives performance overhead. Neither tool should be opened up on the database server though. Both should be opened up on a client machine. Opening SQL Profiler is not causing the utilization to decrease. It is coincidence that this has occurred.Tara |
 |
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-06-30 : 00:47:43
|
No, I am sure. Because I checked this several times. Just now I checked. The utilization is high, but when I start profiler the utilization graph goes down !!!!!!!!! The graph should go up, right? Task manager also gives the same.Please check this....if you can. I am not claiming that the actual utilization is going down. I don't know if the performance monitor is giving the real picture. I want to test that also. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-30 : 01:22:48
|
| what processes are taking the cpu? Are you somehow graphing the System Idle Process?-ec |
|
|
|
kselvia
Aged Yak Warrior
526 Posts |
Posted - 2004-06-30 : 03:14:42
|
| Is something running that uses idle cpu cycles (screen saver, anti-virus, some distributed computing client - seti, search for PI , spyware/malware, virus, etc) |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-06-30 : 03:14:59
|
| dear ec,I know what I am doing, ok.I took %Processor Time. I already said that in the Task Manager--Perforance is also giving the same thing. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-06-30 : 03:32:55
|
| Just check the following..Start the Profiler,Open Trace Properties => EventsAdd Locks, Scans, Performance event classes and Run.Just see the difference in the perforance monitor graph.The rest of Event classes do not give any effect. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-06-30 : 11:37:48
|
quote:
Originally posted by bobanjayan
dear ec,I know what I am doing, ok.I took %Processor Time. I already said that in the Task Manager--Perforance is also giving the same thing.
what process is taking 100% cpu? is it the sqlsvr process or something else?Also, you are being too thin skinned. Sometimes we have to ask the stupid question because we may not know who you are or what your capabilities are. So relax..-ec |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-07-02 : 09:16:39
|
| Hi,-- Sqlserver Proceses only.--No my total data size is 10 GB only, And I reserved 10GB more.i.e. Database size is 20GB.....No growth at all.I was trying to say the opposite effect of CPU utilization when using the profiler, not about "the 100% CPU Utilization".Regards. |
|
|
|
|
CPU Utilization and Profiler