The most recent content from our members.
My friend and colleague @jason.hall (@SQLSaurus) has been cranking out a great blog series on Mining Performance Data from SQL Sentry (Part 1) Last week I received three separate requests about how to query Top SQL data that we've collected with Performance Advisor, so I thought I would pitch in and help Jason out. He…
A customer recently asked me how they could detect any trends in network availability, since they knew that when we lose connectivity to a server, we have a client alert that indicates that - at least as far as we're concerned - the server is offline. They were trying to correlate these network blips with real service…
Introduction We covered a lot in Mining Performance Data from SQL Sentry (Part 5) , and at the end we were able to start working with SQL Server waits statistics stored in the SQL Sentry repository database. In this post, since we don’t need to go over a lot of table definitions, I want to focus on the query itself, and go…
Introduction As I promised in Mining Performance Data from SQL Sentry (Part 4) , we're going to start digging into database objects that will let us mine current, and historical, performance data from the SQL Sentry database, starting with this post. There are quite a few objects that store metadata or data concerning…
Introduction In Mining Performance Data from SQL Sentry (Part 3) on mining performance data from the SQL Sentry database, we learned about several repository tables that store information about the storage schema for a server. This time, we’ll learn how to query for information pertaining specifically to SQL Server files.…
Introduction In Mining Performance Data from SQL Sentry (Part 2) we took a quick look at a table that lets us query some information about the Operating System from the SQL Sentry repository database. In this post, we're going to kick things up a notch, and go over some tables that will give us a picture of our storage…
Introduction In Mining Performance Data from SQL Sentry (Part 1) of this series we learned how to use the SQL Sentry repository database to find out about the various computers and connections SQL Sentry knows about. In this post, we're going to build on that foundation, and use it to get some deeper information about the…
Introduction SQL Sentry Client Services encompasses both our Professional Services group and our Technical Support group. Between the two there are often requests for assistance mining performance metrics from the repository database. We don't publish an ERD mainly because we reserve the right to change it, sometimes…
Recently, a SQL Sentry user asked me how they could monitor how much CPU their jobs were consuming. However, resource utilization is not tied to jobs explicitly but rather to the queries those jobs run. So, I started off by showing them how to gain some insight into this by column grouping in Top SQL. (If you are not…
It looks like you're new here. Sign in or register to get started.