We have 512gig running on DL980 8x8core clustered, SQL2008 R2. Database size is over 500gig. Thousands of connections and processing payroll and HR for 700,000+ employees.

Overall the server performance is night and day. The power changes I do not think was the change that made the difference. Prior to the patch we applied...

We applied that KB to our server. We also applied the below fix that was recommended by quite a few post:

http://support.microsoft.com/kb/2265716

We did these late last week and...

Well still no luck. I downloaded and applied this HOTFIX and still horrible performance. SP_WHO3 takes 12 to 25 seconds at times to come back when only about...

Looking over the HOTFIX seems to point to the slow server issue I am having. What can be looked at to see that the condition is the server not...

Excellent!!! I will start down a new path and take a look at this HOTFIX.

thanks

Well I am using AMD so this won't help me. I am still looking. One thing we did do was to disable VMM in the BIOS for the...

I have not been able to locate any solution other than roll back to windows 2008 r1. Not a good solution as far as I am concerned. I...

If you have 100gigs of backup files what is the realistic bandwidth needs to move these to the cloud? Seems that by the time I get the files into...

Check constraint is present.

Anything else?  Is anyone using Partition Views to do updates or just selects?

Thanks for the reply.  I do have the correct check constraints and have the indexes setup correctly.  I am trying to find a way to take a large OLTP database...