SQL Phone Home: Teaching Your SQL Servers to Call for Help

10

March 19, 2016 by Mike Hillwig

I’ve worked in quite a few shops that have differing views on SQL Server monitoring. A lot of this involves creating scripts and SQL Agent jobs that fire alerts. The problem is that these tend to become noisy. So I’ve come up with a “see something, say something” methodology.

If you’ve ever ridden the New York City subway, you’ve probably heard the “If you see something, say something” phrase. It’s what I’m modeling this after.

As I go through this presentation, I start with a premise and then build on it. I start with basic alerts and then go through looping through your data to build a more complex alert. Rather than than describe it in a blog, just play with my scripts and see what I do.

You can find the scripts here: sqlphonehome

10 thoughts on “SQL Phone Home: Teaching Your SQL Servers to Call for Help

  1. Latesha says:

    I think that the best way would be to start out with the AGPL version and then upgrade to the enterprise version if your network is getting enough players. As long as you are using the AGPL version of Cubeia Poker you have to make the source available, which means that any moocfiiatidns to the poker source have to be made public. This is probably ok when starting up, but if you start to get some serious traction you probably want to be able to develop the poker in your own direction without sharing the code, i.e. switch to a commercial license.

  2. Eu não endeuso ninguém. Não tenho ligações no Corinthians, tenho com o Corinthians. Mas te digo, o Andres nunca foi … bem deixa para lá. Qualquer dia eu falo.

  3. 279c237anna:936c2a5Недавно попалась книжка со скороговорками. одна из них следующего содержания: «ÃÂ•Ã‘Ð»Ð¸ с дерева упала макаронина, значит, эта макаронина — воронина». И еще один вопрос (не совсем по теме): у Пушкина в «ÃÂ¡ÃÂºÃÂ°ÃÂ·ÃÂºÃÂµ о мертвой царевне и…» есть такая строка: «ÃÂžÃ‘‚ зеленого вина отрекалася она». Что такое зеленое вино? Молодое? Я уже несколько лет задумываюсь.19cbbb

  4. 4a7142ona 26c6b82d2This is a good posting, I was wondering if I could use this write-up on my website, I will link it back to your website though. If this is a problem please let me know and I will take it down right away22

  5. Using the term “Hispanic”, who exactly is being counted? Hispanic Carribean Mulattos and blacks? Mexican and Central American mestizos and Indians? White, European Spaniards? Using an ethnic group as a racial category is both quite odd and misleading. In fact, the “Asian” category may be no longer used because of so much Indian immigration.

  6. Good to see Marco properly respected by everyone. I feel terrible for his family and girlfriend but they have been amazing through all this. I wish I could hear the tribute at Valencia for him. That’s going to sound insane.

  7. What i do not realize is actually how you’re not really much more well-liked than you may be now. You are very intelligent. You realize therefore significantly relating to this subject, produced me personally consider it from so many varied angles. Its like women and men aren’t fascinated unless it’s one thing to do with Lady gaga! Your own stuffs nice. Always maintain it up!

  8. Oh I KNEW you were going to use that quote. Gah!And oh man, Bea is in sooo much trouble. I know that look on her mom’s face.…and for some reason this is the ONLY website currently working on my computer. Oro?

  9. evet ÅŸu an saatler 14:30 u gösteriyor, anlık sıcaklıklarda cephenin oluÅŸturduÄŸu ciddi fark var kırıkkale -1 ankara 4 kütahya 6 derece, umarım çok uzun sürmez ankara’da ÅŸehir merkezinde dahi sabah kar yağışı ardından yaÄŸmur hadisesi gerçekleÅŸtive bu arada çok ciddi bir ÅŸey olmadıkça light snow yazısını kullanan the weather channel tahmin merkezi ankara’ya severe-heavy snow ikonu koymuÅŸ

  10. la gabbia mentale serve per limitare la realta' ad una piccola porzione tale che possa essere capita. non serve per chi riesce a capirla tutta nel suo insieme. praticamente oggi viviamo in un allevamento. a quando la raccolta?:-)indopama

Leave a Reply

Your email address will not be published. Required fields are marked *