Does DBREINDEX run longer on tables with lower scan density

I am looking into a way to generate and execute DBCC DBREINDEX statements
during scheduled down time. For a particular table - I need to be able to
estimate how long it will take to REINDEX a particular table.
Let say for example I have a table that had 25000 extents and
1) the ScanDensity was 50.
2) the ScanDensity was 15.
Would it take SIGNIFICANTLY longer to REINDEX the table if it had a
ScanDensity of 15 (as opposed to 50)?
Thanks in advance
Tom-- TJTODD wrote: --
> Would it take SIGNIFICANTLY longer to REINDEX the table if it had a
> ScanDensity of 15 (as opposed to 50)?
--
Hi Tom,
I have not found any official documentation on this area. The only way to find out is to do your own empirical benchmarks.
Hope this helps,
-Eric Cárdenas
SQL Server support|||Tom,
The only thing I can think of is that it will obviously take longer time for SQL Server to scan the
source data if the scan density is low. I'd think that in the whole, this would count as marginal,
though.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"TJTODD" <Thxomasx.Toddy@.Siemensx.com> wrote in message
news:OzZlndSuDHA.2304@.tk2msftngp13.phx.gbl...
> I am looking into a way to generate and execute DBCC DBREINDEX statements
> during scheduled down time. For a particular table - I need to be able to
> estimate how long it will take to REINDEX a particular table.
> Let say for example I have a table that had 25000 extents and
> 1) the ScanDensity was 50.
> 2) the ScanDensity was 15.
> Would it take SIGNIFICANTLY longer to REINDEX the table if it had a
> ScanDensity of 15 (as opposed to 50)?
> Thanks in advance
> Tom
>

Does anyone know how often the sysjobschedules table is updated?

Hi,
I'm trynig to write some simple code to check that all of my scheduled jobs have completed (successfully or not) by checking that the next run date and time for the active schedules is in the future. However when doing this the sysjobschedules tables
does not seem to update with the next information immediately. Does anynoe know of the frequency of this update or what controls it?
Cheers,
John
You might want to take a look at sp_help_job instead.
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John

Does anyone know how often the sysjobschedules table is updated?

Hi,
I'm trynig to write some simple code to check that all of my scheduled jobs
have completed (successfully or not) by checking that the next run date and
time for the active schedules is in the future. However when doing this the
sysjobschedules tables
does not seem to update with the next information immediately. Does anynoe
know of the frequency of this update or what controls it?
Cheers,
JohnYou might want to take a look at sp_help_job instead.
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John

Does anyone know how often the sysjobschedules table is updated?

Hi
I'm trynig to write some simple code to check that all of my scheduled jobs have completed (successfully or not) by checking that the next run date and time for the active schedules is in the future. However when doing this the sysjobschedules tables does not seem to update with the next information immediately. Does anynoe know of the frequency of this update or what controls it
Cheers
JohnYou might want to take a look at sp_help_job instead.
--
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John