Very slow SQL Server Agent history

I have a big problem with the SQL Server Agent hostory. it has become VERY VERY slow when i try to view it. If I try through Management Studio I often get a timeout and if I try viewing it with sp_help_jobhistory it is just running for a long time.

I tried reducing the hostory size and the sysjobhistory table has only 8000 rows….

Is there any way to optimize this somehow?

Thx a lot
Nicolaj

Ensure that the sysjobhistiory table is not fragmented. The easiest thing to do is reindex it. Since the table is so small, the reindex should happen quickly.

Check more discussion of this question.

Related posts:

1. SQL Agent History settings not being saved
2. Configuring SQL Server Agent with domain account still fails to start Agent
3. Slow Inserts SQL Server 2005
4. SQL Server Agent 2005 job runs but provides no output
5. SQL Server 2005 Agent running SSIS job can’t find file path