Post reply

SharePoint 07 - Check if UPDATE STATISTICS run automatically

  • October 22, 2009 at 8:02 am

    #136876

    I am running SharePoint MOSS07 and have heard it runs SS UPDATE STATISTICS automatically on a recurring schedule in the background.

    I need to confirm this through MSSQL (SSMS or other tool). If it does not do it, or do it frequently enough, I need to schedule this myself as part of my normal Maintenance Plan activities.

    I would assume one of the logs will show this being run as a process on a system DB or one of the SharePoint DBs.

    Does anyone know?

    Zee (Atlanta)

  • October 22, 2009 at 8:15 am

    #1069453

    Oprn SSMS right click on the database name, select Properties, in the next window select Options, expand if necessary the heading automatic it should show you there.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • October 22, 2009 at 12:42 pm

    #1069605

    This query will tell you when stats were last updated for a table:

    select 'index name' = i.name,

    'stats date' = stats_date(i.id,i.indid)

    from sysobjects o, sysindexes i

    where o.name = 'g_batch_audit' and o.id = i.id

    SQL2000 format but pretty sure it works in 2005.

    there is also the DBCC show statistics command.

    If you are not doing it and auto stats is not on, MOSS must be.

    ---------------------------------------------------------------------

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply