• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

reduce page splits

I went to link and still dont understand how to reduce page splits
is there an easier way





Page splits are currently accounting for 100% of all new page allocations.

Recommendation:
It is recommended that the fill factor be lowered on indexes that are experiencing a high number of page splits. This will result in better insert and update performance.
 
Learn more about: http://www.sql-server-performance.com/faq/reduce_page_splits_p1.aspx
0
rgb192
Asked:
rgb192
  • 2
  • 2
1 Solution
 
devlab2012Commented:
It seems that you are not clear about what a page-split is, that why you are worried about it. In your case, I think that there is no issue with page splits.

When you insert data to a table, it page split occurs very often (or a new page is allocated) then it is a problem. A new page is allocated only when there is not enough space on some existing page. And while inserting record into a table, if a new page is allocated it will be accompanied by a page split.
Page split means that when a new page is allocated, half of data from some existing page is shifted to the new page. It is quite common during a new page allocation.
0
 
radcaesarCommented:
What is your OS and It is 32/64 bit?
 What is your RAM size in server?
0
 
rgb192Author Commented:
server windows server 2008 64 bit with 8gig of ram but low cpu

my computer is freezing
0
 
radcaesarCommented:
you should have faster CPU for this.

OK, try rebuild your indexes in a regular basis and that will solve your problem.
0
 
rgb192Author Commented:
thanks
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now