Steve expends on that post from Santos: http://stevethompsonmvp.wordpress.com/2014/05/27/configmgr-2012-index-optimization/ and here:
http://stevethompsonmvp.wordpress.com/2013/05/07/optimizing-configmgr-databases/ I've followed Steve's directions for using Ola's script and have had no issues. _________________ Brian Mason MCTS, MS MVP ECM http://www.mnscug.org/ [MMSREGISTERED]<http://mms.mnscug.org/> From: [email protected] [mailto:[email protected]] On Behalf Of Denzik, Josh Sent: Tuesday, August 19, 2014 7:46 AM To: [email protected] Subject: [mssms] Database Defragmentation All, I am looking to defrag the database using Santos Martinez's blog located at this URL http://blogs.technet.com/b/smartinez/archive/2014/03/28/talking-database-in-configmgr.aspx Are there any gotchas that I should know about, my database is located on a sql cluster as well. Shutting down the ccmexec service? Thanks in advance, Josh
