THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Monitoring   (RSS)
Showing page 1 of 4 (38 total posts)
  • sp_whoisactive: The Big Fixes!

    Four and a half years have flown by since I released sp_whoisactive version 11.11. It's been a pretty solid and stable release, but a few bug reports and requests have trickled in. I've been thinking about sp_whoisactive v.Next -- a version that will take advantage of some newer SQL Server DMVs and maybe programmability features, but in the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 18, 2016
  • sp_whoisactive for Azure SQL Database - Attempt #2

    Over a year ago now I announced a rough port of sp_whoisactive to Azure SQL Database. This worked thanks to Microsoft finally aligning the Azure DMVs to the box product DMVs...until Microsoft decided to rip out one of the key DMVs, sys.dm_os_sys_info and its ms_ticks column. This column is the key to unlocking various metrics in some of the other ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 14, 2016
  • sp_whoisactive and Azure SQL Database

    I've received a number of requests over the past couple of years for an Azure-specific version of sp_whoisactive. Given the combination of a lack of interesting DMVs available in Azure and my general lack of interest in all things Azure related, creating a modified version of the proc has not exactly been a top priority. Luckily, now I don't have ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on April 10, 2015
  • SSISDB Monitoring Queries on GitHub

    I’ve moved my SSISDB scripts from Gist to GitHub where I can maintain them more comfortably. So far, I’ve published 6 scripts: ssis-execution-status: Latest executed packages ssis-execution-breakdown: Execution breakdown for a specific execution ssis-execution-dataflow-info: Data Flow information for a specific execution ...
    Posted to Davide Mauri (Weblog) by manowar on January 19, 2015
  • Top 10 DBA Mistakes on SQL Server. (Now with Prizes for Participation!)

    The first big mistake I made as a DBA was coming to work with my zipper wide open. But I digress.Hear one of my most popular session via streaming media at SQLSentry.TV!Microsoft SQL Server is easier to administrate than any other relational database on the market.  But “easier than everyone else” doesn’t mean it’s easy.  And it doesn’t ...
    Posted to Kevin Kline (Weblog) by KKline on April 9, 2014
  • Join Me on March 14 in Silicon Valley for a Full-Day of SQL Server Configuration Tuning Lessons

     Join me for a day ofReal World Database Configuration and Tuning for Microsoft SQL ServerSQL Saturday Silicon Valley 2014Friday, March 14, 2014 from 8:30 AM to 4:00 PM (PDT)Mountain View, CAClick HERE to register Now! Seating is very limited! This full-day training event combines a thorough overview of fundamental architectural concepts ...
    Posted to Kevin Kline (Weblog) by KKline on February 18, 2014
  • Wait Statistics in Microsoft SQL Server

     (Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics.  In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...
    Posted to Kevin Kline (Weblog) by KKline on October 9, 2013
  • Use TPC Database Benchmarks to Save Money

    Last month, I began a series of articles describing database application benchmarking. In the first article, I told you about different ways that you can construct your own database application benchmark. However, you don’t have to reinvent the wheel. The Transaction Processing Council (www.tpc.org) has already created a large number of ...
    Posted to Kevin Kline (Weblog) by KKline on April 29, 2013
  • Read the New TPC Database Benchmarking Series

    Let's talk about database application benchmarking.This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this article published in my monthly column at Database Trends & Applications magazine, I'll give you a brief introduction to TPC benchmarks and, ...
    Posted to Kevin Kline (Weblog) by KKline on April 22, 2013
  • SQLintersection!

    The best emotion to describe how I'm feeling is 'astounded'.  I'm astounded that I'm in such august company to be speaking the SQLIntersection (#iSQL) conference.  Read the blog post from my first SQL Server mentor, Kimberly Tripp, which tells you all about SQLintersection.Check out this list of speakers:Aaron Bertrand, ...
    Posted to Kevin Kline (Weblog) by KKline on March 27, 2013
1 2 3 4 Next >
Privacy Statement