November 2012
Intermediate to advanced
576 pages
17h 2m
English
book
Professional SQL Server 2012 Internals and Troubleshooting
by Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee
Content preview from Professional SQL Server 2012 Internals and Troubleshooting
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 12
Bringing It All Together with SQL Nexus
WHAT’S IN THIS CHAPTER?
- Getting familiar with SQL Nexus
- Loading data into a Nexus database
- Analyzing the aggregated data
- Customizing SQL Nexus
- Common issues and how to resolve them
WROX.COM CODE DOWNLOADS FOR THIS CHAPTER
There are no code downloads for this chapter.
INTRODUCING SQL NEXUS
SQL Nexus is a tool used by SQL Server professionals and Microsoft engineers to aggregate SQL Trace data, performance monitor logs, and the output of various T-SQL scripts into a single SQL Server database. This chapter explains how the data collected by SQLdiag, covered in Chapter 11, can be imported into a SQL Server database and then analyzed with the help of existing reports in SQL Nexus. SQL Nexus is a free tool available on the Microsoft CodePlex site and is provided on an as-is basis. This means that the Microsoft Support team does not support SQL Nexus and any issues related to the tool need be posted on the discussion forum of the tool’s home page on the CodePlex site.
NOTE This chapter assumes that the concepts discussed earlier in this book are already understood or have been read so that the analysis patterns discussed later in this chapter are clearly understood.
SQL Trace refers to both trace files captured using the client side SQL Profiler and the server-side SQL Trace.
SQL Nexus uses three components:
- RML Utilities (also known as ReadTrace) — A tool to aggregate data collected by SQL Trace files and import them into a SQL ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.