Category: Blog

  • Planning

    I made it to the UK on a very smooth, uneventful, on-time trip. That’s just what I like when traveling. After arriving at Heathrow and traveling to Cambridge, I arrived at the Red Gate office just in time for lunch. A fortuitous event as I was hungry after flying all night.

    Most of my afternoon was meeting with various product groups talking about planned enhancements and changes and how these items might benefit DBAs in the field. Grant and I are usually called on for sanity checks on thoughts, ideas, and plans.

    It’s interesting to discuss with product groups how and why they want to make changes. I can’t talk about specifics, but hearing from developers and project managers is always interesting to me. We see the world differently and it’s good to give feedback on products that can make a DBA’s job easier. I haven’t always had the chance to do that, but when I do, it’s a growing experience to hear how a vendor sees the world.

    I wrote about this recently, and a few disagreed, thinking that Microsoft doesn’t listen to them. I disagreed then, and I still do. I get an opinion at Red Gate, and with Microsoft. I don’t get to make a decision, or even much of a vote, but I do get to voice my opinion. Just because it isn’t followed doesn’t mean that someone didn’t listen.

    I don’t know to what extent my thoughts will influence the products, but I did see and discuss things with a variety of people in different departments, and the discussions evolved, so I know my opinion is heard. Whether it changes things remains to be seen.

  • Back Across the Water

    Another trip to the UK this week, with me leaving today for Cambridge and meetings at Red Gate Software. This will be my third trip this year, a record for me, and also the most travel I’ve done in a year.

    We are doing some planning for 2013, for the community and various events that Red Gate is a part of each year. We’ve supported user groups, SQL Saturdays, various conferences and our own SQL in the City events. Our goal is to interact with the community and learn things about how people use our software, as well as promote it, but also to educate data professionals. We want to turn a profit, but we also want to be a part of the community and support it where we can.

    I wish I could say that I’ll travel less next year, but I’m not sure that’s the case. We are looking to more effectively provide support, with more value for the money we spend, but I suspect that will mean more travel for Grant Fritchey and myself.

    We’ll see what happens, and we’ll likely start booking some events in 2013 soon. If you have ideas, suggestions, or requests, please feel free to post something here or send an email to communities@red-gate.com.

  • Speaking at Oracle Training Days

    RMOUGSpeakerA first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to those that typically work on the Oracle side of things.

    The Rocky Mountain Oracle Users Group is holding their Training Days 2013 event on Feb 11-13 in Denver and a few of us SQL Server people were invited to speak.

    I’ll be talking about Database Maintenance one of the days, hopefully ensuring that some of the “accidental” SQL Server DBAs that also manage Oracle understand the basics of maintenance in SQL Server.

  • SQL Server Thumbnail Metrics – OS Memory

    I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to run a SQL Server. This is a series of posts that I’m making to gather these metrics up for easy access later.

    Host Memory

    The short metric is:

    Leave 4GB for the OS, or 10% of physical (or guest) memory, whichever is greater.

    Examples: If I have the following amounts of RAM, I leave this for the OS.

    • 16GB of RAM – leave 4GB since 4 > (16 * 10%)
    • 32GB – leave 4GB since 4 > (32 * 10%)
    • 64GB – leave 6.4GB since (64 * 10%) > 4

    Essentially leave 4GB until you get to 48GB of RAM, then go to 10%.

    References: Mr. Brent Ozar of Brent Ozar, PLF who’s presented and written this a few times, but the reference I’m using is: How to Set SQL Server Max Memory for VMware

    Explanation: In the older x86 days there were all sorts of rules for setting memory for the OS and SQL Server. I won’t go into those, and for the time being we’re working in the x64 world, not x128. For that, you need to be sure the OS isn’t starved by SQL Server and unable to manage the host processes. These days 32GB isn’t expensive, and 4GB gives you a nice cushion at lower levels. At higher ones, you need