su5y (4/18/2009)
Hi,We rebooted the box a few weeks back due to bad performance and seen a great improvement in load times 10-15hrs for a few loads - over the past weeks the performance as greatly decline and now takes up 42 hrs to load.
As steve mentioned you should let us know what you mean by load?
Has anyone experience the same problem? The spec of box is great and we looking to upgrade but I want to ensure we don't have same issue with new box.
Theres much to consider in the server than just having great specifications and is it just because of this issue you are upgrading your server? Have you considered anything to improve at your application side?
What is reboot clearing down and what is building up over time i.e. tempdb related, cache related?
Thanks
You need to give us more insight into your server than the info which you have provided to us, then we can try to give you n optimal solution.