Tag Archives: sql server

Resource Governer–Memory Limits

Posted on January 12, 2011 by way0utwest

I had looked at the Resource Governor early on when it was being developed and first released on SQL Server 2008, but I hadn’t spent a lot of time on it. It was the first cut at a throttle that … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Resource Governer–Memory Limits

MCM Prep – Only ONE Transaction Log File

Posted on January 4, 2011 by way0utwest

Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves performance. The writes are not striped across files. Instead SQL Server will write to one file, then the next, then … Continue reading →

Posted in Blog | Tagged , , | Comments Off on MCM Prep – Only ONE Transaction Log File

MCM Prep – VLF Allocations

Posted on December 30, 2010 by way0utwest

I had heard that you could have too many VLFs in your transaction log, and it could cause performance issues. Kimberly Tripp has a great blog on how to get better performance from your log, but until I was studying … Continue reading →

Posted in Blog | Tagged , , | Comments Off on MCM Prep – VLF Allocations

Getting a Dedicated Admin Connection

Posted on December 28, 2010 by way0utwest

Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way. … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Getting a Dedicated Admin Connection