Monday Monitor Tips: Projecting Disk Space

Posted on October 28, 2024 by way0utwest

One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are a constant problem, but it’s easy to run out of space on other systems.

Redgate Monitor will alert you to low space, but do you want to keep asking SAN admins for more space every week as new systems run out of space? Or do you want to project a number for the year and get that budgeted? Learn how Redgate Monitor can help

This is part of a series of posts on Redgate Monitor. Click to see the other posts

An Estate View of Storage

The estate view of disk usage shows all your disks totaled up and the projections for growth. This looks like the image below on monitor.red-gate.com. This doesn’t seem useful, but I’ve had storage admins come to me in the past asking about budgeting for the next year. How much space will I use?

2024-09_0139

The answer is often I don’t know. I’d have to take a very wild guess for them. Now, I’d use this, and maybe pad it slightly, but across lots of systems, we can probably guess on the growth that will be needed. Any one system might not be predictable, but across lots, averages work out.

Here I can see we’re using 25TB (out of 87TB). Definitely be careful showing this to storage admins, as they often want those to be closer, ubt I can see I’m projected to use 91TB in a year, so I’d need more space. The graph above shows me running out of space in Sept/Oct of 2025.

Below this I see details from machines and their disks. These show in the same groups I see on other screens. While I can’t easily filter here, I can search from a browser, or export this information. That’s useful for checking on individual systems.

2024-09_0149

The other nice thing is I can sort the columns, and if I do this by time until full, I can see the disks that might give me problems soon.

2024-09_0154

None of the test systems are likely to be problematic soon, but certainly someone needs to budget for next year.

Summary

This is a simple screen, but one that I wish I’d have had in the past. It gives me a lot of information that I rarely need, but information that always requires a lot of effort to compile. What disks are being used by my database servers and what percentage of space is in use.

In a DBA team, this is the type of data I’d want to glance at every quarter and then make adjustments to prevents issues. Proactive DBAs want a screen just like this.

Redgate Monitor is a world class monitoring solution for your database estate. Download a trial today and see how it can help you manage your estate more efficiently.

Posted in Blog | Tagged , , , | Comments Off on Monday Monitor Tips: Projecting Disk Space

Databases for Executives

Posted on October 28, 2024 by way0utwest

There’s an article at Forbes about the Five Things Business Leaders Should Know about Databases. Disclosure, it’s by my boss, but I think it’s still a good read. These are points we’ve learned from research and work with customers and prospects at Redgate Software. These points come from you, as well as from executives with whom we work, but there are so many people in organizations who don’t think about the complexity of data, so it’s a good one to pass along.

The five things are (if you don’t want to read): data is growing, getting more complex, there are multiple database platforms in most estates, teams struggle (duh), and data is a business issue. Most of us know about the fourth one, often because we may feel overloaded with work. We might also feel a lot of stress in trying to keep up with not only the workload but also trying to learn more to support the ever-growing variety of systems it seems our employer wants to put into production. I regularly talk with customers whose developers keep wanting to try out a new, shiny database platform in the cloud (or add new features from their existing platforms).

Wait, not try out. They’ve already deployed some production data there and now want other developers or operations people to work with their system.  Often lots of the staff isn’t familiar with the platform or feature, even the people who decided to implement it. Is anyone familiar with that situation?

The digital transformation and importance of software isn’t lost on most executives, but I find far too many that don’t place the same importance on the data that powers their software or the database platforms that support all software. Data is important, and ensuring it is available to software, protected, secured, and available is critical. That also means that the process of developing and managing the database portion of your software matters.

I think Database DevOps is important, but it’s not a panacea to buy a product. I’d love to show you what Redgate Software can do here, but the main thing I stress to clients is that you need to get your database development into the modern era and match what software developers do. That means a smooth process, with version control, that ensures you deploy changes in a way that doesn’t impact customers.

