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