Database Maintenance

Comments: No Comments
Published on: March 9, 2011

I often see a request for some scripts to help with database maintenance.  Sometimes those questions come in the form of recommendation requests for maintenance plans.  As many already know, there are some really good recommended scripts by Ola Hallengren.  There is also the fantastic index defrag script by Michelle Ufford.

Under normal circumstances, my recommendation would be that the maintenance of your database depends on your environment.  However, that doesn’t always work well.  Sometimes, something is needed quick to get up and in place while you figure things out in your environment and for your database (let’s say you just started a new job or you just inherited the database duties).

Under such circumstances, it would be good to have something ready to go already.  Thus, I recommend using these resources and learn from them.

Index Defrag Script by Michelle

Maintenance Scripts by Ola

No Comments - Leave a comment

Leave a comment

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








Calendar
March 2011
M T W T F S S
« Feb   Apr »
 123456
78910111213
14151617181920
21222324252627
28293031  
Content
SQLHelp

SQLHelp

  • @SQLHA: @e90fleet And you should test your workload to see if using a secondary replica as a readable works for you. #sqlhelp
  • @SQLHA: @e90fleet Do not use preferred nodes. It is a WSFC concept. And what you want to be the primary for readable is up to you. #sqlhelp
  • @SQLHA: @e90fleet And what do you mean by 'preferred nodes' in this context? #sqlhelp
  • @SQLHA: @e90fleet Do not use just cluster. Too generic. FCI + AG? AG only w/ standalone instances? What is your config? #sqlhelp
  • @e90fleet: #sqlhelp What should be the preferred nodes in setup? should i also configure asynch nodes for read only? 2/2
  • @e90fleet: #sqlhelp i have 4 node multisubnet clust., 2 nodes in primary (synch) and 2 nodes (asynch) in dr DC's. I need to conf read only routing. 1/2
  • @mike_walsh: That's how full of awesome sauce your script is Robert! That I want to cry when it isn't available last minute :) @SQLSoldier #sqlhelp :)
  • @mike_walsh: But it seems like @SQLSoldier has changed his site around lately. It's not downloadable and I don't seem to have a copy :-) #sqlhelp 2/2
  • @mike_walsh: Noooo!! (in the Darth Vader voice) I normally suggest clients use the @SQLSoldier DBA_CopyLogins.sql script for AG login sync #sqlhelp 1/2
  • @arvisam: @gordoncoulter with transactions and tablockx concurrency can be addressed. Worth testing at least. #sqlhelp

Welcome , today is Tuesday, June 28, 2016