Time

How do I manage my time. My employer is not a large enterprise, but they are growing rapidly. The IT department is stretched thin. There’s over 800 “server” classed objects in Active Directory, I personally know of 40 SQL Server servers, 30 of which are “Production”. I probably have over 200 applications that are connected into these SQL Servers. And yet last week and this I found my time torn between trying to get our Monitoring System back operational for the entire infrastructure and pulled into security audits for File Shares and a single application that uses SQL Server to store file locations of engineering CAD drawings. Sure, at my company those files are our IP, our bread-and-butter, our “Family Jewels”, but at the same time we had a major outage for Sharepoint and a system that we sell to our customers. The Sharepoint outage was a SAN volume that filled up from outside into the LUN, and took the LUN offline. The other outage was a LUN running out of space due to a weekly index rebuild filling up a TLOG drive.

Both would have been easily preventable, if I had the time to be proactive and spend two hours on Friday reviewing system health reports. Instead I spent my time fixing SLA reports and internet web status Macros for our Monitoring solution, and then in meetings on how we have 78 logins that are Domain Administrators in our primary domain. Couple that with the report I typed up saying “Yes we can turn on successful and failed login auditing, and set up minimum password requirements for SQL Logins”, and you see why I didn’t have time to ensure the index rebuilds would blow up to take grow the TLOG to 300% of normal size. Just ignore the fact that the IT organization turns deaf, dumb, and mute when someone mentions an SLA, or DR, or BC.

Any suggestions other than “Dice, Monster, Update Resume”?

2 thoughts on “Time

  1. What you should probably do (if you are not doing it already) is to get a SQL Server 2008 Management Studio and use the Registered Servers functionality. It is great for managing multiple instances. From there, you can use the PBM and other T-SQL scripts which you can execute to grouped servers.
    You can get familiar with the BPA (Best Practices Analyzer) and review your servers from time to time.
    Also, set up notifications for the alerts with severity above 17, and make sure you get a message on a pager or email.

    Feodor

Leave a Reply

Your email address will not be published. Required fields are marked *

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.