Two weeks from today, Brent Ozar will be speaking at CBusPASS. This time around Brent will be presenting on Using Cloud-Based BI to Interpret Perfmon & Profiler Results. LiveMeeting will be available. There won’t be a dial-in number, though. Why? Because the sound will travel through Brent’s microphone, into a series of tubes, and then it will fly out of your speakers at a very high velocity. That’s right, we have integrated LiveMeeting sound! When the time comes you just need to join the LiveMeeting and you should be good to go.
The meeting will be held, as per the usual, at Battelle For Kids, 1160 Dublin Road Suite 500, Columbus, Ohio 43215.
Note: Battelle For Kids has moved to a new suite in the same building.
Abstract
After learning how to use Perfmon and Profiler to gather performance statistics about your SQL Server, it still takes a lot of time to interpret those results and figure out what’s going on. Microsoft’s SQL Server Data Mining team has built a free cloud-based data mining tool for Excel that can help slice and dice mountains of data and help you make sense of it all.
Even if you’re not ready for BI in the cloud, you can use this same type of tool in combination with a local SQL Server Analysis Services instance. Wait! Don’t freak out – it’s much easier than you think, and you never have to leave the comforting environment of Excel. Even if this doesn’t sound like fun to you, you might want to learn about it because mid-level managers in your company might want to use this technique to analyze sales or customer data.
Attendees will learn how to install & configure data mining in Excel, how to analyze Perfmon data to break the server’s load into categories, and how to use BI to write a performance report about your SQL Server.
Live Meeting
May 14th, 2009 @ 6:30 PM EST.
Audio Information
Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
First Time Users:
To save time before the meeting, check your system to make sure it is ready to use Microsoft Office Live Meeting.
Troubleshooting
Unable to join the meeting? Follow these steps:
- Copy this address and paste it into your web browser:
https://www.livemeeting.com/cc/usergroups/join - Copy and paste the required information:
Meeting ID: NM86HK
Entry Code: 5\-b6|jkH
Location: https://www.livemeeting.com/cc/usergroups
