SQL Server Performance

Website

Discussion in 'Please Tell Us What You Think' started by cmellon, Oct 30, 2002.

  1. cmellon New Member

    I would just like to say that this website is perfect. Theres hardly any good SQL websites, and the ones that are any good usually only cover 1 or 2 topics.

    So thanks for all the great tips.

  2. bradmcgehee New Member

    Thanks for your kind words. I have worked hard for over two years on providing useful information. There is still a lot I don't know about SQL Server, and I learn something new every day.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  3. sql777 New Member

    Hey!

    When did this forum get setup? I never noticed it before Brad !
  4. bradmcgehee New Member

    It officially started on November 1. I imagine it will start slowly, and then pick up once more people become aware of it. I will try to check in several times a day each weekday, and perhaps once a day during weekends. I can't promise to answer all questions, as I don't know every thing there is to know about SQL Server performance and clustering, but I will contribute what I know. I hope other will provide their own insights.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  5. satya Moderator

    Brad, I am regular visitor and follower to SQL Server performance site and recommends whoever has the problem with the performance.

    I am Senior Member of SQLMAG Forum and also would like to participate in this forum too.

    Now the site looks full-fledged one with another addition too.

    Keep it up.

    Satya SKJ
  6. bradmcgehee New Member

    Thanks. I look forward to your participation.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  7. franco New Member

    I am a frequent visitor of your web site for clustering and perfomance question.
    BTW, your article "How to upgrade a SQL Server 7.0 Cluster to a SQL Server 2000 Cluster" is great,unique and very clear.
    Take care.[8D]


    Franco
  8. Hi to all forum members !. I am new to SQL Administration etc, and have found lots of very useful information from your articles section.
    I am sure this site is going to be a very useful reference point for me in the future as I develop my SQL Server skills, No doubt.

    Good Website ! Very Informative !!

    Keep up the good work.


    Ahmed
  9. tkelley New Member

    Brad,
    Glad to see the forum, I'm sure this will cut down on the amount of emails sent to you, huh? This is a great web site, and thank you for your excellent help.

    [8D]

    *****
    MS, MCDBA, OCA, CIW
    *****
  10. marky New Member

    hi from Germany, finally a usefull site that is my favorite for my sql-server tuning problems. Is there anything planed like user based artikles to your main topics ? Kind of Forum to every article to discuss the specific features ??

    best regards from www.neu.de
  11. bradmcgehee New Member

    I am always looking for new articles. I try to contribute several new ones a month myself, but I need the help of others to contribute also. Besides running this website, I am a full-time DBA, and it is often hard to find the time I would like to write new articles.

    Probably the best way to discuss the merits of any article on this website is in this section of the forum. Just start a new topic, using the name of the article as the topic, and then we can discuss the article from there. How does that sound?


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  12. trifunk New Member

    Very cool site, I'd like to see more on the development side going on in the forums though, maybe a forum for SQL-DMO as well.

    Cheers
    Shaun

    World Domination Through Superior Software
  13. bradmcgehee New Member

    DMO is not an area where I have a lot of knowledge. Are there other member of the forum who does have some expertise in this are who could help out?


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  14. FrankKalis Moderator

    hi,

    I've just joined the forum and read in the faq something about email notification on new posts. How can I turn on this feature or is it disabled by the admin

    Cheers,

    Frank
  15. satya Moderator

    From FAQ
    Each level of subscription is optional. The administrator can turn On/Off each level of subscription for each Category/Forum/Topic.
    To Subscribe or Unsubscribe from any level of subscription, you can use the "My Subscriptions" link, located near the top of each page to manage your subscriptions. Or you can click on the subscribe/unsubscribe icons ( ) for that Category/Forum/Topic you want to subscribe/unsubscribe to/from.


    _________
    Satya SKJ
  16. FrankKalis Moderator

    Thanks for reply,

    I also read the faq, but what if I don't see the "My subscription" link anywhere on a page ????



    quote:Originally posted by satya

    From FAQ
    Each level of subscription is optional. The administrator can turn On/Off each level of subscription for each Category/Forum/Topic.
    To Subscribe or Unsubscribe from any level of subscription, you can use the "My Subscriptions" link, located near the top of each page to manage your subscriptions. Or you can click on the subscribe/unsubscribe icons ( ) for that Category/Forum/Topic you want to subscribe/unsubscribe to/from.


    _________
    Satya SKJ


    Cheers,

    Frank
  17. satya Moderator

    Webmaster should enable that option.
    Send a message to Brad.

    _________
    Satya SKJ
  18. bradmcgehee New Member

    I have turned on the subscription feature as a test to see what happens to performance of the forum. If there is no problem, then I will leave it on.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  19. FrankKalis Moderator

    hipphipphorray. Let's see what happens to performance. Shouldn't be too bad [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Cheers,<br /><br />Frank
  20. FrankKalis Moderator

    sorry to bother you again, but i think subscription is not working yet. this morning i've subscribe to the board, but i haven't received any emails yet. i played a little bit with the forum software myself, could it be you're using the wrong mail server component? i think you can choose between cdonts ... and cdosys. for me cdosys works fine, while cdonts doesn't work at all.



    quote:Originally posted by bradmcgehee

    I have turned on the subscription feature as a test to see what happens to performance of the forum. If there is no problem, then I will leave it on.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com

    Cheers,

    Frank
  21. bradmcgehee New Member

    You are correct, it does not yet appear to work. I will have to so some more research to find out why. Thanks.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  22. FrankKalis Moderator

  23. bradmcgehee New Member

    Thanks for your help. Subscriptions now seem to be working well.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  24. FrankKalis Moderator

    Hi,

    again I'm writing about subscription.

    As I have set up snitz forum for department internal use, I have also enabled subscription.
    Everything is working fine, except for the expressiveness of the notification mail.
    I want the text of the newly added posting to appear in the mail so everyone can see if this is a topic of interest or not. So I started digging into the code. All about subscription is encapsulated in inc_subscription.asp.
    I was about to change the SQL statements, when I received an answer on this topic on snitz.com. That is a very easy way to accomplish my task. So I posting this here. Maybe you as webmaster will make use of this.

    [Originalpost]
    ...
    Yes. I have modified our board to do this -- people reeaaally didn't like having to go to the board in order to read the messages. Forum code still shows as I didn't want to take the time to strip it out.

    The_Message = Request.form("Message")

    right above this line:
    ' ## Send the appropriate message depending on the subscription.

    Then I added these lines to the strMessage section (Note - they are not supposed to wrap):

    strMessage = strMessage & "Here is the text of the message:" & vbNewline & vbNewline
    strMessage = strMessage & "*****************************************" & vbNewline & vbNewline
    strMessage = strMessage & The_Message & vbNewline & vbNewline
    strMessage = strMessage & "*****************************************" & vbNewline & vbNewline
    strMessage = strMessage & "This is an auto-generated email from the Forums, please do not reply to this email." & vbNewline & vbNewline

    ...
    [Originalpost]

    HTH

    Cheers,

    Frank
  25. bradmcgehee New Member

    Thanks Frank, the code works and makes the subscriptions much more useful.

    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  26. FrankKalis Moderator

    de nada.

    it's me enjoying your site.


    Cheers,

    Frank
  27. vbkenya New Member

    I recently joined the forum, and I think it is a great effort on brad's part (and everybody else,of course).

    I see the forums quickly growing to deal with SQL server issues beyond the scope of performance tuning (compare the post statistics). Maybe its time to redesign the forum home page to reflect this?
  28. Chappy New Member

    I agree, it has gone beyond the scope of performance. I guess its up to brad whether he wants to concentrate on performance, or split the non performance forums out a little. Personally I read all the forums apart from the clustering one, so I think too much fragmentation can be a bad thing <img src='/community/emoticons/emotion-5.gif' alt=';-)' />
  29. bradmcgehee New Member

    How would you like to see the non-performance topics divided? Once I get some feedback, I will incorporate the changes you suggest. I don't think I want to get too specific, but would prefer "bigger" sub-topics.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  30. vbkenya New Member

    Maybe you could single out DTS (and other data transfer issues) as a starting point.
  31. gaurav_bindlish New Member

    We should have one tpic for T-SQL Problems. So that they don't clutter the Performance problems space. Then we can have a section for hardware configuration as well.

    Gaurav
  32. vbkenya New Member

    Since there is quite a bit of talking about Tools (Microsoft and third party) for different SQL server performance-related DBA tasks, I would not mind if had one place to ask and/or find information.
  33. bradmcgehee New Member

    I have added a few new categories. Let me know what you think, along with additional feedback.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  34. vbkenya New Member

    Looks fine to me...at least finding special areas of interest will become easier and statistically you (and all of us) will be able to see which SQL Server areas are the prime causes of DBA ulcers - and if performance is still the focus of this site.
  35. satya Moderator

    More the merrier.... keep going.

    _________
    Satya SKJ
  36. FrankKalis Moderator

    Hi Brad,

    What about making subscription mails even more meaningful?
    See, for future reference I transfer all mails into an SQL Server table. Now when I do a search say on Message Subject this isn't very useful right now as you can only see ' - New posting'
    What about showing as message subject the forum to which was posted and the topic that was posted?
    Offers some advantage, I think.

    To do so, just edit your 'inc_subscription.asp' file as replace your lines with the following


    The_Message = Request.form("Message")
    ' ## Send the appropriate message depending on the subscription.
    if LoopCatID > 0 then
    if LoopForumID > 0 then
    if LoopTopicID > 0 then
    strSubject = ForumName & ": [Re] " & TopicName
    strMessage = strMessage & MemberName & " has replied to a topic on " & strForumTitle & " that you requested notification to. "
    else
    strSubject = ForumName & ": " & TopicName
    strMessage = strMessage & MemberName & " has posted to the forum '" & ForumName & "' at " & strForumTitle & " that you requested notification on. "
    end if
    else
    strSubject = ForumName & ": " & TopicName
    strMessage = strMessage & MemberName & " has posted to the category '" & CatName & "' at " & StrForumTitle & " that you requested notification on. "
    end if
    else
    strSubject = ForumName & ": " & TopicName
    strMessage = strMessage & MemberName & " has posted to the " & strForumTitle & " board that you requested notification on. "
    end if

    Works pretty well here.

    HTH.


    Frank
    http://www.insidesql.de
  37. bradmcgehee New Member

    I'll try this out next week.

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

Share This Page