SQL Server Performance

SQL-Server-Performance Forum Will Be Down

Discussion in 'Forum Announcements' started by bradmcgehee, Jun 8, 2004.

  1. bradmcgehee New Member

    As a part of a move to boost the performance of the forum, and the entire website, I am taking two new steps this weekend.

    First, I am moving the website to a dedicated server. Currently I am using a shared server.

    Second, I am moving to a newer version of the Snitz forum, which is supposed to have some performance improvements.

    Because the new dedicated server is located a different hosting company, I must change the DNS entry for the website. As most of you know, this can take 24-48 hours, or more, to completely propogate throughout the entire Internet. During this time, the forum will be partially down, although the website will still be available at all times.

    By partially down, what I mean is that you will be able to read posts, but any new posts will not be saved, and will be lost.

    I will move the website this upcoming Saturday evening (Central North American Time), and hopefully by Monday (Central North American Time), the forum will be up and ready to be used, and hopefully be much faster.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  2. Luis Martin Moderator

    Good news, Brad.<br />BTW: Next time, include "partially" in post title, to avoid strokes[<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br />
  3. satya Moderator

    Oh, what I'm going to do for 48 hours [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] ... just kidding.<br /><br />Thanks Brad if the downtime is for better-quality then go ahead and keep up the charm.<br />I hope to see few advantages over current version with new version of Snitz.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
  4. bradmcgehee New Member

    I have been testing the new version today, and so far, I haven't see a big a boost in performance as I would like. I will keep working on it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  5. bradmcgehee New Member

    If you are reading this, then you are reading it from the new dedicated server. I am now running both IIS, email, and SQL Server on my own dedicated server, and based on my testing, it appears to be faster. Please let me know your feedback. Also, look for any mistakes I might have made during the conversion, especially as this is also the latest version of the Snitz forum.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  6. derrickleggett New Member

    Looks good Brad. I've been poking around some today. The response times look good.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  7. satya Moderator

    Magic, yes the response time on forum is swift and also I like the facility of grey out of [Submit reply] as soon as the button is clicked to answer a post to avoid duplicate post in same thread.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  8. bradmcgehee New Member

    Again, if you see anything odd in the forum, or on the website, please let me know so I can fix it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  9. satya Moderator

  10. Luis Martin Moderator

    Well done, Brad, faster than before.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  11. gaurav_bindlish New Member

    This is amazing Brad....<br /><br />Looks like you got tired off people not visiting the site because the response time was too large.... I hope that list does not include me [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1"><br /><font size="1">The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.</font id="size1">
  12. satya Moderator

    Brad

    I get following message couple of time today when browsing thru Active topics:

    Active Server Pages error 'ASP 0113'

    Script timed out

    /forum/post_info.asp

    The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.

    Could you please look into the issue and resolve it.

    Thanks.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  13. bradmcgehee New Member

    I'll check into it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  14. Argyle New Member

    I have one issue as before. When you post the redirect back to your post takes time for some reason. If you open up another browser and surf to the thread one can see that the post is already there but the redirect is still in a "pending" mode in the other browser. Doesn't look SQL related to me. Is the Snitz forum using Response.Redirect or Server.Transfer when redirecting?
  15. bradmcgehee New Member

    It appears to be using Response.Redirect. On my fast connection at work, I don't see any performance issues at all, but I imagine slower connections still may be an issue.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  16. derrickleggett New Member

    It works great for me Brad. I'm a bit spoiled though since I live right by a switch. It's definitely better then sqlservercentral.com. Talk about a site needing an overhaul. SLOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOWWWWWW!!!!

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  17. satya Moderator

    I have had this error once yesterday (when tried from home) and so far so good today.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page