How do I reduce the page fullness on Indexes?

Posted on 2011-10-03
Last Modified: 2012-05-12
I have a database with a table that has an index that has a Page Fullness of 94.12 %. I don't really understand what that means but I keep having issues with this table and it times out at random times during the day. Could this be the cause and if so how do I reduce this number? I tired Rebuild and Reorganize but it does not change. I am using Microsoft SQL Server Management Tools 2008 R2.

Question by:seanlhall
    LVL 11

    Expert Comment

    by:David Kroll
    Do you have proper indexes on the table?
    LVL 32

    Expert Comment

    by:Daniel Wilson
    Do you do inserts or updates on this table that would be changing what's in that index?

    For example, if your index is on an Identity (autonumber) field, changes to the table or additions to it really won't cause index re-organization.  If the index is on ZipCode ... additional records could definitely fill up some index pages.  Or changes to the ZipCode field could do the same.

    And the queries that are timing out ... are they update or insert queries?

    Basically, my thought is that index pages filling up is not often the cause of a performance problem, so it's better to make sure we're chasing the right problem before we continue the chase.

    Author Comment

    I have one index for my tblsubject. The PK is subjectId. The index was set to unique not Primary Key. I changed it to Primary Key and things are working now. Are the indexes created automatically?
    LVL 11

    Accepted Solution

    No, you have to assign the PK.

    Author Closing Comment

    This was part of my problem. Thanks.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now