Advertisement
Guest User

Untitled

a guest
Sep 24th, 2017
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. EXEC master.dbo.IndexOptimize @Databases = 'USER_DATABASES',
  2. @FragmentationMedium = 'INDEX_REORGANIZE',
  3. @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REORGANIZE',
  4. @FragmentationLevel1 = 50,
  5. @FragmentationLevel2 = 80,
  6. @PageCountLevel = 5000,
  7. @UpdateStatistics = 'ALL',
  8. @OnlyModifiedStatistics = 'Y',
  9. @LogToTable = 'Y';
  10.  
  11. EXEC master.dbo.IndexOptimize @Databases = 'USER_DATABASES',
  12. @FragmentationMedium = 'INDEX_REORGANIZE',
  13. @FragmentationHigh = 'INDEX_REBUILD_OFFLINE,INDEX_REORGANIZE',
  14. @FragmentationLevel1 = 50,
  15. @FragmentationLevel2 = 80,
  16. @PageCountLevel = 5000,
  17. @UpdateStatistics = 'ALL',
  18. @OnlyModifiedStatistics = 'Y',
  19. @LogToTable = 'Y';
  20.  
  21. EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES',
  22. @FragmentationLow = NULL,
  23. @FragmentationMedium = NULL,
  24. @FragmentationHigh = NULL,
  25. @UpdateStatistics = 'ALL',
  26. @OnlyModifiedStatistics = 'Y',
  27. @StatisticsSample = NULL,
  28. @LogToTable = 'Y';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement