You have more options than just the DBA. I’ve put a few into this sheet that you can print out and hang in your cubicle, or on bulletin boards in the office, or on telephone poles…and I already took one for myself. You can have the rest. Enjoy!
You’re transaction log files are a mess. You don’t think so, but it’s true. Too many times I have seen transaction logs treated without care; they are placed on the same disk drives as the data files or they are placed on drives not optimized for write activity. I have even seen admins who fail … Read more
I wanted to take a moment to point out this VMWare KB article I came across recently. I really do love how the KB article points out the need for accurate disk configurations. I often see misconfigured disks resulting in a performance bottleneck for a virtualized environment. So that part of the KB was great for me to see … Read more
You have no idea that what you are not doing is causing you pain. Then again, how could you know this? I mean, if you are not doing it, why would you ever think that your inaction could be the very thing that is causing you heartache every time your phone rings in the middle … Read more
No matter what our profession, we all have our favorite set of tools to help us get the job done. Database Administrators will have a set of scripts that we use in order to gain insight into the server instances under our care. I often see beginner DBAs look to the counters provided by Perfmon (AKA, the Resource and … Read more
As a system admin, DBA, or a developer it is our job to root out performance problems quickly. The trouble is that there are so many things that can cause performance issues it can be difficult to know every possible root cause. This is especially true when the root cause lies somewhere outside your area … Read more
