sql server architecture

Question

Post reply

sql server architecture

y.koteswarrao-652921

SSCrazy

Points: 2010
More actions
February 24, 2008 at 7:53 am

#187012

Hi to sql dba's
iam new to sql dba....... can any body give a documents about the sql server architecture & diagram.
Thank you
koteswarrao.y

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

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

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 1

Sure... it's all in Books Online (comes free with SQL Server).

Look in the index for "architecture [SQL Server]"...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Vijaya Kadiyala SSCrazy Eights Points: 9119 More actions · Answer 2

Hi

Check out the below link

http://msdn2.microsoft.com/en-us/library/aa933154(SQL.80).aspx

Thanks -- Vj

http://dotnetvj.blogspot.com

Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers

Manish_ Ten Centuries Points: 1070 More actions · Answer 3

Have a look

Source : http://blog.sqlauthority.com/2007/12/08/sql-server-generic-architecture-image/

Thanks

Manish

- Manish

Manish_ Ten Centuries Points: 1070 More actions · Answer 4

Have a look

Source : http://blog.sqlauthority.com/2007/12/08/sql-server-generic-architecture-image/

Thanks

Manish

- Manish

j.venugr SSC Journeyman Points: 99 More actions · Answer 5

i got architecture from your forum, but i need brief explanation about sql sever architecture to understand very clearly, so please send the explanation, my mail ID is j.venugr@gmail.com

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 6

SQL Server is huge, and the explanation would be pages and pages.

Please go read some documentation. There are good explanations here: http://msdn.microsoft.com/en-us/library/cc280361%28v=SQL.100%29.aspx

If there's something specific you don't understand, ask. Otherwise, do some research.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 7

j.venugr (8/28/2010)
i got architecture from your forum, but i need brief explanation about sql sever architecture to understand very clearly, so please send the explanation, my mail ID is j.venugr@gmail.com

It's easy... it's like anything else in computers... stuff comes in, gets processed, and is output in one form or another. If you want the details so you can "understand very clearly", then please read Books Online about the architechture as I previously suggested.

And, no... I'm not being a smart guy here... the question you've asked is kind of like "How does the engine on my car make it go?". "Brief explanation" won't help you "understand very clearly". If you want that level of understanding, you're simply going to have to hit the books.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

Jeff Moden (8/29/2010)
"How does the engine on my car make it go?".

🙂 Lets not start discussing the 4 stroke engine here!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

homebrew01 SSC Guru Points: 55548 More actions · Answer 9

Jeff Moden (8/29/2010)

It's easy... it's like anything else in computers... stuff comes in, gets processed, and is output in one form or another.

The input & output I understand. It's the part in the middle I have trouble with.

forsqlserver SSCoach Points: 18902 More actions · Answer 10

In the architecure given by manish Relational engine is not visible.Where is it?

Thanks

BenWard SSCertifiable Points: 5903 More actions · Answer 11

homebrew01 (8/29/2010)
The input & output I understand. It's the part in the middle I have trouble with.

ha ha excellent 🙂

to the op:

see http://msdn.microsoft.com/en-US/library/ms179276(v=SQL.90).aspx for physical database architecture and http://msdn.microsoft.com/en-us/library/ms189559(v=SQL.90).aspx for engine architecture.

Read these books, then ask questions on anything you dont understand. The pros here (do I fit into that category yet?? lol) are always happy to assist people who are putting effort into learning the product already. No-one will email you with a magical 2-page document that explains everything. No such document exists or even could exist as the product is too massive.

Happy learning!

EDIT: Haha didnt see the original post date there lol

Ben

^ Thats me!

----------------------------------------
01010111011010000110000101110100 01100001 0110001101101111011011010111000001101100011001010111010001100101 01110100011010010110110101100101 011101110110000101110011011101000110010101110010
----------------------------------------

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 12

forsqlserver (6/6/2011)
In the architecure given by manish Relational engine is not visible.Where is it?

There's no such component. The entire thing put together is a relational database system.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

forsqlserver SSCoach Points: 18902 More actions · Answer 13

Thanks Gila,

U mean to say database engine is relational engine.

then why in below ink it has two parts:Relational DBengine and Physical database Architecure

http://msdn.microsoft.com/en-US/library/ms191135(v=SQL.90).aspx

Thanks

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 14

This post not covers full SQL architecture, But its help.

SQL server internals

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/