Voice of the DBA

Tag: syndicated

  • Database Search in SQL Monitor

    I learned something new recently. I can search in SQL Monitor for a database name, not just a server or instance name.

    I tested this over at monitor.red-gate.com recently after a developer mentioned this feature. If you look at the Global Dashboard, there are a lot of machines. You can see 28 instances monitored, but many more databases.

    2022-07-12 09_20_30-Global Dashboard — Mozilla Firefox

    If I were looking for the DatabaseWeekly database, I would need to know which instance this was hosted on. I do know, but someone in our IT support org might not.

    However, if they start typing in the search box at the, the instances shrink. This is the top left box that has “Filter by name” in light text. If I type “database”, you can see fewer instances.

    2022-07-12 09_22_07-Global Dashboard — Mozilla Firefox

    If I add the weekly, then you see there is a cluster of two machines that have this database.

    2022-07-12 09_22_17-Global Dashboard — Mozilla Firefox

    If I pick one of these machines, I can see the databases with this name listed.

    2022-07-12 09_25_56-ssc-db-n1_(local) - Server Overview — Mozilla Firefox

    A handy little feature I knew nothing about.

    Give this a try if you have SQL Monitor and save even more time digging into performance issues. If you don’t have SQL Monitor, download an eval today and give it a try.

  • Daily Coping 18 Jul 2022

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

    Today’s tip is to shift your mood by doing something you really enjoy.

    A different type of tip for a Monday. Usually Friday is when you might aim to do something fun for the weekend. However, let’s shake things up on Monday.

    What do I really enjoy? Time with my wife and kids, coaching, yoga, and snowboarding. July in Colorado takes the last one out, but I do enjoy getting outside anyway. For this Monday, I’m going to schedule yoga for the evening.

    I do yoga regularly, but I’ve been practicing in the mornings almost exclusively the last few months. There is a great teacher that I enjoy, and I’m scheduling a Monday night to change up my routine and enjoy time with a person that makes me happy.

  • Daily Coping 15 Jul 2022

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

    Today’s tip is to add to your list of joys (or make one).

    I wrote about making a list of joys a few weeks ago. I added this tip in the list at that time. If you didn’t make a list, do that now.

    I’m adding a new one to my list. My wife and I are going to the Winter Park Jazz Festival this weekend. We’ll stay up in the mountains for a few days and enjoy listening to music and relaxing. It will be a little drive back and forth from our place up there, but we get to chill in our own, comfortable space, so it’s worth it.

    Getting away with my wife is a new item for my list of joys.

  • Daily Coping 14 Jul 2022

    I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips are under this tag.

    Today’s tip is to pause, breathe, feel your feet firmly on the ground.

    It’s been a couple hectic weeks. Despite getting the basics right more often, stress has been a little higher and there are a lot of things to tackle around the ranch.

    This is a good reminder to stop, take a break, and breathe.

    Yoga has been great for this, as well as remembering to ground myself. I do that physically, but it also helps my spirit.