The most recent content from our members.
This is specifically for it to be clickable to whatever I need. But a use case is to open Perfstack. I want to create the url myself, as I may wish to use different entities that can appear in the perfchart. I don't want to use saved perfstacks
SQL Sentry Performance Advisor provides a substantial amount of information about your SQL Server environment. I'd like to focus today on our patented Disk Activity view. In many SQL Server environments, disk I/O is one of the biggest bottlenecks. Being able to see which drives and database files are most active can help…
When thinking about what to write about for my first official blog post, I knew I wanted it to be something that could help our users get more out of our products. A great feature that I find gets overlooked quite frequently by SQL Sentry users is Runtime Statistics. The Runtime Statistics graph allows you to see…
When it comes to frequent performance bottlenecks on SQL Server, few are as frequent or as problematic is I/O latency. Relational databases, by their very nature, perform a great deal of I/O both to support the ACID properties of transactions as well as to cache the most frequently used data and code for maximum…
When @jason.hall mentioned a new version, I will admit, I had some goosebumps. I knew that a new module that we had been working on for many months was finally going to see some daylight. Nothing is more exciting than once again blowing the doors off the native tools and providing you with another feature that helps you…
A question customers frequently ask of our support and professional services teams is: "How do I get Performance Advisor to collect performance counter <X>?" This is something that's quite easy to do, although there are a few things a DBA needs to consider before starting down this path: * Why do you want this new counter…
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…
Occasionally, you may need to connect the SQL Sentry Client to a SQL Sentry database in another domain. If you don't have a SQL authentication login for that server, you will need Windows Authentication, using a remote domain account. But without a trust, you won't be able to use the credentials from your local…
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…
It looks like you're new here. Sign in or register to get started.