Google Answers Logo
View Question
 
Q: CPU column always shows zero in SQL Profiler 2005 ( No Answer,   1 Comment )
Question  
Subject: CPU column always shows zero in SQL Profiler 2005
Category: Computers > Software
Asked by: wastech-ga
List Price: $10.00
Posted: 04 Oct 2006 08:52 PDT
Expires: 03 Nov 2006 07:52 PST
Question ID: 770742
In SQL Server 2005, I am running various SQL Profiler traces on
different servers. On certain servers, the profiler trace always
displays a zero in the CPU column of each and every trace row.
Everything else works as expected.

This occurs on certain servers, but not on all servers, and I have
been unable to identify any server configuration options that are
different between the servers.

The zeros produced in the CPU column are undoubtedly inaccurate. What
is causing this, and how do I fix it?
Answer  
There is no answer at this time.

Comments  
Subject: Re: CPU column always shows zero in SQL Profiler 2005
From: eugenez2-ga on 21 Oct 2006 07:03 PDT
 
please run on sql server 2005 (where from profiler):
select @@version
and if it is less then 2005.90.2047 (SP1)
install sp1 for sql server 2005 ..

<On certain servers, the profiler trace always
displays a zero in the CPU column of each and every trace row>
can you clarify the "bad" sql servers edition\version\SP?
Also same for OS : edition\SP - for main (where profiler) and CPU-less box

if their sql servers SP not too fresh - it could be source of your problems.

 ----
Also just be sure - is there any activity on the 0 CPU box?
What CPU you can see on box's profiler - if login there?

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy