SQL Server Agent Issues

Hot Topic

Connections to SQL Server Files (*.mdf) require SQL Server Express 2005
how do I determine how many columns there are in a file?
Report Manager error
SQL Locking up
writing planned values back to the cube
DTC - Transaction context in use by another session
SQL Express user permissions?
Call a storedproc in select from block
Selecting ProfileName to use by the SQLMERGXLib.SQLMerge
Transforming Published Data

SQL Server

Moving or rolling average, how to?
SSIS Task
MDX - how to descend to dimension key level elements in a hierarchy which has not the key level in it
Installing the SQL server 2005 beta tools problem
Sql server synchronization
Some users cannot view report in IE 6.0
Installing feature Pack components with an Application
CANT CONNECT TO SQL SERVER
Different kind of connection issue
Get latest purchase of each vender

SQL Server Agent Issues

Hey everyone,

I don't know if I am posting to the correct forum so please move this if there is a better forum for this.

I am having issues through SQL Server that I believe may be related to the SQL Server 2000 User Mode Scheduler.

First of all, I am running a single instance of SQL Server 2000 on a Quad Processor system. I was not around when the system was installed so I do not know how it was originally configured.

I am getting a reoccurring error whenever I try to do anything with replication or scheduled jobs.

Error 14258: cannot perform this operation while SQL server agent is starting. Try again later.

I found the following article regarding the above error:

http://support.microsoft.com/default.aspx scid=kb;en-us;303287

My question is, how to I determine if SQL is running in Fiber Mode or Thread Mode And if it is running in Fiber Mode, would I see any major performance issues by switching it back to Thread Mode And is any of this an issue in SQL 2005

Any suggestions or comments are welcome. Please keep in mind that I have absolutely no clue about this these user modes or threads/fibers or any of the SQL architecture stuff so please keep in simple.

Thanks,

Lee.




Answer this question

SQL Server Agent Issues

  • MaggieChan

    Thanks Chad.

  • RBJ1128

    It would be a rare case that you would require fiber mode processing on a server, and it should only be done if you are certain via testing that it improves performance and/or are recommended to do so by an MS employee.

    To check if you are running in fiber mode, run the following in query analyzer:

    exec sp_configure 'show advanced options',1
    go
    reconfigure
    go
    exec sp_configure 'lightweight pooling'
    go

    If the value for the 'run_value' column is 1, then you are running in fiber mode and you should change it ASAP...to do so you'll have to run the following and then restart your SQL Service:

    exec sp_configure 'show advanced options',1
    go
    reconfigure
    go
    exec sp_configure 'lightweight pooling',1
    go
    reconfigure
    go

    See this KB article for more discussion on SQL Server configuration settings:

    http://support.microsoft.com/kb/319942/en-us




  • PTCruisin

    I have similar problem, since OS update my SQL Server Agent can't be run anymore, I get the error Agent XPs diabled. I tried enabling them but it still doesn't work. Can I somehow repair this problem or do i have to reinstall everything...

  • mysticmart

    Hi Chad

    My SQL Agent is not starting up sinve upgrading to SQL 2005. When I prompt it to start, it takes about 2 minutes and just bombs out. What can I do to get this to work

    Hannes
  • SQL Server Agent Issues
Answer this question