THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Monitoring   (RSS)
Showing page 2 of 4 (38 total posts)
  • Extended Events did it again: monitoring Stored Procedures performance

    In the last days I  had to work quite a lot with extended events in order to deeply monitor SQL Server performance. One interesting request that came out while implementing the monitoring infrastructure, was the possibility to monitor the performance of a set of stored procedures, vital for the correct handling of an online booking ...
    Posted to Davide Mauri (Weblog) by manowar on March 19, 2013
  • Trapping SQL Server Errors with Extended Events

    One very useful usage of Extended Events is the ability to trap SQL Server error without the need to have a server trace running (which, btw, is deprecated), with the additional feature of being able to query the data as soon as it comes in. This means that we a solution to monitor and trap errors as soon as they happen can be easily created, in ...
    Posted to Davide Mauri (Weblog) by manowar on March 17, 2013
  • High Availability for IaaS, PaaS and SaaS in the Cloud

    Outages, natural disasters and unforeseen events have proved that even in a distributed architecture, you need to plan for High Availability (HA). In this entry I'll explain a few considerations for HA within Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (SaaS). In a separate post I'll talk more about ...
    Posted to Buck Woody (Weblog) by BuckWoody on November 6, 2012
  • The Zombie PerfMon Counter That Never Dies! Quick Tip

    The PerfMon Counters That Just Won't DieOne of the things that's simultaneously great and horrible about the Internet is that once something gets posted out in the ether, it basically never goes away.  (Some day, politicians will realize this.  We can easily fact check their consistency).  Because of longevity of content posted to ...
    Posted to Kevin Kline (Weblog) by KKline on October 8, 2012
  • Two New Slide Decks. Plus, the Week in Colorado.

    I had the honor of traveling the great state of Colorado last week, speaking at the PASS chapters in Boulder, Colorado Springs, and Denver.  At all three events, we had a stellar attendance and, at least in Denver, broke all the records in recent memory both in terms of overall attendance and in first-timers. ...
    Posted to Kevin Kline (Weblog) by KKline on August 20, 2012
  • Recorded Webcast Available: Extend SCOM to Optimize SQL Server Performance Management

    Join me and Eric Brown, Quest Software senior product manager for SQL Server monitoring tools, as we discuss the server health-check capabilities of Systems Center Operations Manager (SCOM) in this previously recorded webcast. We delve into techniques to maximize your SCOM investment as well as ways to complement it with deeper ...
    Posted to Kevin Kline (Weblog) by KKline on June 28, 2012
  • Your Transaction is in Jeopardy -- and You Can't Even Know It!

    If you're reading this, please take one minute out of your day and vote for the following Connect item: If you're really interested, take three minutes: run the steps to reproduce the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 26, 2012
  • Give A Round of Applause for Microsoft System Center!

    I hope you've taken a few minutes to peek in on the nice refresh that's happened on a bunch of the System Center engineering blogs.  Good things are afoot there.  And if you haven't checked in, avail yourself of these great resources:System Center: Service ManagerSystem Center: Operations ManagerSystem Center: Virtual Machine ...
    Posted to Kevin Kline (Weblog) by KKline on April 30, 2012
  • Plan for Diagnostics in Cloud Computing From the Git-Go

    “Git-Go” is something we say in the South that means “right at the start”. I’ve seen several applications for on-premise systems that don’t have much in the way of diagnostics - the developers rely on a debugger, the event logs on the server and client workstation, and most of all, the ability to watch the system from end-to-end. This approach ...
    Posted to Buck Woody (Weblog) by BuckWoody on September 6, 2011
  • We don't always need mobile or web equivalents of our Windows applications

    At SQLRally, we brought along an iPad to demonstrate that monitoring doesn't have to be web-based to be mobile. We fielded a lot of questions about this, the most common one being, ''Whoa, is that native?'' No, it was not native... we were using remote desktop (RDP). While yes, it can be an extra step (or two, if you need to VPN) to go ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on May 19, 2011
Privacy Statement