Bhuvnesh (1/10/2013)
APA0876 (1/10/2013)
there is a SQL Query that is causing 90% of CPU on one of the SQL servers also it run in 14 seconds, on other server with similar specs the query executes in less than a second and no cpu spikes also the server configurations are the same:did you run the query at the same time?
are both(or other servers ) returning same records for this query ?
do both servers have same load (like job or background prcosses)
do they have same equal no of connections (at the time of query) ?
Yes I run the query at the same time
Yes 0 records
different Load the server with the spikes is 20 % avg CPU and the other 5% Avg CPU
On the server having the CPU spike there are 1700 connections and the other 10 connections.
But what should I do, this query is exected every 6 minutes because is part of a diagnostic Tool.
Thanks
Ailyn