OA performance SQLserver 2008 vs SQLserver 2012

4 posts, 0 answers
  1. XXXX
    XXXX avatar
    57 posts
    Member since:
    Jun 2008

    Posted 12 Nov 2012 Link to this post

    I have a strange problem.

    In the development environment I get acceptable performance (my measure 4500 operations/min)

    but when I run the same test in the production environment the performance is unacceptable (only 625 operations/min).

    The only difference that I'm aware of is that the development uses SQLserver 2008R2 vs SQLserver 2012 in production.

    Thanks in advance.

  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 12 Nov 2012 Link to this post

    Hi Björn,

    please check that both servers use the tcp protocol to talk to each other, otherwise we might compare apples and peaches. I see no other principal reason why there should be a difference of that kind.
    Or is the production server doing some logging/auditing more than your dev server? What is the difference in pure SQL execution (from Management Studio)?

    Kind regards,

    Thomas
    the Telerik team
    Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
  3. DevCraft banner
  4. XXXX
    XXXX avatar
    57 posts
    Member since:
    Jun 2008

    Posted 12 Nov 2012 Link to this post

    As usual I didn't provide enough information.

    This is a n-tier application where the OA ORM is running on IIs 7 on Windows Server 2008R2.

    The production environment has much better hardware so it has to be configuration or SQL connection.

    There is one thing I noticed that might be relevant and that is that the development IIs machine has SQLserver 2008 Native client installed where as the production doesn't have any SQLserver Native client installed.

    The OA Orm product page says : "Telerik OpenAccess ORM provides built-in support for a wide range of databases to allow you to connect to one or more databases without the need to install additional components. "

    Which I take as no need to install additional drivers.

  5. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 13 Nov 2012 Link to this post

    Yes, no additional drivers should be needed! And in fact, the installed ones do work, but in a different speed.
    Unfortunately, we do not have a customer grade pure ADO level performance test; otherwise this would be the next step: to figure out if the ADO layer is the reason. Maybe it's also firewalls, or network card configuration (I have seen this!).
    Again: Do normal Management Studio SQL queries show a similar performance degration? Or is it a different data set, requiring additional indexes? You could also turn on the OpenAccess profiler to figure out if it is a specific query that takes the time.

    All the best,
    Thomas
    the Telerik team
    Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
Back to Top