+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, SIMS .net MSDE connection limit in Technical; I recently ran a series of commands on the Sims.net server to see if we had often reached the MSDE ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,095
    Thank Post
    511
    Thanked 2,309 Times in 1,785 Posts
    Blog Entries
    24
    Rep Power
    803

    SIMS .net MSDE connection limit

    I recently ran a series of commands on the Sims.net server to see if we had often reached the MSDE connection limit. I can not remember or find those commands now.

    Can anyone point me in the direction of how to check if MSDE is limiting connections or not?

    Thanks

  2. #2

    Join Date
    Dec 2006
    Location
    Shrewsbury
    Posts
    40
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: SIMS .net MSDE connection limit

    This is interesting, because MSDE does not have a connection limit. Although, some non-server operating systems, such as XP, have a connection limit of 10.

    Could you be referring to a "performance penalty?" With MSDE there is a performance penalty when more than 8 simultaneous connections are "busy!"

    You can view the application event log for SQL Server 3629 messages or use the DBCC CONCURRENCYVIOLATION statement to assess how often the workload governor is activated. If the governor is frequently activated in a well-designed and well-tuned system, and the system is generating a lot of logical reads and writes, you should consider upgrading to SQL Server 2000 Standard Edition.

    Incidentally, we will be looking at a move to SQL 2005 (inc Express) which have no connection penalties. No timescales for this move, as yet.

    Hope this is of some help.

    Regards,

    Toby Belfield
    CAPITA

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,095
    Thank Post
    511
    Thanked 2,309 Times in 1,785 Posts
    Blog Entries
    24
    Rep Power
    803

    Re: SIMS .net MSDE connection limit

    Yep that is what I mean. The penalty works as a limit. So at any one time the server can only service 8 connections, queuing the others until later, when one of the 8 'slots' opens up.

    What about moving over to one of the other free database engines such as Postgresql or Mysql? I can understand wanting to stick to tools that .NET works with natively though.

  4. #4

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,248
    Thank Post
    33
    Thanked 335 Times in 225 Posts
    Rep Power
    75

    Re: SIMS .net MSDE connection limit

    The real limit with MSDE is actually the DB size which I think in 2G. We've tried >150 concurrent users without seeing any performance hit.

    With something as valuable as the data in the MIS we need to throughly test and introducing another variable such as the server itself would multiply costs hugely. MS costs to schools for SQL Server are very low.

SHARE:
+ Post New Thread

Similar Threads

  1. MSDE the instance name specified is invalid
    By timbo343 in forum Windows
    Replies: 8
    Last Post: 30th September 2010, 05:10 AM
  2. SIMS Connection failed - Reason 2
    By mortstar in forum MIS Systems
    Replies: 23
    Last Post: 5th June 2008, 12:48 PM
  3. VPN connection with internet connection option
    By FN-GM in forum Wireless Networks
    Replies: 6
    Last Post: 29th December 2007, 07:19 PM
  4. SIMS MSDE
    By ndavies in forum MIS Systems
    Replies: 8
    Last Post: 30th October 2007, 03:39 PM
  5. MSDE SQL
    By thom in forum Windows
    Replies: 4
    Last Post: 10th March 2006, 02:12 PM

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
  •