SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The DBA Routine


The DBA Routine

Author
Message
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11461 Visits: 2730
Comments posted to this topic are about the item The DBA Routine

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Simon Gladwell
Simon Gladwell
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 40
Useful seeing it listed out like that.

#10 - Whack a Mole. I Like to do something similar but add to the equation total time of queries. Saving 2 seconds off a 3 second query that runs a thousand times a day is better than 10 seconds off a 15 second query that runs only two or three times a day.
Andy Warren
Andy Warren
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: Moderators
Points: 11461 Visits: 2730
I agree with that, but wanted to keep it simple. In my view its more important to adopt the philosophy of spending some time on performance each week than to use a specific implementation. I suspect that using your system or mine in a year we'd have systems that ran substantially smoother!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
SuperDBA-207096
SuperDBA-207096
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1927 Visits: 711
Andy,
What a great post! It pretty much outlines how I spend my day when working as a DBA....

Mark
Marc Bujold
Marc Bujold
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 54
My first time posting but I really loved the article.
Jack Corbett
  Jack Corbett
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18380 Visits: 14893
Good article and it definitely provides a way to find out if you are doing what needs to be done.

As far as #10, how do you deal with a situation where the application is a 3rd party app and you can't make performance improvements?



Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming
At best you can say that one job may be more secure than another, but total job security is an illusion. -- Rod at work

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Simon Gladwell
Simon Gladwell
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 40
As far as #10, how do you deal with a situation where the application is a 3rd party app and you can't make performance improvements?

You have evidence to give to the developers. Any decent developer would be quite happy to have that level of information returned and file it under "Constructive criticism".
Rick Lang
Rick Lang
SSC Journeyman
SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)SSC Journeyman (88 reputation)

Group: General Forum Members
Points: 88 Visits: 142
I agree that this is a great article. However, I'd like a little help. About a year ago, my school district told me congratulations, your the new SQL guy. So I delved deeply into Sql Development and am ok, not great at that. As I've read postings on this site, I've realized there's a whole world on the DBA side I've been neglecting. This brings me to my help request.

I need a little more on the "how" of this article. For instance, #10, I looked into the profiler and found trace templates, but I'm not sure which ones contain the data points discussed. Similarly, # 6. Is there a good beginning DB tuning/monitoring site or book that somebody could recommend that would help me get started? Regrettably, at this stage I need some "Click File>Open>Trace...." level help.

Thanks
Rick
Carlos E Souza Lopes
Carlos E Souza Lopes
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 43
Good post, especially for me - I'm the backup of the DBA when he is not around, really a developer that happens to know enough to be a shoe in to the DBA once in a full moon.

It would be helpful to me to see some sources of "all the published 'best practices' we hear so much about". Would you care to recommend books, articles or even training that will focus on those?

Thanks!
Simon Gladwell
Simon Gladwell
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 40

I need a little more on the "how" of this article. For instance, #10, I looked into the profiler and found trace templates, but I'm not sure which ones contain the data points discussed.

Try http://www.sql-server-performance.com/articles/per/performance_audit_part8_p1.aspx as a start or there is probably a few articles here.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search