Post reply

Genearl SQL server Architechture like Oracle''s SGA > PGA >Processes

  • July 15, 2006 at 2:26 pm

    #90339

    Hi all

    What is SQL SERVER Architecture? this critical question in my interview I started to say about MASTER DB,MSDB DB,MODEL,TEMP DB

    he say no..

    Igain i started to say Net-Librarary,DB-Librarary,TDS,Sql enginee

    again say no.....

    i total confused,can some help out what the Ms-sql server architechure

    thanks in advance

    vyshnav

    Junior DBA

  • July 17, 2006 at 7:41 am

    #649511

    You can read Microsoft's definition in Books Online (BOL). Select the Index tab, the type 'SQL Server'. Select architecture from the sublist.

    Basically, they just say that SQL Server is a server-based RDBMS that works in mutlitiered systems (including client/server systems).

    To quote BOL:

    A central database on a server shared by many users who connect to it over a network. The number of users can range from a handful in one workgroup, to thousands of employees in a large enterprise, to hundreds of thousands of Web users.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply