Analyse what caused a pagesplit afterwards?

0 votes

2 answers

616 views

sql-server-2008-r2 page-splits

                          Ok normally we have 0-20 page splits per second, but last night it spiked to ~500.

Now is there any way to figure out what caused it?

I know i can run the following to find mid page splits but it doesn't go that far back.

    SELECT COUNT(1) AS NumberOfSplits, AllocUnitName, Context FROM fn_dblog(NULL,NULL) WHERE Operation = 'LOP_DELETE_SPLIT' GROUP BY AllocUnitName, Context ORDER BY NumberOfSplits DESC

I have both full backups and log backups if that helps?

Asked by Peter (287 rep)

Jul 17, 2014, 06:28 AM
Last activity: Jul 17, 2014, 02:31 PM

Analyse what caused a pagesplit afterwards?

Related Questions