CrazyMan (8/8/2008)

---

Hi All

I recently migrated all my production servers to SAN on Virtual machines,( this is debate going on wether to...

MIJ (8/7/2008)

---

OK, that makes sense that there would be a separate install for clients and only one install for the server. Although after installing the CU I don't know...

The purpose for them being separate is so that you can install the Native Client update on client machines. We were having some issues with client machines using an...

It shouldn't. We did this in the dev environment, but when we migrated in production, we actually used new servers for the 2005 instance.

If I am understanding the problem correctly, the second query you posted should work. Are you saying that is the solution you came up with? If it doesn't...

We have been pretty stable on our production box using CU7 (build 9.0.3239.0). We haven't gone to CU8 because it didn't seem like there were enough things to warrant...

I still think part of the issue is the SQL Server version. We were on the version you are on when we were having issues.

One of my coworkers reminded me that another thing we did to fix the CPU spikes was to patch the SP2. SP2 by itself seemed to have performance issues....

By the way, I don't know if you use this or not, but Idera SQL Diagnostic Manager has been really useful in determining where the issues are. It works...

I wouldn't say that the CPU was 99% all the time, but when there was heavy usage on the SQL Server, it would have large spikes in CPU usage that...

Have you set the max memory for the SQL Server? I had the same issue and that resolved it. It will starve the OS if given the chance....