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 » Performance » Architecture   (RSS)
  • SQL Server Hardware

    From Red-Gate website you can download (for free) the ebook SQL Server Hardware written by Glenn Berry (@GlennAlanBerry). This ebook will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on October 29, 2014
  • Accelerate OLTP with HP and Microsoft's New High Performance Reference Architecture

    If you haven't started to read Shashank Pawar (blog), you're missing out. Shashank is part of Microsoft Australia and has been writing some very good content lately. Here's an example from the Reference Architecture for High Performance SQL Server:HP and Microsoft engineering teams have worked together to create a reference architecture to ...
    Posted to Kevin Kline (Weblog) by KKline on March 6, 2012
  • Bad database practices: moving data to procedures vs. moving procedures to data

    Is it better to move data to procedures or move procedures to data?   The answer is, of course, “it depends.” Let’s consider a scenario where you have two SQL Server instances: ServerA and ServerB, and you have a procedure on ServerB (call it procB), but need to access data on ServerA.   Three database solutions are ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 30, 2009
  • Amdahl’s Law

    For the past few weeks, I’ve been working on a diverse array of issues ranging from studying SQL Server performance on various multi-core processors, pondering the implications of many-core processors, troubleshooting SQL Server performance problems, looking at the scalability of Oracle RAC and Sybase shared-disk clusters, and so ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on February 11, 2008
  • Where does Time Go?

    A significant part of my job is to evaluate how SQL Server (and sometimes other DBMSs) performs on various hardware platforms, in particular on the processors and its related chipsets as they are being released. So naturally, I’ve been paying attention to performance analysis of DBMSs.   One of the papers at the top of my reference ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 2, 2008
  • Best and Worst Checkpoint Performance

    The best documentation on the I/O behavior of SQL Server checkpoints is found in SQL Server 2000 I/O Basics by Bob Dorr. In particular, you should read the following carefully: SQL Server uses the following steps to set up another page for flushing and repeats for up to 16 total pages inclusive of the first page. Do a hash lookup for the ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on November 1, 2007
  • Hash Partition as a Design Method

    SQL Server 2005 does not support hash partition as a product feature. But that doesn't mean you can't apply the concept of hash partition in your application or database design. Recently, I worked on an application that used SQL Server to persist the customized ASP.NET session state information, similar to the SQL Server mode for ASP.NET session ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 22, 2007
  • 32-bit vs. x64

    When it comes to the issue of 32-bit vs. x64, you can easily walk away from a presentation with an impression that going to x64 will most likely give your SQL Server application a performance boost. I'd like to show you--with some test data--that you should be careful with that impression. The following three environments were tested on exactly ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on January 2, 2007
  • Rowset string concatenation: Which method is best?

    Yeah, yeah, yeah, let's get this out of the way right from the start: Don't concatenate rows into delimited strings in SQL Server. Do it client side. Except if you really have to create delimited strings in SQL Server. In which case you should read on. There was a little discussion on SQLTeam about the best way to concatenate. I ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Privacy Statement