July 2009 - Posts

• Performance impact: memory effectiveness of virtualization

  One of the key performance metrics on any computer system is its memory speed (or memory bandwidth). Memory speed can be measured in many different ways at different levels. At the OS level, one way to measure memory speed is to clock how fast (in terms Read More... Posted Wednesday, July 29, 2009 5:20 PM by Linchi Shea | 1 Comments Filed under: Performance, Testing, Benchmark, Memory speed, Virtualization Attachment(s): VM_physical.GIF

• Performance impact: Linked server security configuration and how it can hurt you

  If you change the security configuration of a linked server from using login UserA to login UserB, would you expect that to significantly impact the performance of a query that uses the linked server, assuming that both users have permission to select Read More... Posted Tuesday, July 21, 2009 2:16 PM by Linchi Shea | 22 Comments Filed under: Performance, Query Processing, Security, Distributed query, Linked server, Distributed join