MSSQL$SBSMONITORING - problem since KB948110 install

Discussion in 'Windows Small Business Server' started by Chris, Jul 21, 2008.

  1. Chris

    Chris Guest

    I have had SBS Monitoring and Reorting running fine for months but the last
    week it has not produced a single daily performance report. The email is
    sent but just says 'Page cannot be dispayed'. Same error when I try running
    it in Server Management.

    I've tried the suggested solutions such as restarting the server, which in
    the past has resolved the issue, but still the same error. I'm sure it has
    happened since installing the KB948110 update to MSDE 2000 SQL databases.

    When I upgraded to R2, I recall the SBSMONITORING instance didn't support
    SQL 2005, has this changed now? Can I run it from SQL 2005 instead?

    If not, does anyone have any similar issues with this update?

    Event Viewer shows an error (Event ID:1) just after 6am when email is due:
    Server Status Report:
    URL: http://localhost/monitoring/perf.aspx?reportMode=1&allHours=1
    Error Message: The specified item could not be found in the database.
    Stack Trace: at
    Microsoft.UpdateServices.Internal.DatabaseAccess.AdminDataAccess.ExecuteSPGetComputerById(String id)
    at
    Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String id)
    at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
    at
    Microsoft.SBS.UpdateServices.DataProvider.GetUpdateInstallationCount(DateTime
    start, DateTime end, String GroupName)
    at
    Microsoft.SBS.UpdateServices.StatusPage.Utility.GetInstalledItemCountByGroup(DataProvider dataProvider, WSUS_GROUPS groupID)
    at Microsoft.SBS.UpdateServices.StatusPage.Utility.GetUpdateSettings()
    at usage.frmPerf.renderReportWorker()
    at usage.frmPerf.renderReport()

    Any help much appreciated.
    Thanks

    Chris
     
    Chris, Jul 21, 2008
    #1
    1. Advertisements

  2. Chris

    Rob C Guest

    Hi chris,

    Exactly the same issue here on 2x SBS servers. I didn't know it was related
    to the kb install.
    -Would appreciate soem advice from those in the know.

    Rob.
     
    Rob C, Jul 21, 2008
    #2
    1. Advertisements

  3. Chris

    Rob C Guest

    Hi Russ, thanks for the info.
    Both my instances, companyweb is fine, just monitoring that's munged.
    Anomally?

    Rob.
     
    Rob C, Jul 21, 2008
    #3
  4. Chris

    Chris Guest

    Hi Joseph,
    Thanks for yuor reply. I think the SQL Service Manager only handles SQL
    server instances and not MSDE 2000 ones, which my SBSMONITORING database runs
    on.
    Also, the services are running ok.
    Thanks
    Chris
     
    Chris, Jul 22, 2008
    #4
  5. Chris

    Chris Guest

    Hi Les,
    You say you have the same issue with the SBS Reporting but if you reboot the
    server does it start working ok again? I've this issue on average once a
    month but after a reboot the report runs ok again. That was until this week
    after the KB install and now it won't run the report even after a reboot.

    I understand your point about WSUS, but my WSUS console runs fine, reports
    included. I know SBS does some funny integration of WSUS into the Server
    Manager but it's a shame the whole monitoring and reporting function fails
    when it comes across an error.

    I'll try uninstalling the KB fix to day to see if that helps.
    Regards

    Chris

     
    Chris, Jul 22, 2008
    #5
  6. WSUS continues to work fine, it's just the monitoring report that isn't
    generating.

    There's a lot of this going on at the moment. In many cases, the issue is
    random - some days the report is fine, others not. Logging onto the server
    and generating a report most often works, but sometimes not. A restart isn't
    a practical resolution, or even a resolution at all.

    I don't have the latest updates installed, and am still seeing random
    failures of the report, averaging 30% of my installed SBS customers.

    --
    Les Connor [SBS MVP]
    ________________________
    Get the SBS BPA here:
    http://support.microsoft.com/kb/940439/en-us


     
    Les Connor [SBS MVP], Jul 22, 2008
    #6
  7. Chris

    Rob C Guest

    With the two servers I am experiancing the issue with, they both failed on
    the same day. 14th July fine, and the 15th onwards caput. I cannot tally this
    with any update at that time.

    Rob.

     
    Rob C, Jul 22, 2008
    #7
  8. What anti-virus product do you folks have installed, where you're seeing
    this issue?

    --
    Les Connor [SBS MVP]
    ________________________
    Get the SBS BPA here:
    http://support.microsoft.com/kb/940439/en-us


     
    Les Connor [SBS MVP], Jul 22, 2008
    #8
  9. Chris

    Rob C Guest

    Interesting you mention Antivirus.
    They run AVG 7.5 Network edition. Another SBS server I admin has the same
    AVG but is working fine. All three SBS's are R2 Exchange SP2.
    I just noticed I have not run KB948110 on the server that WSUS is functioning.
    It must be this that is causing it.
    Safe to uninstall the KB from affected machines?

    Rob.

     
    Rob C, Jul 22, 2008
    #9
  10. We've seen it before 948110 has been installed, so that IMHO isn't the
    trigger.

     
    Susan Bradley, Jul 22, 2008
    #10
  11. Chris

    Rob C Guest

    Chris,

    Did you uninstall the kb and has it fixed the problem?

    Rob.

     
    Rob C, Jul 23, 2008
    #11
  12. Chris

    Chris Guest

    Hi Rob C,

    I did uninstall but it hasn't been rebooted (it didn't ask to be). It
    didn't resolve the issue.

    I'll try rebooting tonight and see if that helps. Will report back in the
    morning.

    Regards

    Chris


     
    Chris, Jul 23, 2008
    #12
  13. Chris

    Chris Guest

    Hi,

    Tried uninstalling the KB and rebooted but the report still doesn't run.

    Back to square one...

    Chris


     
    Chris, Jul 24, 2008
    #13
  14. Chris

    Rob C Guest

    Shame.
    Thanks for the info.
    -When did reports yours cease to function? Was it 15th July like both of mine?

    Rob.

     
    Rob C, Jul 24, 2008
    #14
  15. Chris

    Shane Guest

    Thats the same day mine stopped working. The only thing that changed before
    that day way I installed a users iphone to connect with exchange push mail.
     
    Shane, Jul 24, 2008
    #15
  16. Chris

    Chris Guest

    Hi,

    No mine stopped running on sometime between Saturday 12th 6am and Sunday
    13th 6am because the report I received on Saturday was ok, but Sunday at 6am
    it had stopped working and hasn't run since.

    It also didn't run on Friday 11th, but when it started running on Saturday
    12th I thought it was a temporary issue which had resolved.

    Are you any further forward on this one?


     
    Chris, Jul 25, 2008
    #16
  17. Chris

    Rob C Guest

    Hi Chris and Shane,

    I started another thread.
    http://www.microsoft.com/communitie...&p=1&tid=5e888765-8509-4c65-862b-3d5dd7b997f4

    Rob

     
    Rob C, Jul 25, 2008
    #17
  18. Chris

    Duncan McC Guest

    Have you tried a database cleanup and optimise?

    Can't seem to find the MS page I got the script from, but it was in the
    WSUS area somewhere. Here's the sql script anyways...

    USE SUSDB;
    GO
    SET NOCOUNT ON;

    -- Rebuild or reorganize indexes based on their fragmentation levels
    DECLARE @work_to_do TABLE (
    objectid int
    , indexid int
    , pagedensity float
    , fragmentation float
    , numrows int
    )

    DECLARE @objectid int;
    DECLARE @indexid int;
    DECLARE @schemaname nvarchar(130);
    DECLARE @objectname nvarchar(130);
    DECLARE @indexname nvarchar(130);
    DECLARE @numrows int
    DECLARE @density float;
    DECLARE @fragmentation float;
    DECLARE @command nvarchar(4000);
    DECLARE @fillfactorset bit
    DECLARE @numpages int

    -- Select indexes that need to be defragmented based on the following
    -- * Page density is low
    -- * External fragmentation is high in relation to index size
    PRINT 'Estimating fragmentation: Begin. ' + convert(nvarchar, getdate(),
    121)
    INSERT @work_to_do
    SELECT
    f.object_id
    , index_id
    , avg_page_space_used_in_percent
    , avg_fragmentation_in_percent
    , record_count
    FROM
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL,
    'SAMPLED') AS f
    WHERE
    (f.avg_page_space_used_in_percent < 85.0 and
    f.avg_page_space_used_in_percent/100.0 * page_count < page_count - 1)
    or (f.page_count > 50 and f.avg_fragmentation_in_percent > 15.0)
    or (f.page_count > 10 and f.avg_fragmentation_in_percent > 80.0)

    PRINT 'Number of indexes to rebuild: ' + cast(@@ROWCOUNT as nvarchar
    (20))

    PRINT 'Estimating fragmentation: End. ' + convert(nvarchar, getdate(),
    121)

    SELECT @numpages = sum(ps.used_page_count)
    FROM
    @work_to_do AS fi
    INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and
    fi.indexid = i.index_id
    INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id =
    ps.object_id and i.index_id = ps.index_id

    -- Declare the cursor for the list of indexes to be processed.
    DECLARE curIndexes CURSOR FOR SELECT * FROM @work_to_do

    -- Open the cursor.
    OPEN curIndexes

    -- Loop through the indexes
    WHILE (1=1)
    BEGIN
    FETCH NEXT FROM curIndexes
    INTO @objectid, @indexid, @density, @fragmentation, @numrows;
    IF @@FETCH_STATUS < 0 BREAK;

    SELECT
    @objectname = QUOTENAME(o.name)
    , @schemaname = QUOTENAME(s.name)
    FROM
    sys.objects AS o
    INNER JOIN sys.schemas as s ON s.schema_id = o.schema_id
    WHERE
    o.object_id = @objectid;

    SELECT
    @indexname = QUOTENAME(name)
    , @fillfactorset = CASE fill_factor WHEN 0 THEN 0 ELSE 1 END
    FROM
    sys.indexes
    WHERE
    object_id = @objectid AND index_id = @indexid;

    IF ((@density BETWEEN 75.0 AND 85.0) AND @fillfactorset = 1) OR
    (@fragmentation < 30.0)
    SET @command = N'ALTER INDEX ' + @indexname + N' ON ' +
    @schemaname + N'.' + @objectname + N' REORGANIZE';
    ELSE IF @numrows >= 5000 AND @fillfactorset = 0
    SET @command = N'ALTER INDEX ' + @indexname + N' ON ' +
    @schemaname + N'.' + @objectname + N' REBUILD WITH (FILLFACTOR = 90)';
    ELSE
    SET @command = N'ALTER INDEX ' + @indexname + N' ON ' +
    @schemaname + N'.' + @objectname + N' REBUILD';
    PRINT convert(nvarchar, getdate(), 121) + N' Executing: ' +
    @command;
    EXEC (@command);
    PRINT convert(nvarchar, getdate(), 121) + N' Done.';
    END

    -- Close and deallocate the cursor.
    CLOSE curIndexes;
    DEALLOCATE curIndexes;


    IF EXISTS (SELECT * FROM @work_to_do)
    BEGIN
    PRINT 'Estimated number of pages in fragmented indexes: ' + cast
    (@numpages as nvarchar(20))
    SELECT @numpages = @numpages - sum(ps.used_page_count)
    FROM
    @work_to_do AS fi
    INNER JOIN sys.indexes AS i ON fi.objectid = i.object_id and
    fi.indexid = i.index_id
    INNER JOIN sys.dm_db_partition_stats AS ps on i.object_id =
    ps.object_id and i.index_id = ps.index_id

    PRINT 'Estimated number of pages freed: ' + cast(@numpages as
    nvarchar(20))
    END
    GO


    --Update all statistics
    PRINT 'Updating all statistics.' + convert(nvarchar, getdate(), 121)
    EXEC sp_updatestats
    PRINT 'Done updating statistics.' + convert(nvarchar, getdate(), 121)
    GO
     
    Duncan McC, Jul 28, 2008
    #18
  19. Chris

    Chris Guest

    Hi Duncan,

    Many many thanks for posting a reply, running the SQL command in SQL
    Management Studio has fixed the problem for me.

    Regards

    Chris
     
    Chris, Jul 28, 2008
    #19
  20. Chris

    How did you get on. I have had the problem since 15th July(as mentioned
    previously in the post). My client has AVG 7.5 Network edition installed on
    the server if this is the problem.

    Ray.

     
    Ray Bell Ireland, Jul 28, 2008
    #20
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.