DB Maintenance

Comments: No Comments
Published on: November 2, 2010

About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server.  It seems to be a rather comprehensive list.  If you don’t have some sort of maintenance checklist yet, I would recommend that you shoot on over and check out his list.  In addition to checking it out, I recommend that you make suggestions of other items to check when doing maintenance.  In addition to getting a maintenance routine setup, I would also suggest that a way to automate as much as possible be explored.

You can find the list here.

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

November 2010
« Oct   Dec »


  • @SQLSoldier: @sdwade4 Where are you seeing this? What version and what is the db compatibility level? What are you changing recovery model to? #sqlhelp
  • @sdwade4: seeing setting database option recovery to RECMODEL_70BACKCOMP. What does this mean and why am I receiving it? #sqlhelp
  • @SQLTrooper: @Mushtaq_M I just tested and it does not prompt me to reinit subs, so it would appear no. I will further test though. #sqlhelp
  • @Mushtaq_M: Can we stop replicating deletes on article in transactional Repl w/o generating snapshot for the publicaton #sqlhelp
  • @SQLBek: @cfgears Your current workload actually need more than that? Try a buffer pool diag query? #sqlhelp
  • @NedOtter: @cfgears Exactly what have you done to increase SQL memory? #sqlhelp
  • @cfgears: #sqlhelp I have SQL 2014 Dev Edition on Win 10 with 10GB RAM allocated to SQL. No matter what, SQL caps at 1.6GB RAM. Suggestions?
  • @nitin_alwar: How to fetch bigint datatype from table to variable in ssis. Need to use the variable later in the package as input parameter #sqlhelp
  • @SQLSoldier: @MartynJones76 @YetAnotherSQL @SQLGlenn In SQL 2014+, you can see CU level with ServerProperty('ProductUpdateLevel') #sqlhelp
  • @MrACutler: Anyone using Azure Data Catalog? I don't seem to be able to sort the "Name" column alphabetically, objects randomly ordered #sqlhelp

Welcome , today is Wednesday, May 4, 2016