examples with SS2008 -xEvents?

[B D Jensen]

Hi!
There are some small examples in the new BOL, but not what I look for.
Has anyone some good links with xevents showing wait stats?
Best regards
Bjorn

[Erland Sommarskog]

Re: examples with SS2008 -xEvents?

B D Jensen (bjorn.d.jensen @gmail.com) writes:

There are some small examples in the new BOL, but not what I look for.
Has anyone some good links with xevents showing wait stats?

X-Events seems to be a feature that it will take some time to digest.
I get the impression that it is primarily meant to be a building block
to build tools on. For SQL 2008, the only feature to use X-Events is
SQL Audit. I would expect more in the next version of SQL Server.

Of course, you could still use X-Events to run your on trace, but I have
not come around to try that yet.

From a fellow MVP, I got these links to presentations on X-Events:
SQL Server 2008 Advanced Troubleshooting with Extended Events

http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032356290%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e

Extended Events (Xevents)

http://www.microsoft.com/heroeshappenhere/TestDrive/sql-server-2008/default.mspx

I had to through a lot of hassle to view the first one, whereas accessing
the second was just a key-click.

Unfortunately, none of the presentations very good with examples. The
first is marred by technical problems, so most of the demos are lost.
The guy in the second video is very fast, and has this funny id of
saying "sp underscore statement underscore completed". He has some
good examples in the demos, but you may not be able to see his queries
in full.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[DA Morgan]

Re: examples with SS2008 -xEvents?

Erland Sommarskog wrote:

B D Jensen (bjorn.d.jensen @gmail.com) writes:

>There are some small examples in the new BOL, but not what I look for.
>Has anyone some good links with xevents showing wait stats?

>
X-Events seems to be a feature that it will take some time to digest.
I get the impression that it is primarily meant to be a building block
to build tools on. For SQL 2008, the only feature to use X-Events is
SQL Audit. I would expect more in the next version of SQL Server.
>
Of course, you could still use X-Events to run your on trace, but I have
not come around to try that yet.
>
From a fellow MVP, I got these links to presentations on X-Events:
SQL Server 2008 Advanced Troubleshooting with Extended Events

http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032356290%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e

>
Extended Events (Xevents)

http://www.microsoft.com/heroeshappenhere/TestDrive/sql-server-2008/default.mspx

>
I had to through a lot of hassle to view the first one, whereas accessing
the second was just a key-click.
>
Unfortunately, none of the presentations very good with examples. The
first is marred by technical problems, so most of the demos are lost.
The guy in the second video is very fast, and has this funny id of
saying "sp underscore statement underscore completed". He has some
good examples in the demos, but you may not be able to see his queries
in full.

Looks like they're working on a technology similar to the Event tracing
in Oracle. That is excellent news for those DBAs that must be able to
work effectively in both environments.
--
Daniel A. Morgan
University of Washington
damorgan@x.wash ington.edu (replace x with u to respond)