Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making use of dates in index
Message
 
 
À
02/05/2011 23:11:20
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01509138
Message ID:
01509159
Vues:
30
>>Are you running the latest version (the one with the baby picture)? I believe it worked fine for me.
>
>Ok, I found it. I ran it and I see it creates two tables.
>
>dba_indexDefragLog Table Created
>dba_indexDefragExclusion Table Created
>
>Those tables are empty. Is there something else that need to be run?

Did you run the actual procedure dbo.dba_indexDefrag_sp? Read up the parameters at the top to see how you should call it.
Example of how to call this script:
 
        Exec dbo.dba_indexDefrag_sp
              @executeSQL           = 1
            , @printCommands        = 1
            , @debugMode            = 1
            , @printFragmentation   = 1
            , @forceRescan          = 1
            , @maxDopRestriction    = 1
            , @minPageCount         = 8
            , @maxPageCount         = Null
            , @minFragmentation     = 1
            , @rebuildThreshold     = 30
            , @defragDelay          = '00:00:05'
            , @defragOrderColumn    = 'page_count'
            , @defragSortOrder      = 'DESC'
            , @excludeMaxPartition  = 1
            , @timeLimit            = Null;
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform