Hi,
We have a website that had 8 web server and 3 db servers, data is distributed on 3 server unevenly, DB1 is bigger and better server and DB2 and 3 are smaller so they handle less data and jobs.
We upgraded to SQL 2005 so we get better performance, so performance got better but cpu on only db1 is going very too high(mostly 80%), it was not like this when we upgraded them.
I was wondering if anyone knows a solution to find out what is driving cpu utilization so high.
Thanks.
We have a website that had 8 web server and 3 db servers, data is distributed on 3 server unevenly, DB1 is bigger and better server and DB2 and 3 are smaller so they handle less data and jobs.
We upgraded to SQL 2005 so we get better performance, so performance got better but cpu on only db1 is going very too high(mostly 80%), it was not like this when we upgraded them.
I was wondering if anyone knows a solution to find out what is driving cpu utilization so high.
Thanks.