SQL Server Performance

SQL Server Performance Tuning Classroom Training

Discussion in 'Please Tell Us What You Think' started by bradmcgehee, Jun 19, 2003.

  1. bradmcgehee New Member

    I would like to get the forum members feedback on the following topic.<br /><br />I am considering putting on a 3-4 day training seminar on how to Performance Tune SQL Server. This would be held in a hotel meeting room, most likely in Kansas City, MO, sometime the first quarter of 2004.<br /><br />Here are the areas where I would like everyone's input. Please try to provide as much input as you can. There are a lot of questions, so please bear with me.<br /><br />1) How many people would be interested in attending such a seminar?<br /><br />2) How long (how many days) should the seminar be?<br /><br />3) Should it be designed for beginners, intermediates, or experts?<br /><br />4) Where should it be held? This is tough. I have suggested Kansas City because it is centrally located and reasonably inexpensive.<br /><br />5) What should be the primary focus of the training? For DBA, developer, both?<br /><br />6) How much is such a seminar worth? In other words, how much should the seminar cost? Typically, I have found such seminars to run from about $895 to $1,495.<br /><br />7)When would be the best time to hold the seminar (such as the month and the days of the week?)<br /><br /><img src='/community/emoticons/emotion-11.gif' alt='8)' /> Also, would anyone be interested in a 1 day seminar on how to configure Windows and SQL Server clusters? If so, please let me know.<br /><br />9) Any other feedback you have.<br /><br />I haven't decided to do this yet, but if there is enough interest, I will give it a try, as long as I don't end up loosing money.<br /><br /><br /><br />-----------------------------<br />Brad M. McGehee, MVP<br />Webmaster<br />SQL-Server-Performance.Com
  2. gaurav_bindlish New Member

    1) How many people would be interested in attending such a seminar?<br />Appx, 100-150<br /><br />2) How long (how many days) should the seminar be?<br />1 Day<br /><br />3) Should it be designed for beginners, intermediates, or experts?<br />Somewhere between intermediate to experts<br /><br />4) Where should it be held? This is tough. I have suggested Kansas City because it is centrally located and reasonably inexpensive.<br />Where there are plenty of flights and hence the fares are less. I would go for Phoenix, Chicago or Minneapolis<br /><br />5) What should be the primary focus of the training? For DBA, developer, both?<br />Both. Sessions for both interest. I would recommend hardware tuning as well<br /><br />6) How much is such a seminar worth? In other words, how much should the seminar cost? Typically, I have found such seminars to run from about $895 to $1,495.<br />Depends on you. I would say $500-$1000. <br /><br />7)When would be the best time to hold the seminar (such as the month and the days of the week?)<br />This can be discussed with the patricipating people.<br /><br /><img src='/community/emoticons/emotion-11.gif' alt='8)' /> Any other feedback you have.<br />This is a great idea and I think you should do it. This will give a good chance to all the performance experts to intract with each other. Do inform all the SQL Server based companies and Microsoft about this and if possible get somebody form Microsoft to attend this. This will give lot of publicity and exposure to you and the event.<br /><br />Best of Luck!<br /><br />Gaurav
  3. vbkenya New Member

    Although I am sure I can't attend, I think an effective Performance Tuning seminar:

    [Q.(3)+ (5)] Should be directed towards intermediate to expert SQL Server DBA's and developers. You may decide to have different but related sessions outlining the two respective perspectives and one session to provide the link between these perspectives.

    [Q. 6] The cost per delegate should, at least, reflect the overall absorption of your total overheads for a scenario of 10 delegates :
    (a) Your travel and accomodation costs (if applicable)
    (b) Hiring of the hotel room and the necessary equipment
    (c) Any stuff you plan to issue to delegates i.e handouts, CD's, software
    (d) Opportunity cost of time taken off your regular income generating activities (if applicable)
    (e)A 25% contigency markup on all of the above.
    (f)A 20% final markup....or 0% if you prefer charity


    Prospective broad objectives for the sessions:

    (1)Proactive practices:
    (i) Designing for performance
    -Client application design issues
    -Database design issues
    (ii)Hardware Tuning
    -Storage, Processor and Memory
    -Connectivity
    (2) Reactive practices
    (i) Query Tuning
    (ii)Troubleshooting performance issues
    (3) Other/General
    (i) Replication, Backup,Clustering etc.
    (ii) Tools

    I think a gruelling 3 days should be enough for you.

    Nathan H.O.
  4. satya Moderator

    Elegant replies by fellow peers, I would like to say :<br /><br />3) Should it be designed for beginners, intermediates, or experts?<br />Beginners & INtermediate should attend and may select expert(s) to give their presentation which might help as a live study.<br /><br />5) What should be the primary focus of the training? For DBA, developer, both?<br />Mostly the performance is a major part of DBA, this should be with DBA & Developers with optimum years of development experience (say 3 yrs atleast).<br /><br />6) How much is such a seminar worth? In other words, how much should the seminar cost? Typically, I have found such seminars to run from about $895 to $1,495.<br />It varies and depends on the venue of the seminar, as Nathan divided perfectly which gives optimum costing.<br /><br />7)When would be the best time to hold the seminar (such as the month and the days of the week?)<br />Day of the week from Wednesday to Friday.<br /><br /><img src='/community/emoticons/emotion-11.gif' alt='8)' /> Any other feedback you have.<br />After the seminar if it can be circulated or available thru a link (video presentation) to the forum members, that would be helpful to many of the SQL peers. (specially us who are out of US) <img src='/community/emoticons/emotion-5.gif' alt=';-)' /><br />Also if you concentrate a half-day worth of slides/topics for YUKON, that would be most-interested to the companies/Professionals who are awaiting YUKON release (atleast BETA). Though most of this topic covered by Tech-Ed, still it is worth.<br />I am sure other companies might be interested to sponser the event, as this is catchy and important event for any database management.<br /><br /><br />Lastly, forgot to praise your(Brad) innovative idea.<br /><br />_________<br />Satya SKJ<br />
  5. bradmcgehee New Member

    Thanks for the feedback so far, and I look forward to more. Once I get more feedback, and give more thought to this, I will let everyone know what I decide.

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

    How long (how many days) should the seminar be?<br />Not less than 2 days. <br /><br />Should it be designed for beginners, intermediates, or experts?<br />Intermediates-experts. Beginner have many other recources and I think would not<br />rush (them or the companies) into spending working days and money on a seminar.<br /><br />Where should it be held? This is tough. I have suggested Kansas City because it is centrally located and reasonably inexpensive.<br />Any chance you'll get to Firenze, Italy? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />What should be the primary focus of the training? For DBA, developer, both?<br />Both. Especially if are talking intermediates-experts. I think both developer and DBA can benefit from knowing each others work.<br /><br />How much is such a seminar worth? In other words, how much should the seminar cost? Typically, I have found such seminars to run from about $895 to $1,495.<br />I don't know much about prices there in the US, but what you suggested seems resonable for 3-4 days of seminar. <br /><br />When would be the best time to hold the seminar (such as the month and the days of the week?)<br />I guess towards the weekend. it might be easier especially for those who are coming from far, plus it gives you the weekend to digest and go over the material while everything it still fresh in your mind.<br /><br />Any other feedback you have.<br />Great area. I envy those who can attend. <br /><br />Bambola.
  7. GreatInca New Member

    1) How many people would be interested in attending such a seminar?<br />Probably me and Ted. Maybe Ted can bring his game guru 11 year old twins (one codes and does graphics the other does story/designs/levels).<br /><br />2) How long (how many days) should the seminar be?<br />Depends on amount of quality learning.<br /><br />3) Should it be designed for beginners, intermediates, or experts?<br />Definitly not beginners. Cheaper ways to train them. I consider myself expert in design & performance, though not neccessarily elite. Ted it intermediate.<br /><br />4) Where should it be held? This is tough. I have suggested Kansas City because it is centrally located and reasonably inexpensive.<br />I hate Missouri but the kansas city wizards do play there. Good soccer anchor oppurtunity depending on timing. If no soccer anchor then I prefer Tulsa, OK . Definitly not anywhere cold.<br /><br />5) What should be the primary focus of the training? For DBA, developer, both?<br />Both. I am both, stronger on developer.<br /><br />6) How much is such a seminar worth? In other words, how much should the seminar cost? Typically, I have found such seminars to run from about $895 to $1,495.<br />Depends on what you get for it and how well we can convice Aaron to give it out.<br /><br />7)When would be the best time to hold the seminar (such as the month and the days of the week?)<br />Timing for soccer anchor would be best (start friday or end friday; there are some wednesday games). W/o soccer I prefer end of week.<br /><br /><img src='/community/emoticons/emotion-11.gif' alt='8)' /> Also, would anyone be interested in a 1 day seminar on how to configure Windows and SQL Server clusters? If so, please let me know.<br />Don't need it yet but might later (aaron might not be willing to fund a seminar trip yet)<br /><br />9) Any other feedback you have.<br />Addig Hands on to the training would be big boost.<br />
  8. Luis Martin Moderator

    100% agree with Gaurav.

    Kansas City?, far away from Argentina.
    But, after seminar I would like to have some materials.

    Luis
  9. satya Moderator

    Brad, any renewal information on this seminar?

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  10. bradmcgehee New Member

    I didn't get the kind of response I was hoping for, so I have postponed the idea for now, although I am still interested in doing it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  11. nasi_aslam New Member

    i want to attend all ur seminar plz inform me how can i do<br /><br />Nasiha<br /><br /><br /><br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by bradmcgehee</i><br /><br />I would like to get the forum members feedback on the following topic.<br /><br />I am considering putting on a 3-4 day training seminar on how to Performance Tune SQL Server. This would be held in a hotel meeting room, most likely in Kansas City, MO, sometime the first quarter of 2004.<br /><br />Here are the areas where I would like everyone's input. Please try to provide as much input as you can. There are a lot of questions, so please bear with me.<br /><br />1) How many people would be interested in attending such a seminar?<br /><br />2) How long (how many days) should the seminar be?<br /><br />3) Should it be designed for beginners, intermediates, or experts?<br /><br />4) Where should it be held? This is tough. I have suggested Kansas City because it is centrally located and reasonably inexpensive.<br /><br />5) What should be the primary focus of the training? For DBA, developer, both?<br /><br />6) How much is such a seminar worth? In other words, how much should the seminar cost? Typically, I have found such seminars to run from about $895 to $1,495.<br /><br />7)When would be the best time to hold the seminar (such as the month and the days of the week?)<br /><br /><img src='/community/emoticons/emotion-11.gif' alt='8)' /> Also, would anyone be interested in a 1 day seminar on how to configure Windows and SQL Server clusters? If so, please let me know.<br /><br />9) Any other feedback you have.<br /><br />I haven't decided to do this yet, but if there is enough interest, I will give it a try, as long as I don't end up loosing money.<br /><br /><br /><br />-----------------------------<br />Brad M. McGehee, MVP<br />Webmaster<br />SQL-Server-Performance.Com<br /><hr height="1" noshade id="quote"></blockquote id="quote"></font id="quote">
  12. satya Moderator

    The seminar is not yet scheduled and this post is just for a feedback and ideas from Members to conduct the proposed classroom training seminar.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  13. bradmcgehee New Member

    Thanks, Nasiha, for your interest. When I make a decision, I will let everyone know.-

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

    Brad,
    It has been very nice to hear from you to talk about such an informative session. I believe that there are a lot of resources available for basic to intermediate level information sesions. What I would be interested in is some very low level and undocumented resources that are really useful to troubleshoot some major performance issues. If you are interested in such a venture, I would be interested in even contributing some very interesting low level and undocumented tools I have access to. Keep me posted.
    Israr Haq



    quote:Originally posted by bradmcgehee

    Thanks, Nasiha, for your interest. When I make a decision, I will let everyone know.-

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

    If you check out the home page, you will see that I will be teaching a full-day seminar at SQL PASS this fall. If you have any tips you would like to share, please do so.

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

    I believe that Microsoft support does a very poor of explaining /3GB, /PAE switches on a 4GB+ system esp for sql7 (not AWE aware). I would be interested in a demo of that if possible. Also, projecting show plan and statistics IO usage. Developers need to know of what they are writting. And always, undocummented commands like dbcc log, loginfo, sqlperf(waitstats). Even throwing a few trace flags as well.

Share This Page