Post reply

Macromedia breeze

  • November 28, 2004 at 6:46 pm

    #163252

    i cant start that program.guess something wrong with MS SQL server.

    2004-11-26 09:40:15 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID

    2004-11-26 09:40:15 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2780

    2004-11-26 09:40:15 - ? [101] SQL Server HERNGYIH version 8.00.760 (0 connection limit)

    2004-11-26 09:40:15 - ? [102] SQL Server ODBC driver version 3.85.1117

    2004-11-26 09:40:15 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is

    2004-11-26 09:40:15 - ? [310] 1 processor(s) and 256 MB RAM detected

    2004-11-26 09:40:15 - ? [339] Local computer is HERNGYIH running Windows NT 5.1 (2600) Service Pack 2

    2004-11-26 09:40:15 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent

    2004-11-26 09:40:15 - ? [129] SQLSERVERAGENT starting under Windows NT service control

    2004-11-26 09:40:15 - + [260] Unable to start mail session (reason: No mail profile defined)

    2004-11-26 09:40:15 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

    2004-11-26 09:59:35 - ? [131] SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS...

    2004-11-26 09:59:38 - ? [098] SQLServerAgent terminated (normally)

    Please help me.Wat does it mean an idle CPU?

  • November 30, 2004 at 3:32 pm

    #531978

    If you open Enterprise manager then open your sql server, then go to management, then right click on SQL Server Agent and select properties. On the properties page, click on the advanced tab. Toward the bottom is an idle CPU condition.

    It sounds like there are some jobs set to execute when the CPU is idle, but there have not been any parameters setup in the above to define idle.

    According to Books on Line

    How to set CPU idle time and duration (Enterprise Manager)

    To set CPU idle time and duration

    1. Expand a server group, and then expand a server.
    2. Expand Management, right-click SQL Server Agent, and then click Properties.
    3. Click the Advanced tab, and then select the The computer is idle when check box.
    4. Under Idle CPU condition, do the following:

      • Specify the percentage that the average CPU usage must remain below (across all CPUs).
      • Specify the duration in seconds before the computer is considered idle.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply