john.m.couch (4/9/2012)

---

I was under the impression there was a performance overhead with WMI Alerts. And I was really just looking for the textual output provided to send in the email....

john.m.couch (4/9/2012)

---

Jonathon - I took/adjusted your code along with someone else's modified version of your code, and have gotten stuck trying to figure out why it sometimes retrieves and sometimes...

You'd have to write a process that query's the system_health session for graphs and then emails you them. There is no way to do it otherwise.

The SQL# package that Solomon mentioned a few posts up this thread does http://www.sqlsharp.com/%5B/url%5D

sqlfriends (2/6/2012)

---

Thanks all, this is a server that hosts vendor product for network department that manges VDI.

SO this message: There is insufficient system memory in resource pool 'internal' to run...

Post a script that would generate a repro in your environment and I'll see if I can do the same in mine.

If you created the job on ServerA and then scripted it out so that you could just run the script against Server B to create the job, this would be...

The base values aren't provided in the perfobject_logical_disk event and you can't derive what that base is from the physical_page_read event, which tracks individual page reads, not the actual I/O...

v.sreelekha (1/20/2012)

---

Hi All,

I am trying to access the configuration file from sql clr sp,I am able to do that in win xp os,sql server 2005 SE.

But when i deployed the...

Drop the crack pipe?

I'd recommend following your own advice because...

+1. A really good book isn't necessarily due to the authors own knowledge. In most...

TravisDBA (1/19/2012)

---

Well..Brad McGeHee wrote a entire book on it and he does not say that at all, quite the contrary, so who should I listen to? Him or you? BTW,...

No, but then again I wouldn't use Extended Events for this type of task, I would instead use Event Notifications as shown in my PASS 2011 demos:

http://www.sqlskills.com/resources/conferences/300_UsingEventNotificationsSQLServer20052008.zip

Cheers,

Yes, the root of the blocking could be from a previous statement in a transaction.

This is covered...