Results 1 to 3 of 3

Thread: Ms-sql

  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: SP_UPDATESTATS

    Hi
    We have a MS-SQL dB that is more than 300 gb and have some performance problems.
    One of the problems is, that the system do not automatically update statistics.
    In the test system, which is a copy of production we have run sp_updatestats and all the tables and index is updated but when we run sp_updatestats in production, it return normally after one hour but it do not update all tables and index ??
    Regards
    John
    Last edited by Kalle; 01-18-04 at 15:18.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Are you running this at a time frame that sql server is the least utilized (like between midnight and 4 a.m. - depending on your business model) ? Also, what is the output generated when you run sp_updatestats ? How do you know that it is not updating the statistics for all tables ?

  3. #3
    Join Date
    Jan 2004
    Posts
    2
    Hi
    The sp_updatestats was running Saturday, while the system performance is low.
    The output was “statistics for all tables have been updated”

    The application (SAP), have some dB information reports and it is possible to get information on tables and index. In the test system SAP reports, that the statistics is updated but not in the production.

    When I make the following sql in the production and in the test system:

    select * from sysobjects so, sysindexes si where so.name = 'KNA1' and si.name like 'KNA1% Z'

    I can see, that the number in the rows column is zero. I expect that the number is different from zero.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •