When I was unable to access my account yesterday, it was disappointing, but had you not sent this email I’d have thought nothing of it. You’re a brand head-and-shoulders above the rest. MailChimp had never disappointed me before, so one day without access or autoresponders hardly bothered me. I’m devoted to MailChimp in the same way I’m devoted to Apple, Gmail, WordPress and Saddleback Leather.
Over the years, there have been many security vulnerabilities in Microsoft’s implementation of the protocol or components on which it directly relies. Real-time attack tracking shows that SMB is one of the primary attack vectors for intrusion attempts, for example the 2014 Sony Pictures attack, and the WannaCry ransomware attack of 2017.  Other vendors’ security vulnerabilities lie primarily in a lack of support for newer authentication protocols like NTLMv2 and Kerberos in favor of protocols like NTLMv1, LanMan, or plaintext passwords.
In this area I think I was getting the advantage from reindexing because when I did the indexes I would get statistics updates. So that goes to your point of something else being affected by the index updates. The Built in Auto Update was not enough. Also being on a VNX I think I upset my Fast Cache when I re-index. I have had a good deal of time now to work with this and I would say overall you are right but there are some other things I find that are factors. Disk speed is a factor on this from what I see and in particular when the more SSD i get the less I need to re-index. It seemed to even out. So I started updating stats based on number of rows changed and stopped rebuilding indexes as much. Very soon we are moving to Pure Storage all SSD storage.
During this time, [network_name] will be unavailable. Formal: We will be performing maintenance on [network_name] on Wednesday, February 20 between 10pm and 2am Pacific Time. We hope this won’t be too much of an inconvenience as we work to perform some necessary upgrades.
Google’s Adsense page offers a simple maintenance message in a huge number of languages. Creating a Down for Maintenance Page From the Pylons Cookbook.
It’s going to take some careful analysis and work to figure out how to do less and get your maintenance done faster, and possibly some custom coding on your part. There’s no magic answer I can give to fix that. This is a common mistake people make: they reindex out of fear.
With all types of replication products I’ve worked with and heard of (database mirroring, availability groups, transactional replication, SAN replication, filter driver replication technologies), there’s always a way that you can push so much data churn into the system that your secondary gets so far behind that you have to reset everything and start over.
I suspect it doesn’t handle partitioned tables but that’s only a guess and I haven’t dug into his code. BtwOla’s script is leaving giant indexes severely fragmented – I’m talking 10s of thousands of pages with like 97% fragmentation. It picks up the index has an issue but then does reorganize on just one partition leaving the rest fragmented. We are contacting him to see if he knows there appears to be significant bug in the code.
0 (previously named SMB 2. 2) was introduced with Windows 8 and Windows Server 2012.  It brought several significant changes that are intended to add functionality and improve SMB2 performance, notably in virtualized data centers:.
So there are problems on top of problems it gets somewhat complicated. So I end up with really too many indexes. I can point at so many issues. There is some OLTP but much what goes on is reporting. 5TB it processes around 500,000 claims a day which come in in the form of files (X12). However the picture is so much more complicated. Regarding the indexes, if they get too fragmented on some of these large table the performance gets very bad. Even if I do not create a covering index and a look-up is required it can have a severe impact on some of these. I many times suggested we hire you guys to tell Management these issues because it would have more impact coming from an outsider. For what I would call our primary database which is currently about 6.
Down, if possible redirect users to a server that is. What are the best practices for site-wide maintenance. Down, you can use a similar message in place.
Server Maintenance Notification – This Saturday (November 24th 2007). The maintenance is required in order to keep our servers secure and up-to-date.