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 » Performance   (RSS)
Showing page 2 of 2 (20 total posts)
  • 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
  • New on KEK.com - Presentation: SQL Server for Oracle DBAs

    Back in late May, my pal Buck Woody (blog | twitter) and I presented SQL Server for the Oracle DBA.  Buck played Jerry Lewis' role, while I played the straight man a la Dean Martin.  You can see the recording and slide deck here.  Since both Buck and I spent a considerable number of years working on Oracle, we felt like we had ...
    Posted to Kevin Kline (Weblog) by KKline on August 2, 2010
  • Two Free Training Webcasts Open for Registration

    We've got two sessions that you need to sign up for right away.  The upcoming webcast for Oracle-oriented folks has huge registration numbers.  So get in while you still can before we hit the limit of what LiveMeeting can handle. Pain of the Week: SQL Server for the Oracle DBA Webcast: SQL Server for the Oracle DBADate: ...
    Posted to Kevin Kline (Weblog) by KKline on May 24, 2010
  • 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
  • Old Performance Tuning Recommendations Die Hard

    It’s interesting to me that old and inaccurate performance tuning recommendations seem to have a life of their own.  In some ways, old performance tuning recommendations are like the Undead from some kind of cheesy, 1970’s zombie movie – no matter how many times you shoot them, they just keep coming back.   Here’s a good case in point, ...
    Posted to Kevin Kline (Weblog) by KKline on June 23, 2009
  • 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
  • Brains still matter - silly SSD notions

    Everytime a good product comes out, people seem to contrive bad ideas for what can be replaced, usually brains, or people with brains, or that people lacking brains can accomplish something on their own. Let me put it simply. Suppose one had a query that uses a nonclustered index, and required a key lookup, and the key lookup required a disk ...
    Posted to Joe Chang (Weblog) by jchang on September 8, 2008
  • IO Cost Structure – Anticipating SSD arrays

    An observant person has probably noticed that SQL queries requiring disk reads not only have longer duration but also higher CPU times. It is not hard then to deduce that disk access (for both HDD and SSD), which involves the OS performing an IO call, the SQL Server process finding a place in the buffer cache for the data pages, and possibly ...
    Posted to Joe Chang (Weblog) by jchang on September 4, 2008
  • NUMA AND TCP PORT AFFINITY

    If you’ve ever taken the time to read http://www.tpc.org/results/FDR/TPCC/hp_orca1tb_win64_fdr.pdf, you might find a bit in there that’s confusing.   ''Microsoft SQL Server 2005 Enterprise Edition 64-bit Service Pack 1 was configured to utilize ''soft NUMA'', a feature that allows network connections to be affined to specific groups of CPUs ...
    Posted to Kevin Kline (Weblog) by KKline on April 24, 2008
  • About 64-bit

    Back in the 1997 time frame, I gave a presentation projecting out when 64-bit operating systems and applications should become pervasive in the high volume platforms. My best estimate was this would be some time in 2003 or 2004. This meant that hardware platforms should be ready in 2001 or 2002 to allow for reasonable software availability, ...
    Posted to Joe Chang (Weblog) by jchang on March 28, 2008
Privacy Statement