I have experienced the situation where our application running on an expensive system with two 4 core CPUs ran slower than on a cheap machine with one dual core CPU. Both machines had similar memory capacity. In each case, the same query was being run by
only one user.
It would be nice to find a way to increase performance, but if adding cores doesn't help, what can a poor developer do? Customers get annoyed when they spend a truckload of money on a new server and nothing changes...
Another potential problem is when customers have an expensive SAN system Sometimes the performance is much slower then on a system with conventional storage.
Can anyone explain the relationship between SQL Server perfomance and hardware ?
View Complete Post