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 » performance monitoring   (RSS)
  • Hey Amsterdam and Stockholm: Just Say No to Guessing About Performance!

    Have SQL Server performance problems? What are you going to look at? Can you quickly isolate the root cause? Or do you ever find yourself stuck, not sure of what to do next? That's what the No More Guessing seminar is all about. This seminar teaches you to use:Baselining: An analytical methodology based on statistical analysis and evidence ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on September 20, 2013
  • [New England] SQL Saturday #203: April 5-6, Cambridge MA

    SQL Saturday returns to the Boston area this April, with what is certain to be an exceptional speaker and session lineup. (The actual schedule will be posted soon, but in the meantime you can see the submitted sessions.) The free event ($10 if you'd like to eat lunch) will take place on Saturday, April 6. Highly recommended for anyone in the area ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on January 29, 2013
  • Who is Active v11.11

    Fixes the following issues:Bug with transaction information not working for databases with ''th'' in their nameBug with very large CPU times causing an overflow exception on SQL Server 2005Excessive tempdb utilization caused by large string concatenationAdded host_process_id to additional_info collection
    Posted to Beta Projects (FileGallery) by adam machanic on March 22, 2012
  • Who is Active v11.03

    Contains fixes for a couple of minor bugs that existed in v11.00.
    Posted to Beta Projects (FileGallery) by adam machanic on July 8, 2011
  • An in-depth analysis of SQL Sentry's overhead

    One of my first major projects at SQL Sentry was framed shortly after I joined the company: to publish an analysis of the overhead that Performance Advisor and Event Manager place on both the server(s) being monitored and on the server(s) doing the monitoring. Every vendor wants to sell you on the ''zero impact'' and ''no footprint'' lines, but we ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 5, 2011
  • Who is Active? v11.00

    Who is Active? is a comprehensive server activity stored procedure based on the SQL Server 2005 and 2008 dynamic management views (DMVs). Think of it as sp_who2 on a hefty dose of anabolic steroids. Features supported by Who is Active? include: Server activity collection, including data about currently running T-SQL, server resources ...
    Posted to Release Builds (FileGallery) by adam machanic on April 27, 2011
  • Who is Active? v10.00

    Who is Active? is a comprehensive server activity stored procedure based on the SQL Server 2005 and 2008 dynamic management views (DMVs). Think of it as sp_who2 on a hefty dose of anabolic steroids. Features supported by Who is Active? include:Server activity collection, including data about currently running T-SQL, server resources ...
    Posted to Release Builds (FileGallery) by adam machanic on October 21, 2010
  • Who is Active? v10.00: DMV Monitoring Made Easy

    Today I am happy to release the newest official build of my Who is Active procedure: v10.00. For those of you who haven't been following along, here are some quick facts on Who is Active:Who is Active is a DMV-based monitoring stored procedure that uses 15 different views to show a large amount of data about what's running on your serverWho is ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 21, 2010
  • SSMS : Which parts do you love? Which parts do you hate?

    I find myself categorizing a subset of SSMS features ranging from ''must have'' features to ''cringe when they are mentioned.''  I'll try to summarize the standouts for you here, then ask you these questions: Which parts of SSMS do you rely on? Which do you wish were not there at all? The ''I almost always use it to get the task done.'' ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 22, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement