MSSQL$SBSMONITORING - problem since KB948110 install

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

Rob.

"Chris" wrote:

> Hi,
>
> Tried uninstalling the KB and rebooted but the report still doesn't run.
>
> Back to square one...
>
> Chris
>
>
> "Rob C" wrote:
>
> > Chris,
> >
> > Did you uninstall the kb and has it fixed the problem?
> >
> > Rob.
> >
> > "Les Connor [SBS MVP]" wrote:
> >
> > > I'm getting malfunctions without the July updates (which include the one
> > > you're referencing). A/V doesn't appear to be common ground either, but I
> > > needed to check.
> > >
> > >
> > > --
> > > Les Connor [SBS MVP]
> > > ________________________
> > > Get the SBS BPA here:
> > > http://support.microsoft.com/kb/940439/en-us
> > >
> > >
> > > "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > news:E5D6B9BA-0733-4EE1-ADD2-244B941315FE@microsoft.com...
> > > > 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.
> > > >
> > > > "Les Connor [SBS MVP]" wrote:
> > > >
> > > >> 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
> > > >>
> > > >>
> > > >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > >> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> > > >> > 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.
> > > >> >
> > > >> > "Les Connor [SBS MVP]" wrote:
> > > >> >
> > > >> >> 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
> > > >> >>
> > > >> >>
> > > >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > >> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > > >> >> > 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
> > > >> >> >
> > > >> >> > "Les Connor [SBS MVP]" wrote:
> > > >> >> >
> > > >> >> >> I'm not sure the update has anything to do with the monitoring
> > > >> >> >> report
> > > >> >> >> issue.
> > > >> >> >> The monitoring report thing is happening all over the place, me
> > > >> >> >> included,
> > > >> >> >> and I don't have the updates installed at this time.
> > > >> >> >>
> > > >> >> >> There are, however, a couple of different error messages produced.
> > > >> >> >> While
> > > >> >> >> they're both WSUS related, one is a time-out and another seems to
> > > >> >> >> be
> > > >> >> >> something in the WSUS database 'not found'.
> > > >> >> >>
> > > >> >> >> The R2 monitoring report will fail entirely if there's any issue
> > > >> >> >> with
> > > >> >> >> the
> > > >> >> >> SBS Update Servcies section of the report. Shame.
> > > >> >> >>
> > > >> >> >> --
> > > >> >> >> Les Connor [SBS MVP]
> > > >> >> >> ________________________
> > > >> >> >> Get the SBS BPA here:
> > > >> >> >> http://support.microsoft.com/kb/940439/en-us
> > > >> >> >>
> > > >> >> >>
> > > >> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > >> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > > >> >> >> > Hi Russ, thanks for the info.
> > > >> >> >> > Both my instances, companyweb is fine, just monitoring that's
> > > >> >> >> > munged.
> > > >> >> >> > Anomally?
> > > >> >> >> >
> > > >> >> >> > Rob.
> > > >> >> >> >
> > > >> >> >> > "Russ (www.SBITS.Biz)" wrote:
> > > >> >> >> >
> > > >> >> >> >> This Explains it.
> > > >> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >> Russ
> > > >> >> >> >>
> > > >> >> >> >> --
> > > >> >> >> >> Russell Grover - SBITS.Biz
> > > >> >> >> >> Microsoft Gold Certified Partner
> > > >> >> >> >> Microsoft Small Business Specialist
> > > >> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> > > >> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > >> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> > > >> >> >> >> >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.asp...e=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
> > > >> >> >> >> >
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >>
> > > >> >>
> > > >>
> > >

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.
on the 14th. Probably not the problem but just thought I would see if anyone
else did this also.

"Rob C" wrote:

> 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.
>
> "Les Connor [SBS MVP]" wrote:
>
> > 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
> >
> >
> > "Chris" <Chris@discussions.microsoft.com> wrote in message
> > news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > > 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
> > >
> > > "Les Connor [SBS MVP]" wrote:
> > >
> > >> I'm not sure the update has anything to do with the monitoring report
> > >> issue.
> > >> The monitoring report thing is happening all over the place, me included,
> > >> and I don't have the updates installed at this time.
> > >>
> > >> There are, however, a couple of different error messages produced. While
> > >> they're both WSUS related, one is a time-out and another seems to be
> > >> something in the WSUS database 'not found'.
> > >>
> > >> The R2 monitoring report will fail entirely if there's any issue with the
> > >> SBS Update Servcies section of the report. Shame.
> > >>
> > >> --
> > >> Les Connor [SBS MVP]
> > >> ________________________
> > >> Get the SBS BPA here:
> > >> http://support.microsoft.com/kb/940439/en-us
> > >>
> > >>
> > >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > >> > Hi Russ, thanks for the info.
> > >> > Both my instances, companyweb is fine, just monitoring that's munged.
> > >> > Anomally?
> > >> >
> > >> > Rob.
> > >> >
> > >> > "Russ (www.SBITS.Biz)" wrote:
> > >> >
> > >> >> This Explains it.
> > >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> > >> >>
> > >> >>
> > >> >> Russ
> > >> >>
> > >> >> --
> > >> >> Russell Grover - SBITS.Biz
> > >> >> Microsoft Gold Certified Partner
> > >> >> Microsoft Small Business Specialist
> > >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> > >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> > >> >>
> > >> >>
> > >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> > >> >> >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.asp...e=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
> > >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >>
> >

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?


"Rob C" wrote:

> Shame.
> Thanks for the info.
> -When did reports yours cease to function? Was it 15th July like both of mine?
>
> Rob.
>
> "Chris" wrote:
>
> > Hi,
> >
> > Tried uninstalling the KB and rebooted but the report still doesn't run.
> >
> > Back to square one...
> >
> > Chris
> >
> >
> > "Rob C" wrote:
> >
> > > Chris,
> > >
> > > Did you uninstall the kb and has it fixed the problem?
> > >
> > > Rob.
> > >
> > > "Les Connor [SBS MVP]" wrote:
> > >
> > > > I'm getting malfunctions without the July updates (which include the one
> > > > you're referencing). A/V doesn't appear to be common ground either, but I
> > > > needed to check.
> > > >
> > > >
> > > > --
> > > > Les Connor [SBS MVP]
> > > > ________________________
> > > > Get the SBS BPA here:
> > > > http://support.microsoft.com/kb/940439/en-us
> > > >
> > > >
> > > > "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > > news:E5D6B9BA-0733-4EE1-ADD2-244B941315FE@microsoft.com...
> > > > > 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.
> > > > >
> > > > > "Les Connor [SBS MVP]" wrote:
> > > > >
> > > > >> 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
> > > > >>
> > > > >>
> > > > >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > > >> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> > > > >> > 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.
> > > > >> >
> > > > >> > "Les Connor [SBS MVP]" wrote:
> > > > >> >
> > > > >> >> 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
> > > > >> >>
> > > > >> >>
> > > > >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > > >> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > > > >> >> > 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
> > > > >> >> >
> > > > >> >> > "Les Connor [SBS MVP]" wrote:
> > > > >> >> >
> > > > >> >> >> I'm not sure the update has anything to do with the monitoring
> > > > >> >> >> report
> > > > >> >> >> issue.
> > > > >> >> >> The monitoring report thing is happening all over the place, me
> > > > >> >> >> included,
> > > > >> >> >> and I don't have the updates installed at this time.
> > > > >> >> >>
> > > > >> >> >> There are, however, a couple of different error messages produced.
> > > > >> >> >> While
> > > > >> >> >> they're both WSUS related, one is a time-out and another seems to
> > > > >> >> >> be
> > > > >> >> >> something in the WSUS database 'not found'.
> > > > >> >> >>
> > > > >> >> >> The R2 monitoring report will fail entirely if there's any issue
> > > > >> >> >> with
> > > > >> >> >> the
> > > > >> >> >> SBS Update Servcies section of the report. Shame.
> > > > >> >> >>
> > > > >> >> >> --
> > > > >> >> >> Les Connor [SBS MVP]
> > > > >> >> >> ________________________
> > > > >> >> >> Get the SBS BPA here:
> > > > >> >> >> http://support.microsoft.com/kb/940439/en-us
> > > > >> >> >>
> > > > >> >> >>
> > > > >> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > > >> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > > > >> >> >> > Hi Russ, thanks for the info.
> > > > >> >> >> > Both my instances, companyweb is fine, just monitoring that's
> > > > >> >> >> > munged.
> > > > >> >> >> > Anomally?
> > > > >> >> >> >
> > > > >> >> >> > Rob.
> > > > >> >> >> >
> > > > >> >> >> > "Russ (www.SBITS.Biz)" wrote:
> > > > >> >> >> >
> > > > >> >> >> >> This Explains it.
> > > > >> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> > > > >> >> >> >>
> > > > >> >> >> >>
> > > > >> >> >> >> Russ
> > > > >> >> >> >>
> > > > >> >> >> >> --
> > > > >> >> >> >> Russell Grover - SBITS.Biz
> > > > >> >> >> >> Microsoft Gold Certified Partner
> > > > >> >> >> >> Microsoft Small Business Specialist
> > > > >> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> > > > >> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> > > > >> >> >> >>
> > > > >> >> >> >>
> > > > >> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > > >> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> > > > >> >> >> >> >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.asp...e=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
> > > > >> >> >> >> >
> > > > >> >> >> >>
> > > > >> >> >> >>
> > > > >> >> >> >>
> > > > >> >> >>
> > > > >> >>
> > > > >>
> > > >

