SQL Server Performance Forum – Threads Archive
SQL Server Configuration
I am planning to Install SQL Server 2005 for production database. My database should have more than 1 TB data and more than 100 online users. What should be the SERVER configuration I have to choose for the smooth functioning of SQL Server Database. Thanks in Advance. Biju Oracle DBAIf you plan to have a database of that size, you should get some consultant with proven experience in SQL Server VLDB. In this region hardware matters as much as db design and the calling app. All must perfectly fit together. As this is very specific to your environment, there is not much that can seriously be suggested from an online community. Check out the site here and probably
http://www.microsoft.com/sql/default.mspx
http://www.microsoft.com/sql/prodinfo/casestudies/default.mspx
http://www.microsoft.com/technet/prodtechnol/sql/default.mspx
and talk about your findings to the consultant. —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
I’ve moved to relevant forum.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS†with no warranties for accuracy.
Also refer to the IT showcase on VLDBhttp://www.microsoft.com/emea/itsshowtime/sessionh.aspx?videoid=57 adnhttp://whitepapers.silicon.com/0,39024759,60275659p-39000434q,00.htm too. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>