Ok, we all know that we can change SQL Server settings to improve performance and database tuning to improve specific databases.....
Now what do we do with the servers and the OS themselves?
Dedicated SQL Server (new box)
Windows 2008 64bit Enterprise Edition
SQL Server 2008 64bit Enterprise Edition
SAN attached drives
going to be be around 600-700GBs of DBs transactional.
My list so far is (all require researching and testing):
pagefile - 1.5x physical memory still the base standard? obviously I dont want SQL paging
limiting the max memory of SQL server
What else should be added to my list?