Hi Chris and Shane,

I started another thread.-
http://www.microsoft.com/communities...b-3d5dd7b997f4

Rob

"Chris" wrote:

> 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?
>
>
> "Rob C" wrote:
>
> > Shame.
> > Thanks for the info.
> > -When did reports yours cease to function? Was it 15th July like both of mine?
> >
> > Rob.
> >
> > "Chris" wrote:
> >
> > > Hi,
> > >
> > > Tried uninstalling the KB and rebooted but the report still doesn't run.
> > >
> > > Back to square one...
> > >
> > > Chris
> > >
> > >
> > > "Rob C" wrote:
> > >
> > > > Chris,
> > > >
> > > > Did you uninstall the kb and has it fixed the problem?
> > > >
> > > > Rob.
> > > >
> > > > "Les Connor [SBS MVP]" wrote:
> > > >
> > > > > I'm getting malfunctions without the July updates (which include the one
> > > > > you're referencing). A/V doesn't appear to be common ground either, but I
> > > > > needed to check.
> > > > >
> > > > >
> > > > > --
> > > > > Les Connor [SBS MVP]
> > > > > ________________________
> > > > > Get the SBS BPA here:
> > > > > http://support.microsoft.com/kb/940439/en-us
> > > > >
> > > > >
> > > > > "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > > > news:E5D6B9BA-0733-4EE1-ADD2-244B941315FE@microsoft.com...
> > > > > > 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.
> > > > > >
> > > > > > "Les Connor [SBS MVP]" wrote:
> > > > > >
> > > > > >> 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
> > > > > >>
> > > > > >>
> > > > > >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > > > >> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> > > > > >> > 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.
> > > > > >> >
> > > > > >> > "Les Connor [SBS MVP]" wrote:
> > > > > >> >
> > > > > >> >> 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
> > > > > >> >>
> > > > > >> >>
> > > > > >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > > > >> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > > > > >> >> > 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
> > > > > >> >> >
> > > > > >> >> > "Les Connor [SBS MVP]" wrote:
> > > > > >> >> >
> > > > > >> >> >> I'm not sure the update has anything to do with the monitoring
> > > > > >> >> >> report
> > > > > >> >> >> issue.
> > > > > >> >> >> The monitoring report thing is happening all over the place, me
> > > > > >> >> >> included,
> > > > > >> >> >> and I don't have the updates installed at this time.
> > > > > >> >> >>
> > > > > >> >> >> There are, however, a couple of different error messages produced.
> > > > > >> >> >> While
> > > > > >> >> >> they're both WSUS related, one is a time-out and another seems to
> > > > > >> >> >> be
> > > > > >> >> >> something in the WSUS database 'not found'.
> > > > > >> >> >>
> > > > > >> >> >> The R2 monitoring report will fail entirely if there's any issue
> > > > > >> >> >> with
> > > > > >> >> >> the
> > > > > >> >> >> SBS Update Servcies section of the report. Shame.
> > > > > >> >> >>
> > > > > >> >> >> --
> > > > > >> >> >> Les Connor [SBS MVP]
> > > > > >> >> >> ________________________
> > > > > >> >> >> Get the SBS BPA here:
> > > > > >> >> >> http://support.microsoft.com/kb/940439/en-us
> > > > > >> >> >>
> > > > > >> >> >>
> > > > > >> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > > > >> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > > > > >> >> >> > Hi Russ, thanks for the info.
> > > > > >> >> >> > Both my instances, companyweb is fine, just monitoring that's
> > > > > >> >> >> > munged.
> > > > > >> >> >> > Anomally?
> > > > > >> >> >> >
> > > > > >> >> >> > Rob.
> > > > > >> >> >> >
> > > > > >> >> >> > "Russ (www.SBITS.Biz)" wrote:
> > > > > >> >> >> >
> > > > > >> >> >> >> This Explains it.
> > > > > >> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> > > > > >> >> >> >>
> > > > > >> >> >> >>
> > > > > >> >> >> >> Russ
> > > > > >> >> >> >>
> > > > > >> >> >> >> --
> > > > > >> >> >> >> Russell Grover - SBITS.Biz
> > > > > >> >> >> >> Microsoft Gold Certified Partner
> > > > > >> >> >> >> Microsoft Small Business Specialist
> > > > > >> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> > > > > >> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> > > > > >> >> >> >>
> > > > > >> >> >> >>
> > > > > >> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > > > >> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> > > > > >> >> >> >> >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.asp...e=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
> > > > > >> >> >> >> >
> > > > > >> >> >> >>
> > > > > >> >> >> >>
> > > > > >> >> >> >>
> > > > > >> >> >>
> > > > > >> >>
> > > > > >>
> > > > >

