August 2006 - Posts

• SQLOS's DMVs

  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? Read More... Posted Tuesday, August 22, 2006 7:54 PM by slavao | 8 Comments Filed under: SQLOS, SQLOS's DMVs

• Talking points around SQL Server 2005 scalability

  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 Read More... Posted Thursday, August 03, 2006 11:09 AM by slavao | 10 Comments Filed under: SQL Server Memory Management, SQL Server Scheduling

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

  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. Read More... Posted Thursday, August 03, 2006 10:41 AM by slavao | 6 Comments Filed under: SQL Server Memory Management, Q&A