Tag Archives: administration

Finding the Default Trace File

Posted on May 7, 2012 by way0utwest

A post more for me than for anyone else, since I’ll look for something in the default trace and I often need this snippet of code: select path from sys.traces where is_default = 1 That returns something like this: path … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Finding the Default Trace File

Small Management

Posted on April 20, 2012 by way0utwest

This editorial was originally published on June 21, 2007. It is being republished as Steve is traveling. I saw this article on server management from a handheld and it’s always seen like something that’s very cool and handy, but I’ve almost never … Continue reading →

Posted in Editorial | Tagged | 1 Comment

Checking Your Service Account with T-SQL

Posted on February 22, 2012 by way0utwest

Somehow this slipped by me, but there were some new DMVs added in SQL Server 2008 R2 SP1. I suspect my test machines were mostly SQL Server 2008 or SQL Server 2012, and I hadn’t been paying attention to the … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Enabling Compression? Update your baseline

Posted on January 25, 2012 by way0utwest

I wrote recently about capacity planning, with an item near the end about disk usage. Someone pointed out to me that compression can dramatically affect your baseline, and as you implement it, or de-implement it, you need to update your … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Enabling Compression? Update your baseline