August, 2006

  • Slava Oks's WebLog

    SQLOS's DMVs

    • 8 Comments
    SQL Server 2005 has a large number of DMVs that you can take advantage of especially when you try to understand behavioral characteristics of your SQL Server 2005 installation. DMVs expose enormous amount of information but how can you make use of it...
  • Slava Oks's WebLog

    Q & A: I can't make SQL Server 2005 32 bit version to use all memory on the machine

    • 6 Comments
    I’m currently using the RTM+SP1 x86-SQL2005 build on a server which has 32GB of physical memory. I notice that during ramp-up the memory usage (as seen under task manager) increases to about 28GB (i.e. “Available memory” reduces to 4GB) and stays there...
  • Slava Oks's WebLog

    Talking points around SQL Server 2005 scalability

    • 10 Comments
    Couple of weeks ago I did a talk on SQL Server 2005 scalability. The actual talk was not about the enormous amount of features that you can leverage in SQL Serve 2005 to make your application scale but rather how SQL 2005 achieves its scalability. In...
Page 1 of 1 (3 items)