http://www.sqlservercentral.com/blogs/sql_awesomesauce/2012/06/21/live-note-taking-seans-ncc-1701-dba-part-2/

Printed 2014/12/18 10:25AM

Live note-taking: Sean’s NCC-1701-DBA part 2

2012/06/21

Note that THIS talk, and a ton more, is the subject of Sean’s  precon at SQL Saturday #163 Dallas this fall.

We can’t really livecast Sean’s session, so I’ll live note-take.

Tonight’s session is on being able to answer questions before they’re asked.

Intro

Powershell

Growth Projection SP

Enterprise! (Make end user reports)

Q: You could fold in department names and business units for chargebacks!
A: Yep.

Caveat: be aware that users WILL misread your report, no matter how pretty it is.

What else can you do with the growth projection?

Q: Do you have a “before you bother me” list?
A: Yeah! Acutally I put a link to the report in the ticket.

Side note: ReplicationLatency DBA Report

This clearly has a separate collector, not yet shown.

Q: What kind of interval do you collect on for someting like this?
A: It depends on the importance of the application. For my gold boxes, I do once per minute – granularity is important. For other boxes, usually 5 minutes.

What else are these reports good for?

Server Role Members Report

More POSH scripts

Conclusion

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit

Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.