In article <2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com>,
Chris@discussions.microsoft.com says...
> 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.asp...e=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

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

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


"Duncan McC" wrote:

> In article <2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com>,
> Chris@discussions.microsoft.com says...
> > 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.asp...e=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
>
> 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
>

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.

"Chris" wrote:

> 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
>
>
> "Rob C" wrote:
>
> > Chris,
> >
> > Did you uninstall the kb and has it fixed the problem?
> >
> > Rob.
> >
> > "Les Connor [SBS MVP]" wrote:
> >
> > > I'm getting malfunctions without the July updates (which include the one
> > > you're referencing). A/V doesn't appear to be common ground either, but I
> > > needed to check.
> > >
> > >
> > > --
> > > Les Connor [SBS MVP]
> > > ________________________
> > > Get the SBS BPA here:
> > > http://support.microsoft.com/kb/940439/en-us
> > >
> > >
> > > "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > news:E5D6B9BA-0733-4EE1-ADD2-244B941315FE@microsoft.com...
> > > > 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.
> > > >
> > > > "Les Connor [SBS MVP]" wrote:
> > > >
> > > >> 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
> > > >>
> > > >>
> > > >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > >> news:3DA127AB-083E-486B-9D89-CBC816155164@microsoft.com...
> > > >> > 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.
> > > >> >
> > > >> > "Les Connor [SBS MVP]" wrote:
> > > >> >
> > > >> >> 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
> > > >> >>
> > > >> >>
> > > >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > >> >> news:F16F8F78-7B12-4F18-BCE5-34BAC5A408CF@microsoft.com...
> > > >> >> > 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
> > > >> >> >
> > > >> >> > "Les Connor [SBS MVP]" wrote:
> > > >> >> >
> > > >> >> >> I'm not sure the update has anything to do with the monitoring
> > > >> >> >> report
> > > >> >> >> issue.
> > > >> >> >> The monitoring report thing is happening all over the place, me
> > > >> >> >> included,
> > > >> >> >> and I don't have the updates installed at this time.
> > > >> >> >>
> > > >> >> >> There are, however, a couple of different error messages produced.
> > > >> >> >> While
> > > >> >> >> they're both WSUS related, one is a time-out and another seems to
> > > >> >> >> be
> > > >> >> >> something in the WSUS database 'not found'.
> > > >> >> >>
> > > >> >> >> The R2 monitoring report will fail entirely if there's any issue
> > > >> >> >> with
> > > >> >> >> the
> > > >> >> >> SBS Update Servcies section of the report. Shame.
> > > >> >> >>
> > > >> >> >> --
> > > >> >> >> Les Connor [SBS MVP]
> > > >> >> >> ________________________
> > > >> >> >> Get the SBS BPA here:
> > > >> >> >> http://support.microsoft.com/kb/940439/en-us
> > > >> >> >>
> > > >> >> >>
> > > >> >> >> "Rob C" <RobC@discussions.microsoft.com> wrote in message
> > > >> >> >> news:8AA87352-30CD-461C-A9C5-B5291B49C14C@microsoft.com...
> > > >> >> >> > Hi Russ, thanks for the info.
> > > >> >> >> > Both my instances, companyweb is fine, just monitoring that's
> > > >> >> >> > munged.
> > > >> >> >> > Anomally?
> > > >> >> >> >
> > > >> >> >> > Rob.
> > > >> >> >> >
> > > >> >> >> > "Russ (www.SBITS.Biz)" wrote:
> > > >> >> >> >
> > > >> >> >> >> This Explains it.
> > > >> >> >> >> http://blogs.technet.com/sbs/archive...ng-948110.aspx
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >> Russ
> > > >> >> >> >>
> > > >> >> >> >> --
> > > >> >> >> >> Russell Grover - SBITS.Biz
> > > >> >> >> >> Microsoft Gold Certified Partner
> > > >> >> >> >> Microsoft Small Business Specialist
> > > >> >> >> >> World Wide Remote SBS2003 Support - http://www.SBITS.Biz
> > > >> >> >> >> Get Help Now! http://www.crossloop.com/SBITSdotBiz
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >> "Chris" <Chris@discussions.microsoft.com> wrote in message
> > > >> >> >> >> news:2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com...
> > > >> >> >> >> >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.asp...e=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
> > > >> >> >> >> >
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >> >>
> > > >> >> >>
> > > >> >>
> > > >>
> > >

Unfortunately, this was only a temporary fix as the report is now broken
again!!!


"Duncan McC" wrote:

> In article <2FDC6BDC-065B-4F0E-9088-078F60492C27@microsoft.com>,
> Chris@discussions.microsoft.com says...
> > 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.asp...e=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
>
> 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
>

In article <1C5DBBD2-7FFA-410F-8CFE-F5BCF1833345@microsoft.com>,
Chris@discussions.microsoft.com says...
> Unfortunately, this was only a temporary fix as the report is now broken
> again!!!

Bugger! :) OK, maybe the drive has some corruption? - perhaps chkdsk /f
the drive, see if that helps.

Hopefully you saved the sql script for re-use in Management Studio,
perhaps also re-run again, then, when/if it next fails, check the Event
Logs, see what turns up there.

--
Duncan

Hi Duncan,

Thanks for your help.

From reading other posts on this problem, I think there is a problem with
the OS and Microsoft are invstigating rather than a fix on the DB.

There are too many other people saying they are having the same problem for
it to be a defrag issue I suspect.

Regards

Chris


"Duncan McC" wrote:

> In article <1C5DBBD2-7FFA-410F-8CFE-F5BCF1833345@microsoft.com>,
> Chris@discussions.microsoft.com says...
> > Unfortunately, this was only a temporary fix as the report is now broken
> > again!!!
>
> Bugger! :) OK, maybe the drive has some corruption? - perhaps chkdsk /f
> the drive, see if that helps.
>
> Hopefully you saved the sql script for re-use in Management Studio,
> perhaps also re-run again, then, when/if it next fails, check the Event
> Logs, see what turns up there.
>
> --
> Duncan
>

Bizarrely the Performance report is working again today! I haven't received
a working Server Performance Report for a week or two but today it works!!!

Chris


"Chris" wrote:

