<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Sylvia Moestl...
»
9 Things to Do When You Inherit a Database
84 posts, Page 1 of 9
1
2
3
4
5
»
»»
9 Things to Do When You Inherit a Database
Rate Topic
Display Mode
Topic Options
Author
Message
Sylvia Moestl Vasilik
Sylvia Moestl Vasilik
Posted Sunday, June 21, 2009 10:20 PM
Grasshopper
Group: General Forum Members
Last Login: Saturday, March 16, 2013 4:03 PM
Points: 14,
Visits: 336
Comments posted to this topic are about the item
9 Things to Do When You Inherit a Database
Post #739165
P Jones
P Jones
Posted Monday, June 22, 2009 2:08 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: 2 days ago @ 7:35 AM
Points: 515,
Visits: 1,016
Run the performance dashboard reports and have a look at long running queries and missing indexes.
Post #739211
John Gregory-458324
John Gregory-458324
Posted Monday, June 22, 2009 3:32 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, November 27, 2012 9:47 AM
Points: 1,
Visits: 14
This is a good check-list - thanks very much.
It sounded like you suggested deliberately causing a problem to get buy-in from your users (...sending out hundreds of thousands of emails). Perhaps I misunderstood this bit. Abusing trust is never a good long-term strategy.
Thanks
J
Post #739228
SuperDBA-207096
SuperDBA-207096
Posted Monday, June 22, 2009 4:51 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Wednesday, January 02, 2013 12:15 PM
Points: 1,443,
Visits: 711
Most of this looks pretty good but this could be a recipe for disaster:
"Drop obsolete objects"
It's sometimes not straightforward how and when objects are used. before dropping something you need to be sure it's really not used.
It's quite possible you could drop a sproc or table thats only used periodically (once a month or once a quarter). This could create major problems for you a few months out!
Just my 02c...
Mark
Post #739276
Michael Garstin-341427
Michael Garstin-341427
Posted Monday, June 22, 2009 5:39 AM
Grasshopper
Group: General Forum Members
Last Login: Wednesday, February 13, 2013 8:52 PM
Points: 20,
Visits: 17
I am stunned that the list does not include "Run CHECKDB" (or at least find out when it last ran).
The free but unsupported RML Utilities released by the Microsoft SQL Server PSS engineers can be used to analyze a Profiler trace. That can tell you what is running and how often.
This would be a good spot to plug Red-Gate's SQL Doc tool (no, I'm not a RG employee!). This might not be free but it is a good way to acquaint yourself with a new database.
Post #739300
TheSQLGuru
TheSQLGuru
Posted Monday, June 22, 2009 6:55 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 11:07 AM
Points: 3,576,
Visits: 5,117
1) I agree with Mark about Drop obsolete objects. It is virtually impossible to find and properly scan all code that might run against any given database that might access a particular object. Just don't go there.
2) I fire up ApexSQL Doc first thing and get it going creating a full blow set of documentation about the database.
3) I check quite a few configuration options such as statistics settings, auto-close/auto-shrink, recovery mode, growth increments, etc.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #739339
stevecurtis3
stevecurtis3
Posted Monday, June 22, 2009 6:58 AM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, July 19, 2011 4:53 AM
Points: 299,
Visits: 56
We never delete anything in one go!!! What we do is change its name by prefixing XXX to its name, and then later delete all the XXX's. As we run a weekly system, we can delete the XXX's for most of our system after a fortnight. For the monthly and quarterly bits, we just wait a bit longer!!!
Rgds,
Steve
Post #739342
TheSQLGuru
TheSQLGuru
Posted Monday, June 22, 2009 7:16 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 11:07 AM
Points: 3,576,
Visits: 5,117
stevecurtis3 (6/22/2009)
We never delete anything in one go!!! What we do is change its name by prefixing XXX to its name, and then later delete all the XXX's. As we run a weekly system, we can delete the XXX's for most of our system after a fortnight. For the monthly and quarterly bits, we just wait a bit longer!!!
Rgds,
Steve
But how can you know that object A is a daily/weekly/monthly/quarterly/yearly/etc object? If this is a database you have no prior knowledge of (heck, even if it is) you run a significant risk IMNSHO.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #739352
rperry
rperry
Posted Monday, June 22, 2009 7:16 AM
SSC Rookie
Group: General Forum Members
Last Login: Monday, November 19, 2012 1:31 PM
Points: 29,
Visits: 108
I like this article a lot...just the right number of topics to get someone started on a newly inherited database (or even someone new to DBA work themselves).
In line with other posters who remark about what's missing from the list, I would suggest they post their own "new DB to-do" lists so everyone can get a diverse view of this topic. Also, I'm putting together my own list called
"Things to Do When You Inherit Replication"
....which brings with it some very specific needs.
Post #739353
mzak
mzak
Posted Monday, June 22, 2009 7:18 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, April 14, 2011 7:04 AM
Points: 20,
Visits: 177
Great list. I would throw in "review security privileges"
Post #739356
« Prev Topic
|
Next Topic »
84 posts, Page 1 of 9
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
