There is no official recommendation; however, using a SQL re-indexing and statistics rebuild script/task is standard operating procedure for any SQL Server database and the method that Steve describes (or one very similar) is used by Microsoft IT on their internal ConfigMgr hierarchy. They actually detailed this in a session at last year's (last ever) MMS.
J From: [email protected] [mailto:[email protected]] On Behalf Of Anoop C Nair Sent: Thursday, February 20, 2014 9:20 PM To: [email protected] Subject: RE: [mssms] Re-index database solution Yes. Good stuff. Do we have any Microsoft's official recommendations on this! If we implement this then i hope, we won't fall under unsupported scenario ;) Regards Anoop On 21 Feb 2014 08:22, "Jason Sandys" <[email protected]<mailto:[email protected]>> wrote: Yes. Side note though is that I would follow the directions from Steve Thomspon: http://stevethompsonmvp.wordpress.com/2013/05/07/optimizing-configmgr-databases/ J From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Magnus Tveten Sent: Thursday, February 20, 2014 8:40 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] Re-index database solution Hmmm could I do it for SCCM2007 too ? ________________________________ MAGNUS TVETEN SERVER SUPPORT ENGINEER CO CITRIX/SERVER Insurance Australia Group Limited Lvl 1, 23 Lakeside Drive, Burwood Burwood East VIC 3151 Australia T +61 3 8804 3226 F +61 X XXX XXXX M +61 411 010 460 E [email protected]<mailto:[email protected]> www.iag.com.au<http://www.iag.com.au> PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL. ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Sherry Kissinger Sent: Friday, 21 February 2014 10:39 AM To: [email protected]<mailto:[email protected]> Subject: Re: [mssms] Re-index database solution Yes, you want it, yes, it'll make a world of difference. We have it on cas and primaries. Sherry Kissinger Microsoft MVP - ConfigMgr [email protected]<mailto:[email protected]> ________________________________ From: "Beardsley, James" <[email protected]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> Sent: Thursday, February 20, 2014 5:27 PM Subject: [mssms] Re-index database solution Anyone ever set this up and run it on a weekly basis? I was looking at ways to try and speed up the console a bit and came across this. Our SQL guy said he's familiar with it and he's used Ola's solution on other databases with success. Figured I'd check with the community to get opinions before I implemented anything. http://www.arunknows.com/2013/07/12/optimizing-performance-in-configmgr-2012/ Thanks, James ________________________________ IRS Compliance: Any tax advice contained in this communication (including any attachments) is not intended or written to be used, and cannot be used, for the purpose of (i) avoiding penalties imposed under the Internal Revenue Code or applicable state or local tax law or (ii) promoting, marketing, or recommending to another party any transaction or matter addressed herein. ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation. ________________________________ The information transmitted in this message and its attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential material and /or personal information. If you have received this in error, please contact the sender and delete this e-mail and associated material from any computer. ________________________________
