August 26, 2009 at 1:23 am
what optimisation and integrity job will do in sql ?
August 26, 2009 at 2:54 am
Why did you post the same question 4 times.! ?
Please don't do that. Post only once and wait for the responses.
August 27, 2009 at 8:57 am
If you are referring to the maintenance jobs then start woth BOL (books on line) The help feature is very useful.
see ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/c7a3932e-e6ab-4cc2-8664-e0284490b898.htm
and
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/uirfsql9/html/ad879ed6-223a-4a06-a459-8c2ca25ce92d.htm
Personally I don't use maintenance plans at all. I prefer to create my own maintenance jobs so I know exactly what is being done and I can more closely control what is happening. For axample, why reindex all indexes if only some subset requires it. I'd rather search for indexes on large tables (where I define what is a large table) and only reindex those as opposed to reindexing everything. Or else only reindex if the some threshold is exceded. This is more important on a large database because for a very small database it may take very little time and resources to just do it all. The maintenance plans can be useful and there is a help button available. With SQL 2005 you can generate the T_SQL code that goes along with the maintenace plan so it is easier to understand what is happening
Francis
August 27, 2009 at 9:04 am
If you don't know what you're doing, the maintenance plans work great. However please read the documentation a little before posting.
If you understand them, as Francis mentioned, there are better ways to do things if you are willing to script a little. We have a number of maintenance scripts on this site that will reindex/rebuild only those indexes that need it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply