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 » cost based opti... » Performance   (RSS)
  • 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
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement