Entries for the 'Extended Events' Category

New SQL Server 2008 virtuals labs and yet another contest

There are some new SQL Server 2008 virtual labs.

SQL Server 2008 Virtual Labs

Choose a title below to begin your evaluation process.

• Evalu08 Virtual Lab: Change Data Capture
• Evalu08 Virtual Lab: Reporting Services Enhancements- Report Designer, Visualizations, and Tablix
• Evalu08 Virtual Lab: X-Event Infrastructure
• Evalu08 Virtual Lab: Declarative Management Framework
• Evalu08 Virtual Lab: Authoring Reports Using SQL Server 2008 Reporting Services  
• Evalu08 Virtual Lab: Working with the new DATE data type in SQL Server 2008 
• Evalu08 Virtual Lab: Administering Servers by Using Declarative Management Framework (DMF) Policies

Also just by evaluating, you are entered to win an HP home server box.

email it! |   |   | 

Permalink     0 Comments

Extended Events in SQL Server 2008 Part 2

Wow, I cry uncle. This stuff is hard to figure out. They are simply going to have to add tools to product and\or documentation a little more before I mess around with it. I am looking forward to Bob B’s session on it at SQL Connections in Orlando. Welp, on to Performance data collection and SSRS 2008 :)

email it! |   |   | 

Permalink     0 Comments

Extended Events in SQL Server 2008 Part 1

Woohooo! This has got to be the coolest feature in SQL Server 2008. It is also the biggest secret. The documentation is lacking. There is no GUI. I am sure it will be refined by RTM and future releases but let's get to know it.

Here are a few links:

10.0 BOL

• Introducing SQL Server Extended Events
• Using SQL Server Extended Events
• SQL Server Extended Events Concepts

MSDN Webcast

• SQL Server 2008 Advanced Troubleshooting with Extended Events

Bob Beauchemin's Blog

• XEvent in SQL Server 2008
• More about SQL Server 2008 extended events: packages, events, and event sessions

That is about all there is in the googles about XEvent's in SQL 2008. We are going to look at the DMV's and some examples next.

email it! |   |   | 

Permalink     0 Comments