+1-888-365-2779
Try Now
More in this section

Forums / Deployment / Remote SQL Performance

Remote SQL Performance

2 posts, 0 answered
  1. Cameron
    Cameron avatar
    42 posts
    Registered:
    27 Jul 2009
    06 May 2010
    Link to this post
    Hi all - I'm curious to hear others' experience when using a remote SQL Server. Here's the situation:

    During development, I'm using a SQL Express database on the same server as the Sitefinity web server and the performance is great. For production, I'm moving the database to another standalone SQL Server and performance stinks. The database server is in our domain and the web server is in the DMZ.

    My network guys have analyzed packets and traffic and it does not appear to be a firewall specific issue. I have also tried the database on a second server with similar results.

    Anyone have similar experiences? Am I just expecting too much from a SQL Server outside the DMZ?
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    07 May 2010
    Link to this post
    Hello Michael Buchsbaum,

    It looks like there is some delay between request and response from the project and SQL server. You could also use Fiddler and  SQL Profiler to narrow down this issue.

    Sincerely yours,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
2 posts, 0 answered