Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

On-Call Duties Expand / Collapse
Author
Message
Posted Monday, October 27, 2008 12:26 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, June 28, 2014 8:14 AM
Points: 89, Visits: 260
Robert Hermsen (10/27/2008)
a benefit to storing the data is that in lieu of alerting on 80-90 % drive utilization you can alert on % changed. It allows you to catch when suddenly your drive with 3% monthly growth suddenly changes to 15 % quickly shortening your window.


completely agree. The customer I am at makes use of Quest's Capacity Manager, so we get a GUI on top of that data, but a homegrown version can be as good (or better, as it can be built into any alerting system, whereas Cap Man is outside the alerting structure we have here - we can't see a referenece to "alert sent" for example).

Whether using Cap Man, or a similar tool, or a home grown tool - the importance of predicting, and then measuring, data growth is often under-estimated.
Post #592339
Posted Monday, October 27, 2008 8:59 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 10, 2014 8:13 AM
Points: 1,278, Visits: 2,204
The duties seem to be DBA routine/regular tasks. It is nice to list them out and have the problems/changes tracked and documented. A very good and detailed list.

Just curious, if the DBA is not on-call, what do they do in your shop? As my experience, on-call is to face and fix whatever problem comes after the business hours.


Post #592591
Posted Tuesday, October 28, 2008 1:55 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, September 11, 2014 4:44 PM
Points: 615, Visits: 443
Vivien Xing (10/27/2008)
The duties seem to be DBA routine/regular tasks. It is nice to list them out and have the problems/changes tracked and documented. A very good and detailed list.

Just curious, if the DBA is not on-call, what do they do in your shop? As my experience, on-call is to face and fix whatever problem comes after the business hours.


at our shop, we have a series of tasks dolled out to each of us. when not on-call, that dba gets to work on projects or tasks that actually matter.



Post #592658
Posted Tuesday, October 28, 2008 10:42 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, October 17, 2014 10:29 AM
Points: 3,214, Visits: 2,343
A pretty good article. However things related are more of day-to-day activates that a DBA performs or has performed by automated tasks.

For going on-call I would suggest something more like some of the task I have to perform to prepare for going on-call:

- reviewing the previous weeks DBA callouts
- reviewing the previous weeks turnover minutes for:
- production support
- backups
- network
- resetting the DBA 'hotline' call forwarding to you phone
- changing your cell phone ringing/paging profiles
- daily changing of your work phone to call-forward to your cell phone during off hours
- for Blackberry users
- changing profiles
- changing mail folders forwarded
- attending daily/weekly turnover meeting
- help desk notification for automated tracking systems




Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #593087
Posted Tuesday, October 28, 2008 11:12 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 16, 2014 4:46 AM
Points: 5,406, Visits: 1,400
Excellent article ...:)


Post #593386
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse