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 » Internals » troubleshooting » Performance   (RSS)
  • Learn More About SQL Server IO and Query Tuning in These Webcasts

    I'm doing two new webcasts next week on Wednesday, December 19th, one in the morning and the other after lunch.   SSDs are a Game Changer for SQL Server Storage No, session is not exclusively about SSDs.  But this is my first session on IO and storage tuning that emphasizes SSDs over hard disks.  As Bob Dylan said ''Times, they ...
    Posted to Kevin Kline (Weblog) by KKline on December 14, 2012
  • SQL Server Performance Tuning and Optimization in Jacksonville, FL on April 27th

    One last reminder -  If you're interested in learning more about troubleshooting and optimizing SQL Server performance, please consider coming to the full-day seminar I'll be giving this Friday.  Full details are here: http://sqlperftuning.eventbrite.com/.  We'll be working some exercises, so bring your laptop with an instance ...
    Posted to Kevin Kline (Weblog) by KKline on April 23, 2012
  • Microsoft Windows Platforms Blog Watch

    Remote Desktop Services Component Architecture Poster Grab your own poster! A visual guide to key Remote Desktop Services technologies in Windows Server 2008R2     Virtually Free Get the latest update rollup package for the Hyper-V role in Windows Server 2008 R2 and be sure to bookmark the Windows Virtualization ...
    Posted to Kevin Kline (Weblog) by KKline on July 20, 2011
  • New on SQLMag.Com: Update to SP_WHOISACTIVE

    I profiled Adam Machanic's (blog | twitter) excellent stored procedure, SP_WHOISACTIVE, back in August of 2010 in my monthly SQLMag column, Tool Time.  Adam has been diligent about maintaining the tool and adding new features. Read the details on my SQLMag Tool Time column (here - ...
    Posted to Kevin Kline (Weblog) by KKline on April 21, 2011
  • Join Me May 19th for 24 Hours of PASS

    Join Us for 24 Hours of SQL Server Training (with a special focus on SQL Server 2008 R2)Did I mention that your Cohorts in Crime (that be me and Brent Ozar) are presenting?!? The FREE 24 Hours of PASS event is bringing an exceptional lineup of SQL Server and BI experts to your computer starting at 12:00 GMT (UTC) on May ...
    Posted to Kevin Kline (Weblog) by KKline on April 26, 2010
  • Memory from Every Angle

    It seems like questions always come up about how to monitor memory.  But each time the question comes up, it’s slightly different.   Here’s a sort of FAQ for memory questions:   1.  How can I figure out memory and CPU consumption by database? a.  In SQL Server 2005, DMVs are of course the way to go.  Pre-SQL ...
    Posted to Kevin Kline (Weblog) by KKline on October 14, 2008
  • SOS_SCHEDULER_YIELD

    You might encounter a situation, under a very heavy workload, where processing for certain transactions starts out very efficiently, but over time becomes much less efficient.    A good place to start troubleshooting is, of course, PerfMon.  But PerfMon can fail to reveal the culprit, since the CPU can remain stable and moderate ...
    Posted to Kevin Kline (Weblog) by KKline on May 14, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement