Browse by Tags

• pass
• Speaking
• SQL Server
• SQL Techniques
• SQL Tools

• Quest DMV Breakfast Code – Disk IO

  For any of you who attended the Quest breakfast at PASS (and anyone else really) I wanted to go ahead and post the code and give a little wrap up/explanation. (I will post the stuff on perf counters later. They are cool, but this is really what I wanted...( Read More... Posted Thursday, November 05, 2009 3:52 AM from Louis Davidson | (Comments Off) Filed under: SQL Server, Dynamic Management, pass, SQL Tools, Speaking, SQL Techniques

• Dynamic management function query to view I/O pressure

  The sys.dm_io_virtual_file_stats dynamic management function returns I/O statistics for data and log files [MDF and LDF file], with two parameters, one for database_id and another for the file_id. This function will help you to identify I/O file level. Read More... Posted Saturday, April 07, 2007 11:32 AM from Louis Davidson | (Comments Off) Filed under: SQL Server, Dynamic Management