Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  SQL Server Agent Performance

Author  Topic  gyerek Starting Member 1 Post Posted - 2001-01-16 : 10:57:25 HI, I am using SQL Server 7.0. I have a SP which I need to set up to run periodically. I know I can do this by setting up a job for it. The problem is, that when I execute this SP from the Query Analyzer it takes about 1-2 hours. (It processes a lot of data.) If I set up a job for running the SP, it takes much-much longer. About 12 hours or more. I don't understand why it takes so long. Is there a way to boost the performance of the agent, or monitor it? Could there be a priority set up somehow in SQL Server? Any help would be really appreciated!!! Thanks!