Our big problem seems to be that SQL is using the processor and not the RAM??? Not a computer expert here, but when I view task manager, the RAM is low, but the processor is maxing out throughout the day as multiple people are getting data from the server. Is this common, or is there something wrong/correctable on my server? Thanks again for any help.
David Lee, MD
Dallas, TX
I am going to make a guess that your performance bottleneck is Disk I/O.
What speed is the dis/array that contains your SQL data?
Most folks are having good success moving their data to a SSD RAID1 or better. That way execution isn't sitting in a queue waiting for data. Kind of like Disneyland with only one bobsled running. Nothing like a slow E ticket ride.
