Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Page Splits /Sec Expand / Collapse
Author
Message
Posted Thursday, December 12, 2013 12:06 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
Hi all

Regarding the Page Splits /Sec counter, this tracks the amount of page splits per second as well as the amount of new pages allocated per second, correct?

If that's the case, what does the Pages Allocated/sec counter indicate and why, on my instance would it be more than the Page Splits /Sec counter?

Thanks
Post #1522160
Posted Thursday, December 12, 2013 6:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
This might help you....

http://www.quest.com/techbrief/sql-server-perfmon-counters-poster811635.aspx



---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1522264
Posted Thursday, December 12, 2013 6:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
Thanks for the link, it doesn't help however.

I'm looking for the difference between the 2 counters.
Post #1522270
Posted Thursday, December 12, 2013 7:28 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 11:16 AM
Points: 604, Visits: 503
Forgive my stab at this, but page splits happen when data cannot fit in the page it's aiming for and a new page has to be allocated if I remember correctly. that being said, all page splits cause a page allocation, but not all page allocations are inherently splits. Can someone with a bit more of a background check this for me?

.
Post #1522309
Posted Thursday, December 12, 2013 11:55 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:20 AM
Points: 1,375, Visits: 2,661
So all page splits cause a page allocation but not all page allocations stem from a page split?

Post #1522584
Posted Friday, December 13, 2013 6:49 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 11:16 AM
Points: 604, Visits: 503
That's my understanding of it. A page split is when a record cannot fit on the page it's designated for. Not all page allocations come from splits. Page splits are not always bad. Here's a good link on the subject.

.
Post #1522668
Posted Friday, December 13, 2013 6:53 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 5:04 PM
Points: 2,107, Visits: 3,581
And another good article - http://www.sqlskills.com/blogs/paul/tracking-page-splits-using-the-transaction-log/

And when you are done with that one if you want to read more on page splits and page allocations search Google for "Paul Randal Page Splits" or "page allocations".


David

@SQLTentmaker
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Post #1522671
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse