Voice of the DBA

Author: way0utwest

  • No More Drive Extender – Windows Home Server

    I guess I might need to go back to RAID. From the Windows Team Blog, there is a decision to remove Drive Extender from the next version of Windows Home Server. Based on the comments, I’m not alone in thinking this is a stupid move.

    The big challenge for me was automatically protecting the data on my various computers. Windows Home Server gave me an easy way to copy the data, and also have it on multiple drives, so it was safe in the event of a drive failure. I have heard that the larger 1TB and 2TB drives are more likely to have corruption as well, so there’s more of an issue here.

    Putting RAID together for small systems is a hassle, though perhaps R1 isn’t a big deal if you have 2TB drives. In any case, I’ll be thinking about whether I need to stick with WHS in the future or migrate to some other solution.

  • Changing Jobs

    I interact with a lot of people about their jobs, both online and at various events like SQL Saturdays. With my Modern Resume presentation, I attract a lot of people that are interested in finding a new job, or sometimes just finding any job. Apparently these are not an out of the ordinary group of people. According to a ComputerWorld survey, over one third of respondents are looking to find a new job.

    The last few years have been a hard economy for many people, and for many companies. Raises have been small or non-existent, layoffs have occurred, and it seems that IT workers must do more and more with less resources all the time. Those are not necessarily conditions that make for happy workers.

    But is it time for a job change for you? Only you can really answer that question for yourself, but I would urge you to open a dialog inside your company if the answer is “yes.” Either with your immediate boss, or perhaps with another department, and look for some way to make your job better. Find new duties, rotate into some other area, or tackle a project of interest to you. There are some very difficult managers out there, but most of them would rather retain you if they can. Finding new employees is a pain.

    More money doesn’t usually help you enjoy your job more. I’ve rarely had any friends think that they made a good decision when they took a job primarily because it paid more. Instead the people that are most happy are those that picked the job that best fit them, without worrying about the money. I’m certainly one of those; I took a pay cut to get this job years ago.

    Life is short. Don’t stay in, or take, a crappy job if you can avoid it.

    Steve Jones

  • Multiple Mirrors

    Up through SQL Server 2008 R2 database mirroring has been limited to a single mirror for each database. While that does work well for many companies, as you become larger and more dependent on your computer systems, there is a need to have multiple mirrors.

    Often someone wants to failover to another database on the same network for capacity reasons if there are minor issues. Moving all clients to a secondary data center is not something you always want to do, especially as the secondary data center might not include the same level of bandwidth and may cost more.

    HADR

    In SQL 11, there is work underway to implement HADR, high availability and disaster recovery, which is an enhanced database mirroring. In this new technology, multiple mirrors are possible, allowing you to have multiple up to date copies of your data in separate locations. These are now called “replicas” and you get up to 4, according to Brent Ozar (HADRON Rocks). I didn’t see that listed, but I’m sure Brent knows more about this stuff than I do.

    The other nice things is that you can failover multiple databases together, which you put in an “availability group” and configure together. This is good since many applications might require multiple databases, and it could be important that all databases move to the same server at the same time.

    Overall this is cool, and I am looking forward to this technology being deployed. Only one replica works in CTP1, so we can’t really see this working, but it could be an amazing edition to your DR strategy in the future. One note is that this is built on Windows clustering, which no longer requires shared storage, but might require Enterprise Edition, so that will limit how widely this is deployed.

    I’ll write more on this later, but the ability to have multiple mirrors, and have multiple databases failover as a group, is something that DBAs should look forward to.

  • Help with Performance

    One of the things that so many people working with SQL Server struggle to do is identify what is happening on their servers. Despite all the DMVs, DMFs, and other tools available, I regularly see questions posted about the trouble people have with digging into SQL Server and finding out what is wrong. There is so much information available that often people are not sure where to start looking.

    In the past few weeks I noticed two great posts that should help you to better understand what is happening on your SQL Server. One is about the release of “Who Is Active v 10” from Adam Machanic, which is a great tool. The other is a series of queries from Glenn Berry that give you a lot of diagnostic information about your instance.  Both of these are tools that you should add to your toolbox and learn to use.

    In addition to having tools to dig into what might be going on right now in your instance, monitoring your server instances is also critical for being able to determine what kinds of problems you have. After all, if you don’t know what’s normal, how can you tell what’s not normal? Many of the consultants I know have to spend hours at new clients getting a feel for the environment because they’re not familiar with it. You have no such excuse for your own servers.

    The sign of a good DBA is having monitoring in addition to knowing how to troubleshoot performance issues. A great DBA will also use this information to look ahead and anticipate problems.

    Steve Jones

    If you don’t want to build your own system, be sure to take a look at SQL Monitor, a new tool from my employer, Red Gate Software. It can help you keep track of multiple servers and provide you the history and reporting to understand what is “normal” for your instances.