Job History size
-
We have left our job history size at the default of
Max job history log size (rows) 1000
Max job history rows per job 100
which keeps about a month in the job history. We think we may need to increase this for one server to keep a longer history. What settings is anyone else using and does increasing the size have a performance or any other overhead?
Madame Artois
-
I have mine set to 50,000 and 1,000. The default settings are too low for us. I doubt it affects performance much.
-
We have ours set to 8000 and 400. Haven't seen any performance problems.
Greg
Greg
-
I believe it will only increase the size of the sysjobhistory table in the msdb database. Rgds Derek
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply