This content has been marked as final. Show 4 replies
Hi Devon -
I think it's really a question of which OS version to use and which SQL Server version to use (Standard, which ships with PDME or Enterprise).
Number and size of files are a factor for your storage solution.
The chart you are showing has more to do with how much memory SQL Server can address given different OS and SQL Server combinations.
What you are looking for is: how big is my database? - Because you want your entire database to be loaded into memory for optimal performance.
For the database server you care about CPU performance and memory.
For the archive server you care about I/O performance and storage capacity.
As for OS versions, look here for a comparison:
As for SQL Server, look here for a comparison:
Thanks for the information and links, I really appreciate it.
Have a great weekend.
Our recent experience might be helpful. We were running the database server on a server with 4 Gb RAM, using SQL 2005 and Server 2003. We moved the database server to a new server with 8 Gb RAM running 64 bit version of SQL 2005 and Server 2003 x64 edition.
On the old server PDMWE 2008 would start bogging down when the server reached 3 GB Total Commit Charge. We would restart the SQL instance to free up memory.
On the new server we are running consistently at 6 Gb RAM (2 SQL processes are using total of 5.5 Gb). We haven't had to restart SQL and we don't notice any slowness with heavy activity.
It seems to me (like most MS products) SQL server will use as much RAM as you give it.
Hope this helps
Thanks for sharing this information. I'm planning to build a 64 bit server soon.