Announcement

Collapse
No announcement yet.

Monitoring configuration wizard error.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Monitoring configuration wizard error.

    I receive an error when trying to run the monitoring wizard from the check list in SBS. Iíve included a short version of the error log from the SQL monitoring directory

    2007-01-11 09:45:34.48 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
    May 3 2005 23:18:38
    Copyright (c) 1988-2003 Microsoft Corporation
    Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)

    2007-01-11 09:45:34.48 server Copyright (C) 1988-2002 Microsoft Corporation.
    2007-01-11 09:45:34.48 server All rights reserved.
    2007-01-11 09:45:34.48 server Server Process ID is 1744.
    2007-01-11 09:45:34.48 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$SBSMONITORING\LOG\ERRORLOG'.
    2007-01-11 09:45:34.64 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
    2007-01-11 09:45:35.21 server SQL Server configured for thread mode processing.
    2007-01-11 09:45:35.21 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
    2007-01-11 09:45:35.42 spid4 Starting up database 'master'.
    2007-01-11 09:45:36.26 server Using 'SSNETLIB.DLL' version '8.0.2039'.
    2007-01-11 09:45:36.26 spid5 Starting up database 'model'.
    2007-01-11 09:45:36.39 spid4 Server name is 'OWB\SBSMONITORING'.
    2007-01-11 09:45:36.39 spid4 Skipping startup of clean database id 4
    2007-01-11 09:45:36.39 spid4 Skipping startup of clean database id 5
    2007-01-11 09:45:37.42 spid5 Clearing tempdb database.
    2007-01-11 09:45:40.04 server SQL server listening on Shared Memory.
    2007-01-11 09:45:40.04 server SQL Server is ready for client connections
    2007-01-11 09:45:41.40 spid5 Starting up database 'tempdb'.
    2007-01-11 09:45:41.96 spid4 Recovery complete.
    2007-01-11 09:45:41.98 spid4 SQL global counter collection task is created.
    2007-01-11 09:45:44.37 spid51 Starting up database 'msdb'.
    2007-01-11 09:45:50.17 spid51 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.
    2007-01-11 22:30:28.80 spid9 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
    2007-01-11 22:30:32.68 spid54 Database model: IO is frozen for snapshot
    2007-01-11 22:30:32.68 spid55 Database msdb: IO is frozen for snapshot
    2007-01-11 22:30:32.68 spid53 Database master: IO is frozen for snapshot
    2007-01-11 22:30:33.29 spid53 Database master: IO is thawed
    2007-01-11 22:30:33.29 spid54 Database model: IO is thawed
    2007-01-11 22:30:33.33 spid55 Database msdb: IO is thawed
    2007-01-11 22:30:33.52 backup Database backed up: Database: master, creation date(time): 2007/01/11(09:45:35), pages dumped: 1, first LSN: 170:378:1, last LSN: 170:380:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1EC5ABCC-D038-4DCC-B982-FE5E0385C553}1'}).
    2007-01-11 22:30:33.52 backup Database backed up: Database: model, creation date(time): 2002/12/17(14:36:05), pages dumped: 1, first LSN: 4:469:1, last LSN: 4:471:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1EC5ABCC-D038-4DCC-B982-FE5E0385C553}2'}).
    2007-01-11 22:30:33.52 backup Database backed up: Database: msdb, creation date(time): 2002/12/17(14:41:12), pages dumped: 1, first LSN: 28:451:1, last LSN: 28:453:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{1EC5ABCC-D038-4DCC-B982-FE5E0385C553}3'}).
    2007-01-12 03:00:02.22 spid53 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'xp_instance_regread'.
    2007-01-12 22:30:17.28 spid54 Database model: IO is frozen for snapshot
    2007-01-12 22:30:17.28 spid55 Database msdb: IO is frozen for snapshot
    2007-01-12 22:30:17.28 spid53 Database master: IO is frozen for snapshot
    2007-01-12 22:30:17.76 spid54 Database model: IO is thawed
    2007-01-12 22:30:17.76 spid55 Database msdb: IO is thawed
    2007-01-12 22:30:17.76 spid53 Database master: IO is thawed
    2007-01-12 22:30:18.03 backup Database backed up: Database: model, creation date(time): 2002/12/17(14:36:05), pages dumped: 1, first LSN: 4:474:1, last LSN: 4:476:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{17328A77-E7EE-439A-A53F-8D38C55F0012}2'}).
    2007-01-12 22:30:18.03 backup Database backed up: Database: master, creation date(time): 2007/01/11(09:45:35), pages dumped: 1, first LSN: 171:192:1, last LSN: 171:194:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{17328A77-E7EE-439A-A53F-8D38C55F0012}1'}).
    2007-01-12 22:30:18.03 backup Database backed up: Database: msdb, creation date(time): 2002/12/17(14:41:12), pages dumped: 1, first LSN: 29:68:1, last LSN: 29:71:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{17328A77-E7EE-439A-A53F-8D38C55F0012}3'}).
    2007-01-12 22:30:19.42 spid12 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
    2007-01-15 21:45:33.98 spid7 Starting up database 'SBSMonitoring'.
    2007-01-15 22:30:13.84 spid11 This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected.
    2007-01-15 22:30:25.57 spid53 Database model: IO is frozen for snapshot
    2007-01-15 22:30:25.57 spid55 Database msdb: IO is frozen for snapshot
    2007-01-15 22:30:25.57 spid54 Database master: IO is frozen for snapshot
    2007-01-15 22:30:26.60 spid55 Database msdb: IO is thawed
    2007-01-15 22:30:26.60 spid53 Database model: IO is thawed
    2007-01-15 22:30:26.62 spid54 Database master: IO is thawed
    2007-01-15 22:30:26.74 backup Database backed up: Database: master, creation date(time): 2007/01/11(09:45:35), pages dumped: 1, first LSN: 173:167:1, last LSN: 173:169:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{A3805803-D980-4E84-B46C-85395993E29A}1'}).
    2007-01-15 22:30:26.74 backup Database backed up: Database: model, creation date(time): 2002/12/17(14:36:05), pages dumped: 1, first LSN: 4:479:1, last LSN: 4:481:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{A3805803-D980-4E84-B46C-85395993E29A}2'}).
    2007-01-15 22:30:26.76 backup Database backed up: Database: msdb, creation date(time): 2002/12/17(14:41:12), pages dumped: 1, first LSN: 29:383:1, last LSN: 29:386:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{A3805803-D980-4E84-B46C-85395993E29A}3'}).

  • #2
    Re: Monitoring configuration wizard error.

    Which version plain 2003, 2003 SP1 or 2003 R2, Standard or premium?

    Have you installed SP4?

    Go to server Management/Monitoring and Reporting/Set up etc and Reinstall Monitoring.
    See if that helps.
    TIA

    Steven Teiger [SBS-MVP(2003-2009)]
    http://www.wintra.co.il/
    sigpic
    Iím honoured to have been selected for the SMB 150 list for 2013. This is the third time in succession (no logo available for 2011) that I have been honoured with this award.

    We donít stop playing because we grow old, we grow old because we stop playing.

    Comment

    Working...
    X