SQL Server Performance Forum – Threads Archive

SQL Server Architecture

Hi !
THis is job related question. Explain SQL Server Architecture.
Could some one formulate it in 1-2 sentences? I currently read book and it has at least 15 pages of explanation. I need a short answer can someone help? I know i know my question is so……
But have to ask

I found a short description, http://msdn.microsoft.com/library/en-us/architec/8_ar_sa_3fav.asp
HTH Luis Martin
Moderator
SQL-Server-Performance.com

Perfect thank you so much

I have an other question/ HOw do i plan purchase of SQL server for my database?
I mean how to determine rufly how big drives should be ,memory etc? thanks

H/W purchase depends on the userbase and usage of the database by the application. SQL Server 2000 does not have a hardware compatibility list (HCL). If your system meets the minimum requirements, SQL 2000 software works on the hardware certified for use with the Windows O/S you are using. For information about the hardware certified for use with your Windows operating system, see the HCL for version of Windows. The HCL is available online athttp://www.microsoft.com/hcl and in general H/w machines with IntelÂ® or compatible. Pentium 166 MHz or higher, Pentium PRO, Pentium III, or the minimum processor required for operating system, which varies for SQL Server editions. As your question relates to SQL it would be ideal if you post in General section rather in this forum. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>