We help IT Professionals succeed at work.

reduce page splits

rgb192
rgb192 asked
on
Medium Priority
339 Views
Last Modified: 2012-06-22
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
Comment
Watch Question

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.
What is your OS and It is 32/64 bit?
 What is your RAM size in server?

Author

Commented:
server windows server 2008 64 bit with 8gig of ram but low cpu

my computer is freezing
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
thanks
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.