Verint | Telligent Community
Verint | Telligent Community
  • Site
  • User
  • Site
  • Search
  • User
Telligent Community 10.x
  • Verint Community
  • More
Telligent Community 10.x
Legacy User Documentation SQL times out when accessing the site
  • Ask the Community
  • User Documentation
  • API Documentation
  • Manager Training
  • Developer Training
  • Tags
  • More
  • Cancel
  • New
  • Telligent Community 10.0
  • -All platform topics
    • +Achievements
    • +Activity Story Stream
    • +Authentication
    • +Blogs
    • +Business Rules
    • Calendar
    • +Chat
    • +Content tools
    • Document Preview
    • +Email
    • Featured content
    • +Forums
    • +Friends
    • Gamification
    • +Groups
    • Hashtags
    • Ideas
    • +Job Service
    • +License
    • Likes
    • +Localization
    • +Media galleries
    • +Members
    • Mentions
    • +Mobile
    • +Moderation, spam and abuse
    • +Notifications & messages
    • Our quality assurance testing strategy
    • +Page Editing
    • +Permissions
    • +Profile & sign-in
    • Quick Post
    • Ratings
    • Responsive design
    • +Roles
    • Rule Automation
    • +Scores
    • +Search
    • +Security
    • +SEO
    • +Site admin
    • +Site configuration
    • Social basics guide
    • Social Twitter feed
    • +Status messages
    • Tags
    • -Telligent Community Troubleshooting Guide
      • Can't insert an image using the enhanced text editor after upgrading
      • Common things to check when using Forms Authentication
      • Common webfarm configuration questions
      • Configuration problems
      • Exceptions
      • +Fix access to uploaded files
      • Friendly error message
      • How to: Load images inline
      • Search index problems
      • Search stop words
      • Sorry, there was a problem with your last request message
      • SQL times out when accessing the site
      • Telligent Job Service troubleshooting
      • Troubleshoot search errors
    • Terminology Guide
    • +Themes
    • Tour Tips
    • +Tuning & performance
    • +User accounts
    • +User reputation score
    • Video Transcoding
    • +Widgets
    • +Wikis
  • Customization
  • Development
  • Getting started
  • System Requirements
  • +How Do I Install Telligent Community
  • +Upgrade Telligent Community
  • Release Notes

SQL times out when accessing the site

If the site is running slowly or timing out due to SQL timeouts being reported on the site, it may be an indication that an SQL database reindex is needed. Here are the steps necessary to perform this task.

Primary Note

If the hardware is that where the server is dedicated to SQL, large space, powerful CPUs with greater than 4 GB RAM, chances are maintenance has not been done to the database itself. It's easy to perform these maintenance tasks below.

Procedure

  1. In SQL Management Studio, open a new query for the database in question, and type DBCC checkdb. Let the query complete and check on the very end of the results for 0 allocation errors and 0 consistency errors. If you see any allocation or consistency errors, STOP! There is database damage that Microsoft will need to work with the client to resolve.
  2. In SQL Management Studio, open a new query for the database in question, and type EXEC cs_system_dbreindex.

    Now try to access the site as normal, and you should see the performance increase greatly. We recommend to clients to create scheduled SQL jobs that perform these tasks at least once a week for good measure for the "rebuild and reindex" tasks, and daily for consistency checks.

    For more database maintenance information, see this article.

  • Share
  • History
  • More
  • Cancel
Related
Recommended
  • Telligent
  • Professional Services
  • Submit a Support Ticket
  • Become a Partner
  • Request a Demo
  • Contact Us

About
Privacy Policy
Terms of use
Copyright 2021 Verint, Inc.
Powered by Verint Community