Popular Posts

  • Backup Plans for Data Loss
    SQLServerCentral » Latest topics Backup Plans for Data Loss Comments posted to this topic are about the item [B] Backup Plans for D...
  • A New New World
    SQLServerCentral » Latest topics A New New World Comments posted to this topic are about the item [B] A New New World [/B] more in...
  • What is hyperconvergence?
    Network World Data Center What is hyperconvergence? Hyperconvergence is an IT framework that combines storage, computing and net...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Monday, November 13, 2017

OLA Maintence JOb (index defrag) stuck

SQLServerCentral » Latest topics
OLA Maintence JOb (index defrag) stuck
Dear all,

I have implemented OLA Maintenance (index defrag) job as per below:

Runs the following command in the database dwhLogging: EXECUTE dbo.IndexOptimize
 @Databases = 'DB1, DB", etc...',
 @FragmentationLow =
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)