Internal architecture of SQL SERVER

Question

Post reply

Internal architecture of SQL SERVER

diva.mayas

Mr or Mrs. 500

Points: 569
More actions
March 31, 2010 at 6:06 am

#225714

Can anybody suggest link or book to know the IN-Depth working knowledge for sql server architecture like
-Understanding Pages and Extents
-Managing Extent Allocations and Free Space
-Managing Space Used by Objects
-Tracking Modified Extents
-Tracking Modified Extents
-Transaction Log Logical Architecture
-Transaction Log Physical Architecture
-Checkpoints and the Active Portion of the Log
-Write-Ahead Transaction Log
i need very basic, bcoz i am neebee to sql server job

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

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

John.Sansom SSCertifiable Points: 7335 More actions · Answer 1

Hello and welcome to the forums.

SQL Server 2008 Internals would be an excellent choice in my opinion.

John Sansom (@sqlBrit) | www.johnsansom.com

fabricio_lima_es Mr or Mrs. 500 Points: 510 More actions · Answer 2

Buy the book SQL Server 2008 Internals.

Fabricio França Lima
MCITP - Database Administrator
http://fabriciolima.net
Twitter: @fabriciodba

Paul White SSC Guru Points: 150467 More actions · Answer 3

Books Online (the help system that comes with SQL Server) is also an excellent resource, and may be more accessible to the beginner.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

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

diva.mayas (3/31/2010)
i need very basic, bcoz i am neebee to sql server job

If you're a complete beginner, you should not be worrying about SQL's internals and architecture. That's advanced stuff. Focus on the basics of queries/administration initially. Once you're familiar with SQL, then you can start worrying about the deep, complex internals.

If you insist, read Paul Randal's blog.

http://sqlskills.com/blogs/paul/

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

Paul White SSC Guru Points: 150467 More actions · Answer 5

Understanding Pages and Extents

Managing Extent Allocations and Free Space

Managing Space Used by Objects

Tracking Modified Extents

Transaction Log Logical Architecture

Transaction Log Physical Architecture

Checkpoints and the Active Portion of the Log

Write-Ahead Transaction Log

Nothing wrong with learning the internals at the same time as the basics, some people prefer to learn that way.

The SQL Server Internals Books are excellent.

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

diva.mayas Mr or Mrs. 500 Points: 569 More actions · Answer 6

Thanks John, i will go for the sql server internals. thanks for assisting me.

diva.mayas Mr or Mrs. 500 Points: 569 More actions · Answer 7

Hi Gila,

thanks for your assist, before i was working 2 yrs in mysql as jr.dba, now my present job is in SQL SERVER 2008.

i have referred msdn for basics but its not in depth articles regarding the following topics.

diva.mayas Mr or Mrs. 500 Points: 569 More actions · Answer 8

continuing the following,

can anybody share which book to refer or links for the following topics.

Here also i need book which specifies the internal working in depth knowledge is shared

Topics:

1.Backup & Recovery

2.Tunning

3.High Avilability

4.High scalability

5.High security

6.Disaster recovery

7.High Monitoring - mulitple instances with multiple database in distributed data center

Thanks in advance.

Regards

Dhiva

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

Have you read through Books Online? There's info on all of those in there (well, except no 7)

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

RichardDouglas SSCarpal Tunnel Points: 4029 More actions · Answer 10

I would add "Professional SQL Server 2008 Internals and Troubleshooting" to the list alongside Kalens book, I've been reading through it over the last few weeks and it is excellent.

Hope this helps,
Rich

[p]
[/p]

Richellere SSC Eights! Points: 902 More actions · Answer 11

Hi,

When i was new to SQL Server, I started with BOL. It's a good place to start and you can find almost everything there except from undocumented functionalities.

If I had to start today, I would go the same way, before moving to a Book like SQL Server 2008 internals.

Hope this helps.

Richellère