Maintainance Plan for my DB

• selvakumar.sms

  SSC Eights!

  Points: 895

  More actions

  July 10, 2013 at 1:50 am

  #275071

  hi all

  please help me to create good performance plan for my database.In SQL default maintenance plan are there but my former DBA deployed one small script from the following link

  http://www.mssqltips.com/sqlservertip/1165/managing-sql-server-database-fragmentation/

  same query in the above link

  i am running this query monthly once, but after run the query next 3 to 4 days mt database is very slow and some scheduler are taking more than 5 hours to complete,its normal running time is 30 mins only.

  can anybody help me to create good maintainance plan.

  thanks

  --------------------------------------------------------

  I am Learner -- SQL

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  July 11, 2013 at 12:23 am

  #1631469

  Hi,

  Take a look at http://ola.hallengren.com/. He has created a custom maintenance solution. These are highly recommended by many DBA's in the field.

  Edit: corrected the URL

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **