The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
2answers
53 views

Analyse what caused a pagesplit afterwards?

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 ...
2
votes
1answer
58 views

Why only 8kb per page?

I just want to know how they came to 8kb when striking a balance between: smaller page = more page splits bigger page = longer to look through to find value I expect there are many more pros and cons ...
1
vote
2answers
2k views

Page Break is splitting in the middle of a single row in SSRS

I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on ...
3
votes
1answer
140 views

Page Split Timing

So, imagine I have a page that I intend to cause to split. USE master ; GO IF DATABASEPROPERTYEX (N'Pages', N'Version') > 0 BEGIN ALTER DATABASE Pages SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ...
7
votes
1answer
492 views

B-tree node split strategy in SQL Server for monotonically increasing value

Consider a B-tree index on a value that will always increase monotonically, e.g. a column of type IDENTITY. With a conventional B-tree implementation, whenever a node is full, it will be split 50%/50% ...