Apr 22, 2014 | Learning Tree, Performance, SQL Server 2012, SQL Server Training |
I have just returned from a trip to Washington DC where I was delivering course 2105 – SQL Server 2012 DBA skills upgrade class in an onsite class to one of Learning Tree’s clients. For those of you that don’t know, a Learning Tree onsite is event is when Learning...
Mar 11, 2010 | Database Mirroring, Performance, Snapshots, SQL Server 2008, SQL Server Internals, SQLServerPedia Syndication |
This post is the second post in my series about Database mirroring. For part one is titled Configuring Database Mirroring in SQL Server. I believe that high availability is the primary reason people mirror their important production databases. Depending on your...
Feb 18, 2010 | Performance, Statistics |
This is a short note explaining he sys.dm_os_wait_stats DMV. This DMV returns the following columns/values regarding waits encountered by executed threads: Wait_type waiting_tasks_count – The number of waits on this wait type. wait_time_ms – The total wait...
Feb 9, 2010 | IO, Performance |
I have been having an IO subsystem issue recently and I found the whitepapers very useful and wanted to post the URLs here for future reference: SQL Server IO best Practices SQL Server IO Basics – Chapter 2 SQL Server Pre-deployment IO best practices
Feb 7, 2010 | IO, Performance, Storage |
This is a short post on SQL Server storage best practice and what i have learned over the years… Much of this information can be found in Microsoft’s document on Storage Best Practice and this can be found here Test your setup before deployment. MS have useful utility...
Feb 4, 2010 | Performance, Performance Monitoring, Trace |
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in SQL Server 2005 and beyond and it is enabled by default when you install SQL Server. It has a number of uses from auditing to capacity planning and I will...
