Posted by Erland Sommarskog on 10/21/05 10:28

(csomberg@dwr.com) writes:
> We are re-writing the app but that will take 6 months. The additional
> reason for the box is new development and replication as well.
>
> So, thoughts on a new box ?

Hardware recommendations in general is not my area. However, I am aware of
the problem of dynamic SQL + lots of memory, which is why I wanted to
alert you.

If you find that the new box behaves unexpectedly poorly, you can keep this
in mind, and rip out some GB of memory until you have fixed the app.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]