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, April 11, 2014 6:51 AM
Points: 1,371, Visits: 2,590
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: Today @ 4:45 AM
Points: 2,385, Visits: 1,843
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, April 11, 2014 6:51 AM
Points: 1,371, Visits: 2,590
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: Today @ 9:57 AM
Points: 604, Visits: 473
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, April 11, 2014 6:51 AM
Points: 1,371, Visits: 2,590
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: Today @ 9:57 AM
Points: 604, Visits: 473
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: Yesterday @ 3:20 PM
Points: 2,105, Visits: 3,560
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