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 » internals   (RSS)
Showing page 2 of 2 (18 total posts)
  • 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