> Hi Duncan,
>
> Thanks for your help.
>
> From reading other posts on this problem, I think there is a problem with
> the OS and Microsoft are invstigating rather than a fix on the DB.
>
> There are too many other people saying they are having the same problem for
> it to be a defrag issue I suspect.
>
> Regards
>
> Chris
>
>
> "Duncan McC" wrote:
>
> > In article <1C5DBBD2-7FFA-410F-8CFE-F5BCF1833345@microsoft.com>,
> > Chris@discussions.microsoft.com says...
> > > Unfortunately, this was only a temporary fix as the report is now broken
> > > again!!!
> >
> > Bugger! :) OK, maybe the drive has some corruption? - perhaps chkdsk /f
> > the drive, see if that helps.
> >
> > Hopefully you saved the sql script for re-use in Management Studio,
> > perhaps also re-run again, then, when/if it next fails, check the Event
> > Logs, see what turns up there.
> >
> > --
> > Duncan
> >

that's sortta the nature of the problem, comes and goes.

"Chris" <Chris@discussions.microsoft.com> wrote in message
news:B240F41A-6B3A-47AD-B29E-AEB014781318@microsoft.com...
> Bizarrely the Performance report is working again today! I haven't
> received
> a working Server Performance Report for a week or two but today it
> works!!!
>
> Chris
>
>
> "Chris" wrote:
>
>> Hi Duncan,
>>
>> Thanks for your help.
>>
>> From reading other posts on this problem, I think there is a problem with
>> the OS and Microsoft are invstigating rather than a fix on the DB.
>>
>> There are too many other people saying they are having the same problem
>> for
>> it to be a defrag issue I suspect.
>>
>> Regards
>>
>> Chris
>>
>>
>> "Duncan McC" wrote:
>>
>> > In article <1C5DBBD2-7FFA-410F-8CFE-F5BCF1833345@microsoft.com>,
>> > Chris@discussions.microsoft.com says...
>> > > Unfortunately, this was only a temporary fix as the report is now
>> > > broken
>> > > again!!!
>> >
>> > Bugger! :) OK, maybe the drive has some corruption? - perhaps chkdsk /f
>> > the drive, see if that helps.
>> >
>> > Hopefully you saved the sql script for re-use in Management Studio,
>> > perhaps also re-run again, then, when/if it next fails, check the Event
>> > Logs, see what turns up there.
>> >
>> > --
>> > Duncan
>> >

Try the database cleanup wizard in the WSUS v3 console.

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


"SuperGumby [SBS MVP]" <not@your.nellie> wrote in message
news:%23m%239QWi8IHA.2332@TK2MSFTNGP03.phx.gbl...
> that's sortta the nature of the problem, comes and goes.
>
> "Chris" <Chris@discussions.microsoft.com> wrote in message
> news:B240F41A-6B3A-47AD-B29E-AEB014781318@microsoft.com...
>> Bizarrely the Performance report is working again today! I haven't
>> received
>> a working Server Performance Report for a week or two but today it
>> works!!!
>>
>> Chris
>>
>>
>> "Chris" wrote:
>>
>>> Hi Duncan,
>>>
>>> Thanks for your help.
>>>
>>> From reading other posts on this problem, I think there is a problem
>>> with
>>> the OS and Microsoft are invstigating rather than a fix on the DB.
>>>
>>> There are too many other people saying they are having the same problem
>>> for
>>> it to be a defrag issue I suspect.
>>>
>>> Regards
>>>
>>> Chris
>>>
>>>
>>> "Duncan McC" wrote:
>>>
>>> > In article <1C5DBBD2-7FFA-410F-8CFE-F5BCF1833345@microsoft.com>,
>>> > Chris@discussions.microsoft.com says...
>>> > > Unfortunately, this was only a temporary fix as the report is now
>>> > > broken
>>> > > again!!!
>>> >
>>> > Bugger! :) OK, maybe the drive has some corruption? - perhaps chkdsk
>>> > /f
>>> > the drive, see if that helps.
>>> >
>>> > Hopefully you saved the sql script for re-use in Management Studio,
>>> > perhaps also re-run again, then, when/if it next fails, check the
>>> > Event
>>> > Logs, see what turns up there.
>>> >
>>> > --
>>> > Duncan
>>> >
>