This doesn’t mean just go faster. This means bringing along data modeling, good architecture, and performance testing. Those are the same things we’ve been doing (or should have been doing) for decades, but we need to ensure these are still a part of whatever process we choose and included in any automation we implement.

Pass the article along to your management, and be sure they understand that all these points are important. Particularly the fourth point because if your staff isn’t supported and trained, the rest of the business will suffer.

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Note, podcasts are only available for a limited time online.

Posted in Editorial | Tagged | Comments Off on Databases for Executives

Knowing Your Total Reward

Posted on October 25, 2024 by way0utwest

For much of my career as a younger person, I was mostly concerned with salary at a job, along with the opportunities for my career. I really wanted to know how much money would hit my bank account and cared most about that. I also wanted to know if I would learn something or get a better title or work with a technology that might help me in the future. That drove me through quite a few jobs in my 20s and 30s, leaving some for more money and more opportunity.

As I got a family, I became more concerned about healthcare since that industry is a mess in the US. Often when I looked at a job, I perused other benefits but didn’t give them much weight, mostly concerned with salary and the cost of medical insurance. I also somewhat cared about who I worked with (the team), but that was more for helping me choose between different jobs. It wasn’t something I thought of as a reward, though I should have.

Recently one of our internal recruiters shared a post on LinkedIn talking about total reward. This was from an HR company, but I really liked the idea of total reward. There’s not a lot to the post, but it noted that many HR and management think total rewards for employees are salary + benefits. It highlights that there is more, which includes all compensation (competitive + performance-based), work-life integration, career opportunities, supportive culture, and human-centric policies. There’s a graphic that highlights this idea.

Early in the SQL Server Central days, Andy and I were talking about his job search and how he viewed the entire package. He cared about other things, often looking at certification or education compensation, time off, commute, and more. Some of those things were important to me, but they often were nice-to-haves next to the salary. The total compensation made more sense for him to evaluate, as employers sometimes have very different policies. He tried to put a monetary value on each benefit to compare them. He had one company that paid him for each certification he got, which added up to quite a bit of money on top of his salary when he got certified in most of the Office products.

Today I’m wondering if some of you think about your total reward from employment. Do you weigh in the different types of benefits you get? Can you put some value on a particular policy your employer offers? As an example, I made this choice years ago when a company in Denver offered me a fair salary and position. However, they were unwilling to let me work at home more than one day a week. At the time I had young children and I would lose 90 minutes every day to a commute. I countered with $15k less salary each year and 3 days of work at home. They declined and we went our separate ways. I was very happy with that decision, as my time had real value to me.

These days I think about the total compensation I get, with a lot of flexibility and autonomy, on top of interesting work and good compensation. I also think about stability and security, which are important to me since I really, really don’t ever want to have to look for another job.

We should work to live our lives, and understand that while work is important and provides purpose, it’s a part of our life. We spend a lot of time in our jobs, so we should ensure our total rewards are a fair trade for our time.

Steve Jones

Listen to the podcast at Libsyn, Spotify, or iTunes.

Note, podcasts are only available for a limited time online.

Posted in Editorial | Tagged | Comments Off on Knowing Your Total Reward

A New Word: Feresy

Posted on October 25, 2024 by way0utwest

feresy – n.  the fear that your partner is changing in ways you don’t understand, even though they might be changes for the better, because it forces you to wonder whether your relationship needs a few careful nudges to fall back into balance, or perhaps is still as stable as ever, but involves a person who no longer exists.

I used to experience feresy, worried that my wife, or even I, were changing in ways that might make us move further apart. Over time, I’ve learned that we both will change, and we have to accept the other will grow and change. They aren’t the same person we married, nor are they someone we can force to change in the way we want.

However, if there is a balance adjustment needed, we both know we need to communicate to ensure that we maintain a strong partnership. 

I don’t fear my wife not being the person she was because that person no longer exists.

From the Dictionary of Obscure Sorrows

Posted in Blog | Tagged , | Comments Off on A New Word: Feresy