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)
    Microsoft.UpdateServices.Internal.BaseApi.ComputerTarget.GetById(String id)
    at Microsoft.UpdateServices.Internal.BaseApi.UpdateEvent.GetComputer()
    start, DateTime end, String GroupName)
    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.

    Chris, Jul 21, 2008
    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 C, Jul 21, 2008
    1. Advertisements

  3. Chris

    Rob C Guest

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

    Rob C, Jul 21, 2008
  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
    Also, the services are running ok.
    Chris, Jul 22, 2008
  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.


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

    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:

    Les Connor [SBS MVP], Jul 22, 2008
  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 C, Jul 22, 2008
  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:

    Les Connor [SBS MVP], Jul 22, 2008
  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 C, Jul 22, 2008
  10. We've seen it before 948110 has been installed, so that IMHO isn't the

    Susan Bradley, Jul 22, 2008
  11. Chris

    Rob C Guest


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


    Rob C, Jul 23, 2008
  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



    Chris, Jul 23, 2008
  13. Chris

    Chris Guest


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

    Back to square one...


    Chris, Jul 24, 2008
  14. Chris

    Rob C Guest

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


    Rob C, Jul 24, 2008
  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
  16. Chris

    Chris Guest


    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
  17. Chris

    Rob C Guest

    Hi Chris and Shane,

    I started another thread.


    Rob C, Jul 25, 2008
  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...


    -- 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(),
    INSERT @work_to_do
    , index_id
    , avg_page_space_used_in_percent
    , avg_fragmentation_in_percent
    , record_count
    sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL,
    'SAMPLED') AS f
    (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

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

    SELECT @numpages = sum(ps.used_page_count)
    @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)
    FETCH NEXT FROM curIndexes
    INTO @objectid, @indexid, @density, @fragmentation, @numrows;

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

    @indexname = QUOTENAME(name)
    , @fillfactorset = CASE fill_factor WHEN 0 THEN 0 ELSE 1 END
    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)';
    SET @command = N'ALTER INDEX ' + @indexname + N' ON ' +
    @schemaname + N'.' + @objectname + N' REBUILD';
    PRINT convert(nvarchar, getdate(), 121) + N' Executing: ' +
    EXEC (@command);
    PRINT convert(nvarchar, getdate(), 121) + N' Done.';

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

    IF EXISTS (SELECT * FROM @work_to_do)
    PRINT 'Estimated number of pages in fragmented indexes: ' + cast
    (@numpages as nvarchar(20))
    SELECT @numpages = @numpages - sum(ps.used_page_count)
    @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

    --Update all statistics
    PRINT 'Updating all statistics.' + convert(nvarchar, getdate(), 121)
    EXEC sp_updatestats
    PRINT 'Done updating statistics.' + convert(nvarchar, getdate(), 121)
    Duncan McC, Jul 28, 2008
  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.


    Chris, Jul 28, 2008
  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 Bell Ireland, Jul 28, 2008
    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.