+ Post New Thread
Results 1 to 9 of 9
MIS Systems Thread, Database query timed out in Technical; Hi all, Many of the SIMS users in my school are getting this error with different fault codes Database query ...
  1. #1

    Join Date
    Jul 2010
    Posts
    36
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Database query timed out

    Hi all,

    Many of the SIMS users in my school are getting this error with different fault codes
    Database query timed out

    Any solutions please

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Stick Commandtimeout=1000000 into the connect.ini would be a workaround.

  3. #3

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,905
    Thank Post
    1,186
    Thanked 1,057 Times in 749 Posts
    Rep Power
    328
    I would be tempted to check the stats on the server live as you run a test with the teaching staff.

    Arrange for a test time when all the teachers can log in to the Sims and check through the task manager the live stats and this may help you determine whether it is the server or the client that is having the problems.

    Depending on the queries that each teacher is running it would be advisable that each client workstation has at minimum 2Gb of Ram.

    We run with 4Gb in all our workstations which have the Sims client running on them.

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Log it with Capita. I take it the fault codes return no solutions...?
    Check server for speed and issues - see other thread for that (there's a recent one on sql 2008)
    What are they doing? running reports? Then try them yourself or on the server direct.
    There is a CommandTimeout=10000 parameter you can add to connect.ini that sometimes helps too, but not sure if it's relevant to your case. You could try it, starting with a lower number and see what happens. If you search SupportNet it's mentioned there in context.

  5. #5

    Join Date
    Jul 2010
    Posts
    36
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks, the issue sorted by Sticking Commandtimeout=1000000 into the connect.ini

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Just to confirm, that is a workaround, you still have a performance issue that will need to be resolved.

  7. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    And, i would keep the timeout lower than 1 million ;'P
    10 seconds should be enough, 15 minutes might be a little excessive to wait for a report.

  8. #8

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Quote Originally Posted by vikpaw View Post
    And, i would keep the timeout lower than 1 million ;'P
    10 seconds should be enough, 15 minutes might be a little excessive to wait for a report.
    Gives you enough time to start the SQL engine, or run and hide

  9. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    i can reboot my server in about 5 mins or less now it's VM. that solves all my problems, once i've got all the users logged out that is

SHARE:
+ Post New Thread

Similar Threads

  1. Ruckus SSID query - timed access
    By TheFopp in forum Wireless Networks
    Replies: 4
    Last Post: 17th September 2010, 03:17 PM
  2. Timed Deny Lists
    By anthonygilbert in forum Internet Related/Filtering/Firewall
    Replies: 4
    Last Post: 15th January 2010, 12:57 PM
  3. Making a database - general query
    By Halfmad in forum General Chat
    Replies: 3
    Last Post: 21st January 2008, 08:51 PM
  4. Timed shutdown problem
    By Lazyletters in forum Windows
    Replies: 7
    Last Post: 4th December 2007, 02:44 PM
  5. Query of existing query data in PHP
    By markwilliamson2001 in forum Web Development
    Replies: 5
    Last Post: 5th October 2007, 08:43 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •