SQL Server Performance
  1. rameshsee New Member

    ROWLOCK,TABLELOCK/X and other locks in SQL server are not working in MSDE. How to accomplish this in MSDE ?
  2. bradmcgehee New Member

    I have never used MSDE before, but based on what I found researching your question, locking hints should work for MSDE just like they do in SQL Server.

    If you are having a problem, are you able to run the same code (or similar code using the same locks) in a SQL Server database to see what happens? If your code run OK in SQL Server, then it may be a MSDE problem, but if it also doesn't work in SQL Server, the perhaps it is a syntax or related problem.

    Brad M. McGehee
  3. CSharpFriends New Member

    From what I know, MSDE is exactly the same thing as SQL Server Standard Edition except that it will not scale well. It has all the functionality that a full-blown version does.

    I have read that it scales do about 5-10 concurrent connections, after that performance will degrade (i.e its time to buy the real version).

    This doesnt' actually answer your question directly, but what I'm trying to say is that all the functionality is there in MSDE its performance is limited though.

    Here's a quote "These workloads are not dropped or lost; they are still processed, but in an increasingly degraded performance mode. If your solution must support more than five concurrent workloads, it is highly recommended that you migrate to SQL Server 2000"

    <a href="http://www.microsoft.com/sql/techinfo/development/2000/MSDE2000.asp">MSDE 2000</a>

    Hope this helps.

  4. gaurav_bindlish New Member

    MSDE and SQL Server are fully compatible with each other. So try detaching the database from MSDE and attach to SQL Server. If the code works then certainly its a problem with MSDE.


Share This Page