Page Splits

Question

Page Splits

Trainee SQL

Say Hey Kid

Points: 666
More actions
November 9, 2013 at 7:06 am

#279009

Hiii guys....
I am having a problem in understanding Page Splits i have gone through various site non of them gave me any clear clarification kindly help me to get a clear clarification on Page Splits.
Regards
Surya

Viewing 5 posts - 1 through 4 (of 4 total)

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

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

That'll require half an article to explain from start to finish. Any specifics you want clearing up?

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

Trainee SQL Say Hey Kid Points: 666 More actions · Answer 2

Hiiiii Gail Shaw,

i need some information to start up please help to find the information on it. Regarding articles and if possible vedio tutorials

Regards

Surya

George M Parker SSCertifiable Points: 5412 More actions · Answer 3

As Gail indicated, that's a pretty large topic to cover without more details about what it is you're after. In my humble opinion, Kimberly Tripp is the reigning expert at explaining how page splits work and how they can impact performance. Do an internet search on her name, SQLSkills, Paul Randal and page splits and you'll come up with a lot of good information.

They also put together a series of MCM videos that you can access here: http://www.sqlskills.com/sql-server-resources/sql-server-mcm-training-videos/. It's pretty advanced stuff but should give you an idea of what page splits are and how they can lead to index fragmentation and performance problems. Specifically, look at the ones on internals and indexes.

And if you can afford it, Pluralsight has many more great training videos and no DBA or DB Developer should be without a copy of the SQL Server internals book that Kalen Delaney puts out.

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

Should be in one of these:

http://technet.microsoft.com/en-us/sqlserver/gg313760.aspx

http://technet.microsoft.com/en-us/sqlserver/gg508878.aspx

I don't offhand know of any articles specifically on page splits and I'm sure you can google as well as I can.

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