I have a site that for the past few months has had a bit of a performance problem with an application that talks to their SQL database. At first I thought it was an issue with the performance of the SQL DB, as it currently sits on the same hardware as the Exchange, so just running as a single server environment.
This was adequate when they were only a 10 user site, and not doing much reporting etc, but they have grown, and time has come to split SQL off to another piece of hardware, as the problem with their application is that when they first open it up, it can take up to 5mins to open up.
After a reboot of the server, it would only take 10-20secs to open up, but as SQL and Exchange starting gobbling up resources, over the period of about 5-6 days this would slowly push out again till got back to it's 5mins.
Adding RAM to the server and limiting the amount of RAM that Exchange could access helped the situation, but didn't resolve it, so new hardware was order and to move SQL onto that.
In the process of shifting the databases over, I have stumbled onto something which I believe could be more of the issue, but not sure what it causing it, or how to fix it.
If I go onto the SBS server, and push a large file to the other server, or workstation, the speed of the transfer is adequate, runs about 15mb/s, but if I try to pull the same file from the SBS server, then the transfer only runs at 400KB/s.
Have update all the controller, NIC, Hard drive firmware, sent all DSET logs to DELL, and they say everything looks good from their end, but clearly it isn't. Have tried different ports on the switch, and a different switch, along with different cabling, and non of that makes any difference.
Anyone have any ideas where to start looking to try and narrow down what is causing the issue.