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) ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)