Sfrgttk

What does ひと匙 mean in this manga and has it been used colloquially?

How to save as into a customized destination on macOS?

How to deal with fear of taking dependencies

Identify boardgame from Big movie

Falsification in Math vs Science

What is the meaning of Triage in Cybersec world?

For what reasons would an animal species NOT cross a *horizontal* land bridge?

Reference request: Oldest number theory books with (unsolved) exercises?

Is an up-to-date browser secure on an out-of-date OS?

Loose spokes after only a few rides

Can we generate random numbers using irrational numbers like π and e?

Can a flute soloist sit?

A poker game description that does not feel gimmicky

Pokemon Turn Based battle (Python)

Why are there uneven bright areas in this photo of black hole?

Is flight data recorder erased after every flight?

Worn-tile Scrabble

How to answer pointed "are you quitting" questioning when I don't want them to suspect

Why is the Constellation's nose gear so long?

What to do when moving next to a bird sanctuary with a loosely-domesticated cat?

Should I use my personal e-mail address, or my workplace one, when registering to external websites for work purposes?

What is the accessibility of a package's `Private` context variables?

Can a rogue use sneak attack with weapons that have the thrown property even if they are not thrown?

Aging parents with no investments

SQL Server Index and Statistics Maintenance performance question

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I tried to use IndexOptimize stored procedure on a database with a very high number of indexes (> 250.000). The initial step where stored procedure collects data what needs to be processed takes hours, even if I set @Indexes parameter to narrow down the work.

SQL Server Maintenance Solution Version: 2019-02-10 10:40:47 SQL
Server 2017 Standard Edition with latest CU14 installed.

At a customer I saw a database with > 500.000 indexes. After 12 hours data collection step was still running.

I would expect if I set @Indexes to a single index execution should be started immediately.

Here is an example of my stored procedure call.

EXECUTE dbo.IndexOptimize

@Databases = 'db',

@Indexes =  'db.dbo.'

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 = 30,

@FragmentationLevel2 = 50,

@UpdateStatistics = 'ALL',

@OnlyModifiedStatistics = 'Y',

@LogToTable = 'Y',

@LockTimeout = 60

Can somebody share with me his experience in using IndexOptimize for a database with a very high number of indexes ?

ola-hallengren

share

edited 7 secs ago

EzLo

2,8151621

asked 2 mins ago

Joerg RueschenschmidtJoerg Rueschenschmidt

1

New contributor

Joerg Rueschenschmidt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I tried to use IndexOptimize stored procedure on a database with a very high number of indexes (> 250.000). The initial step where stored procedure collects data what needs to be processed takes hours, even if I set @Indexes parameter to narrow down the work.

SQL Server Maintenance Solution Version: 2019-02-10 10:40:47 SQL
Server 2017 Standard Edition with latest CU14 installed.

At a customer I saw a database with > 500.000 indexes. After 12 hours data collection step was still running.

I would expect if I set @Indexes to a single index execution should be started immediately.

Here is an example of my stored procedure call.

EXECUTE dbo.IndexOptimize

@Databases = 'db',

@Indexes =  'db.dbo.'

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 = 30,

@FragmentationLevel2 = 50,

@UpdateStatistics = 'ALL',

@OnlyModifiedStatistics = 'Y',

@LogToTable = 'Y',

@LockTimeout = 60

Can somebody share with me his experience in using IndexOptimize for a database with a very high number of indexes ?

ola-hallengren

share

edited 7 secs ago

EzLo

2,8151621

asked 2 mins ago

Joerg RueschenschmidtJoerg Rueschenschmidt

1

New contributor

Joerg Rueschenschmidt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I tried to use IndexOptimize stored procedure on a database with a very high number of indexes (> 250.000). The initial step where stored procedure collects data what needs to be processed takes hours, even if I set @Indexes parameter to narrow down the work.

SQL Server Maintenance Solution Version: 2019-02-10 10:40:47 SQL
Server 2017 Standard Edition with latest CU14 installed.

At a customer I saw a database with > 500.000 indexes. After 12 hours data collection step was still running.

I would expect if I set @Indexes to a single index execution should be started immediately.

Here is an example of my stored procedure call.

EXECUTE dbo.IndexOptimize

@Databases = 'db',

@Indexes =  'db.dbo.'

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 = 30,

@FragmentationLevel2 = 50,

@UpdateStatistics = 'ALL',

@OnlyModifiedStatistics = 'Y',

@LogToTable = 'Y',

@LockTimeout = 60

Can somebody share with me his experience in using IndexOptimize for a database with a very high number of indexes ?

ola-hallengren

share

edited 7 secs ago

EzLo

2,8151621

asked 2 mins ago

Joerg RueschenschmidtJoerg Rueschenschmidt

1

New contributor

Joerg Rueschenschmidt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

EXECUTE dbo.IndexOptimize

@Databases = 'db',

@Indexes =  'db.dbo.'

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 = 30,

@FragmentationLevel2 = 50,

@UpdateStatistics = 'ALL',

@OnlyModifiedStatistics = 'Y',

@LogToTable = 'Y',

@LockTimeout = 60

share

edited 7 secs ago

EzLo

2,8151621

asked 2 mins ago

Joerg RueschenschmidtJoerg Rueschenschmidt

1

New contributor

Joerg Rueschenschmidt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

edited 7 secs ago

EzLo

2,8151621

asked 2 mins ago

Joerg RueschenschmidtJoerg Rueschenschmidt

1

New contributor

Joerg Rueschenschmidt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 7 secs ago

EzLo

2,8151621

edited 7 secs ago

EzLo

2,8151621

asked 2 mins ago

Joerg RueschenschmidtJoerg Rueschenschmidt

1

New contributor

Joerg Rueschenschmidt is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

Joerg RueschenschmidtJoerg Rueschenschmidt

1