Performance Reports and Usage reports - MAJOR PROBLEMS

Discussion in 'Windows Small Business Server' started by James, May 31, 2005.

  1. James

    James Guest

    This is a bit of a long post - however please bear with me, especially if you
    like solving sticky problems. So far the solution to this one has escaped one
    MVP - and they suggested I post here to see if anyone else has any other
    suggestions.

    The following is an outline of the problem and what has occurred so far to
    try and fix it:

    1/ My 'extended server usage reports' are being returned like the following:

    \#L_USAGE_WEB_ACTIVITY_TEXT\#Web Activity by Computer
    \#L_USAGE_WEB_TRAFFIC_TEXT\#Daily Web Traffic
    \#L_USAGE_SECTION_EMAIL_SENT_TEXT\#E-mail Sent
    etc ...

    Usage eports are also being emailed like this

    Also 'server performance reports' are blank - with no information in them.

    2/ When I do to http://agcorpserver/Monitoring an error page is returned at:
    http://agcorpserver/Monitoring/error.aspx?aspxerrorpath=/monitoring/query.aspx

    The error message is the same as appears below in point #3.

    3/ When I click Create New Report button in the Usage report page, I get an
    error page

    The page cannot be displayed
    An error occurred on the page you are trying to view.

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

    To work around this problem, perform the following steps. After each step,
    try again to access the page.
    Ensure that the MSSQL$SBSMONITORING service is started.
    Ensure that the server is not low on memory or disk space.
    Restart the server.
    Verify that the server is functional and that there are no system-wide
    problems.
    Run the Set Up Monitoring Reports and Alerts task in the Server Management
    Monitoring and Reporting taskpad.
    __________________

    I have checked the following: MSSQL is running - fixed that problem.
    No probs with memory or disk space
    have restarted the server
    no system wide problems as far as I am aware.
    Have run - and re-run the Set up monitorin Reports and Alerts task

    4/ MSSQL$MONITORING and the SQLAgent$Monitoring services are running and set
    to automatic.

    5/ I have Uninstalled the SBS Monitoring component - Add/Remove, Small
    Business Server, maintenance, moitoring component ... and reinstall it again.

    I have Uninstalled Microsoft SQL Server Desktop Engine (SBSMONITORING)

    I have deleted the following Registry Keys
    1. Delete
    HKEY_LOCAL_MACHINE\SOFTWARE\Mi­crosoft\SmallBusinessServer\Mo­nitoring
    2. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Mi­crosoft\Microsoft SQL
    Server\SBSMONITORING

    I have Deleted IIS Virtual Directory

    I have Rename the following Folders:
    1. Rename C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING to
    MSSQL$SBSMONITORING.OLD
    2. Rename c:\inetpub\monitoring to monitoring.old

    I have re-Installed the Monitoring component, and run the Set-up Monitoring
    wizard in To-Do list.

    BUT ... THE PROBLEM STILL EXISTS <groans>.

    I would be most greatfully appreciative if someone could please suggest any
    other cause for this problem. I have no way of monitoring internet usage by
    clients on our network, and need to receive performance reports so I can
    monitor what is happening with our server. Currently I can do neither.

    Sincerely,

    James
     
    James, May 31, 2005
    #1
    1. Advertisements

  2. Hello James,

    Thank you for posting to the SBS Newsgroup.

    I notice that you have posted the same issue on March 22nd 2005. I would
    like to know whether the information Bill posted helped or not.

    At this stage, I would like to attach Bill's reply to you again for your
    reference. Please see below:

    If ISA has been installed, you can add the ISA logs (C:\Program
    Files\Microsoft ISA Server\ISALogs) in the Server Usage Report. The steps
    below can be performed:

    I. Create a scheduled task to copy the report file

    Since the log file name is SVC<yyyymmdd>.log based on the date and SBS 2003
    Server Status Report can only select the file with a static name, we must
    create a schedule task to compress the report files into a .zip file. To
    do that, you can use some 3rd party compress tool, such as PKZIP for DOS,
    and then compress all files in the folder C:\Program Files\Microsoft ISA
    Server\ISALogs into a .zip file

    II. Modify Server Status Report Settings

    1. Open SBS Server Management.
    2. Click Monitoring and Reporting, and then click Changing Server Status
    Report Settings.
    3. Click to selectServer Usage Report, and then click Edit button.
    4. Click Content tab, click Add button, add the .zip file that we created
    in Step 1, click OK, select the this new item, click OK, and then click
    Close.

    If ISA has not been installed, I recommend you to try reinstalling the
    monitoring component.

    To do so:

    - Uninstall the SBS Monitoring component

    1. Click Start, click Control Panel, and then click Add or Remove Programs.
    2. Select Windows Small Business Server 2003 and then click Change/Remove.
    The Setup Wizard appears.
    3. Click Next to start the wizard.
    4. On the Windows Configuration page, click Next.
    5. On the Component Selection page, in the Action column, change Server
    Tools to Maintenance, change Monitoring component to Remove, and then click
    Next.
    6. On the Component Summary page, click Next.
    7. Click Finish.

    - Uninstall Microsoft SQL Server Desktop Engine (SBSMONITORING)

    In Add or Remove Programs, select Microsoft SQL Server Desktop Engine
    (SBSMONITORING) and then click Remove. A dialog box appears. To confirm
    that you want to remove, click Yes.

    - Delete Registry Keys

    1. Delete
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SmallBusinessServer\Monitoring
    2. Delete HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
    Server\SBSMONITORING

    - Delete IIS Virtual Directory

    1. Open IIS, expand servername, Web Sites, Default Web Site
    2. Delete Monitoring

    - Rename Folders

    1. Rename C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING to
    MSSQL$SBSMONITORING.OLD
    2. Rename c:\inetpub\monitoring to monitoring.old

    - Install the Monitoring component

    1. In Add or Remove Programs, select Windows Small Business Server 2003 and
    then click Change/Remove. The Setup Wizard appears.
    2. Click Next.
    3. On the Windows Configuration page, click Next.
    4. On the Component Selection page, in the Action column, change Server
    Tools to Maintenance, change Monitoring component to Install, and then
    click Next.
    5. On the Logon Information page, click Next.
    6. On the Component Summary page, click Next.
    7. Click Finish.

    [Note] You may also encounter a "Server Error '/' Application" issue which
    has been described in KB 823379 "You receive a "Server Error in '/'
    Application. Access to the path <path> is denied" error message when you
    log on to Windows SharePoint Services". Please refer to the following link:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;823379

    If the problem persists, please make a screen shot of the error info and
    attach it to your reply.

    I hope the above info helps and I look forward to your update.

    Best regards,

    Brandy Nee

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Brandy Nee [MSFT], Jun 1, 2005
    #2
    1. Advertisements

  3. James

    James Guest

    Hi Brandy,

    I did attempt to follow these instructions - I think from memory that the
    result was that a zip file of raw log data got emailed to me - which was very
    hard to read anything from.

    James

     
    James, Jun 2, 2005
    #3
  4. Hello James,

    Yes, this is the expacted behavior.

    However, you should configure a scheduled task to ask the system to
    automatically zip the files. You may have to contact the software (such as
    winzip) provider to properly configure the scheduled tasks.

    If anything unclear or you need any assistance, please feel free to post
    back. I am glad to be of assistance.

    Best regards,

    Brandy Nee

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Brandy Nee [MSFT], Jun 3, 2005
    #4
  5. James

    James Guest

    Given that this will happen, and I am receiving the zip file via email ...
    how do I access the information?

    James
     
    James, Jun 5, 2005
    #5
  6. Hello James,

    Thank you for posting back.

    If you receive the ISA logs file as an attachment in the performance report
    email, you can save it in your local drive, open it and then read the ISA
    log files. If you have difficulty reading the ISA log files, you can use
    certain third party tool to analyze the log files:

    http://www.google.co.uk/search?hl=en&q=isa+log+analyzer&btnG=Google+Search&m
    eta=

    Important NOTE: This response contains several references to third party
    World Wide Web sites. Microsoft is providing this information as a
    convenience to you. Microsoft does not control these sites and has not
    tested any software or information found on these sites; therefore,
    Microsoft cannot make any representations regarding the quality, safety, or
    suitability of any software or information found there. There are inherent
    dangers in the use of any software found on the Internet, and Microsoft
    cautions you to make sure that you completely understand the risk before
    retrieving any software from the Internet.

    Hope this information helps. If you have any further concerns or questions,
    please let me know. I am glad to be of assistance.

    Best regards,

    Brandy Nee

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Brandy Nee [MSFT], Jun 6, 2005
    #6
  7. James

    James Guest

    Thanks for your response Brandy ... but .... Is there not an easier way? Is
    SBS2003 not set up tojust give me these usage and performance stats in a
    really simple to read (meaning "beginners guide to SBS") format?

    I'm not much enjoying the thought of having to convert ZIP files every time
    I want to see what is going on with the network.

    James
     
    James, Jun 6, 2005
    #7
  8. Hello James,

    Thank you for posting back.

    Actually, this behavior is by design. In SBS 2K3 Standard Edition, the web
    usage data is included in the Server Usage or Performance report. However
    in SBS 2003 Premium Edition with ISA installed such data is included in the
    ISA Web Proxy and Firewall Service logs. Therefore we have to check ISA
    logs and there are no other methods.

    Thanks for your understanding and time. If anything unclear, please let me
    know. I am looking forward to hearing from you.

    Best regards,

    Brandy Nee

    Microsoft CSS Online Newsgroup Support

    Get Secure! - www.microsoft.com/security

    =====================================================
    When responding to posts, please "Reply to Group" via your newsreader so
    that others may learn and benefit from your issue.
    =====================================================

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Brandy Nee [MSFT], Jun 7, 2005
    #8
    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.