Introduction This topic seems so simple, and so obvious to me, and do not mean to insult anyone’s intelligence. However, it is shocking to me the number of people that I have talked to (running large databases) that are not taking advantage of one of the best performance, and manageability enhancements out there! Think about […]
Archive | Performance RSS feed for this archive
My Favorite New(ish) 2008 Feature (Resource Governor)
I have written in the past about setting up the resource governor, which I am counting as my favorite new(ish) feature, so I am taking this TSQL2sday post opportunity do my promised followup for monitoring of the resource governor. Introduction To start with, my advice about the resource governor is to start small. Have some idea […]
Richmond CodeCamp Disk IO Presentation
This is a very similar post to the one from the user-group presentation post… and in fact the presentation itself is very similar. It has been updated, and a few things added since the last presentation, so I did want to post the updated version which was presented at codecamp. I hope that the presentation left you […]
Richmond Users Group Disk IO Presentation
A sincere thank you to everyone that came out to my presentation on disk IO. I hope that you had as much fun as I did, and (hopefully) took away a few things to think about. I would appreciate your feedback , I enjoy speaking, and the feedback helps me build better presentations for the future. […]
SSIS – Load Audit
Audits in SSIS create reusable packages that are easy to maintain, and provide valuable information about the data they are affecting.
2008 Resource Governor – Does it work?
The resource governor in SQL Server 2008 is a powerful tool to help you gain control over your query runtimes.
Help – My disk performance VI
Part VI in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers additional monitoring, and wraps ups some leftovers from this series.
Help – My disk performance V
Part V in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers basic monitoring.
Help – My disk performance III
Part III in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database partitioning and compression.
Help – My disk performance II
Part II in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers physical connection, and LUN layout on a SAN.
StefBauer's Blog - @StefBauer 