Sql Server Architecture 2000, 2005

Question

Sql Server Architecture 2000, 2005

dsachu

SSCrazy

Points: 2242
More actions
September 11, 2010 at 12:40 am

#98899

Hi,
I would like to request to every one kindly explain me Sql Server Architecture of 2000, 2005
in detail with the help of pictorial diagram.
if u have any exact link or document which have pictorial diagram kindly refer me.
Thanx,
Sachin.:-)

Viewing 13 posts - 1 through 12 (of 12 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

what exactly about the architecture are you looking for?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 2

I can't help but wonder what class this might be for. 😎

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

Have you looked in Books Online? There's a whole section on SQL architecture in there.

p.s. I've seen this question multiple times recently, on this and other forums. Class homework or something?

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

It might even be for interview preparation.

The question seems to be fairly broad though, and a more specific question would more than likely garner an answer.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

dsachu SSCrazy Points: 2242 More actions · Answer 5

Hi everyone,

good evening...

i would like to request we don't go beyond our track, like what i will do for that.

only request kindly suggest me better option.

other wise no means of this forum for me.

Regards,

Sachin.

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

kumar.sachu08 (9/11/2010)
i would like to request we don't go beyond our track, like what i will do for that.

If we know the reason and details of the request, maybe we can point you in a more appropriate direction than otherwise. I'm also curious why I've been seeing near-identical questions from different people on different forums over a couple weeks

only request kindly suggest me better option.

As I suggested earlier, have you read through SQL Books Online (the SQL documentation that's installed with SQL)? There's an entire section on the SQL architecture in there.

Please understand this is a huge question. Entire books have been written on SQL Architecture. It's not exactly something we can answer in a few lines on a forums.

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

dsachu SSCrazy Points: 2242 More actions · Answer 7

Hi,

Thanx for your frequent reply.

Actually i know whole sole details of sql server, so i know about the sql architecture in details.

I have many question in my mind regarding sql server

how it work, what's internal it functions , what the thing come after one other etc.

According to you this is very big chapter & we can't discussed this thought forum.

I know this not a better platform.

But i would like to request to please aware me about this big chapter, I realy appreciate if u share your knowledge with me for this topic.

if possible kindly send me pictorial diagram or any DFD for the sql architecture on my mail id

kumar.sachu08@gmail.com

Thanx

Sachin.:-)

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

kumar.sachu08 (9/11/2010)
Actually i know whole sole details of sql server, so i know about the sql architecture in details.

Um, if you know SQL architecture in details, why are you asking for details on SQL architecture?

I have many question in my mind regarding sql server

Then ask them individually. Asking a massive, vague question is not likely to get you any good results

But i would like to request to please aware me about this big chapter,

As I said twice, SQL Books Online. It's installed with SQL server, it's also available on MSDN. The first can be accessed via the Start Menu (Start -> All Programs -> Microsoft SQL Server-> Documentation and Tutorials) and the online can be easily found with any good search engine. Or, if you prefer:

http://msdn.microsoft.com/en-us/library/aa933154%28SQL.80%29.aspx SQL 2000

http://msdn.microsoft.com/en-us/library/ms191135%28v=SQL.90%29.aspx SQL 2005

Those two should answer most of your questions.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

I think Gail's response pretty much covers the gambit multiple times over.

Read through the references she provided and then post specific questions.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

dsachu SSCrazy Points: 2242 More actions · Answer 10

Hi,

Thanx to providing me two links.

but i can't understand from where i start study and where to end related to sql architecture.

it would be better for me, if u provide me DFD:-) like given link

http://www.sqlservercentral.com/Forums/Topic459508-149-1.aspx

for sql architecture 2000, 20005. it will more helpful for me.

Thanx

Sachin.

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

Um... The image in the thread you refer to IS the SQL 2005 architecture. I don't have one for SQL 2000 handy, but there's very likely one in Books Online.

As for where to start, the beginning is a very good place. Take those two links I gave you and start with the first link on each and start reading.

If you have specific questions or specific things that need clearing up, feel free to ask.

As Jeff said on the thread you linked to:

Jeff Moden (8/29/2010)
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.

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

dsachu SSCrazy Points: 2242 More actions · Answer 12

Hi Gail,

I really impressed with you, to guide me very well.

I will definitely touch with u in future.

Thanx

Sachin.