September 12, 2016 at 3:33 am
Hi
re: Maintenance Plans
Do MS recommend doing maintenance plans on a DB ? Just wondered whether they recommend a some kind of minimum etc.
We have several DB's where we don't have any maintenance plans. How easy it to check whether a table is above the 30% threshold(I think that is the threshold - correct me if I'm wrong) for a re-org ?
Thanks for your help in advance.
September 12, 2016 at 3:37 am
Maintenance, yes. Maintenance plans, not so much. Don't use them for index maintenance (they're stupid)
Look up Ola Hallengren's maintenance scripts: http://ola.hallengren.com/
You should have backups (don't forget to clean up old backup files), index maintenance and consistency checks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 12, 2016 at 3:47 am
Hi thanks
Is there something I can use quickly that will give me info on what state the tables/indexes are in ?
I'm coming from a DB2 background so don't know SS that well.
September 12, 2016 at 3:56 am
Sure. Google "Sys.dm_db_index_physical_stats", the MSDN documentation page will give you full details of what it returns and what parameters it takes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 15, 2016 at 4:24 am
Hi - thanks
where do I run Sys.dm_db_index_physical_stats from the sys DB or any DB ?
Re: MS recommendations for DB maintenance - can anyone point me to any ?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply