Online Surveys = Ongoing Insights

…And We’re Back!

 → 
 → 
…And We’re Back!
SM_Logo

For those of you folks surveying away last night between the hours of 7 p.m. and 2 a.m. PST, you would’ve noticed that you weren’t able to access our site. The technical explanation is that due to a minor bug in the way we insert records, we hit an obscure limit in SQL Server for very large tables–row sizes in the billions.

For the Database Administrator (DBA) crowd, search “SQL server error 666” and “index uniquifier”. Dropping and rebuilding the index solved the issue. The rebuilding process doesn’t lose any data, but it does take a lot of time when you have the huge amount of data we store.

So what does this mean? Simply put, the site was unavailable for survey creators and takers for several hours. Our team diagnosed the problem quickly and worked through the night to find the quickest resolution possible.

We’re happy to report that all SurveyMonkey services are now up and running, with all the surveys and data in your account fully intact. Survey respondents should now be able to access any live survey URLs.

Normally, when we need to perform any kind of site maintenance that’ll prevent you from being able to access any of your accounts, we alert you well in advance. This was anything but normal however!

We sincerely apologize for any inconvenience this may have caused you. A big thanks to everyone for your patience as we worked to resolve the situation. Again, we’re so sorry about this.

Don’t hesitate to reach out with any questions or concerns, we’re here to help!

Tags: ,

  • Junktoothlover3000

    This is so cool. How much can anybody improve everyday to remember to use less plastic bottles, and more re-usable bottles? I would love to help win money for a charity! But me and my family might have a serious talk! :D

  • Good that you found the cause. However, you did not mention if it’s possible this could happen again some day.

    • Kayte K

      Hi Arnie, we don’t expect it to! Thank you for your support, appreciate your feedback. :)

Inspired? Create your own survey.

Inspired? Create your own survey.

PRO Sign Up Sign Up FREE or Sign in
Write Surveys Like a Pro

Ever wonder what SurveyMonkey’s really made of?

Ever wonder what SurveyMonkey's really made of?

Read our engineering blog »