<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
»
SQLServerCentral.com
»
Editorials
»
Fix the Little Things
18 posts, Page 2 of 2
««
1
2
Fix the Little Things
Rate Topic
Display Mode
Topic Options
Author
Message
WilliamD-
WilliamD-
Posted Friday, November 14, 2008 3:15 AM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 12:34 AM
Points: 449,
Visits: 1,772
[b]
Database X has not been backed up in 167 days.
Database Y is in full recovery model but has no log backups. Log drive will fill up in approximately 24.2 minutes at current rate of growth.
Database Z has been shrunk 42 times in the last week and has grown 178 times in the same period. A defragment of indexes and drive is recommended
CheckDB has not been run on Database K in 127 days
... etc, etc...
Hi Gail,
I'm not sure If I read the details incorrectly, but the new policy manager for SQL 2008 should supply just this. You setup the policies it should check on, and you can get a report over the policies that are not being followed.
Another sure bet would be SQLresponse from Redgate. It has a bunch of recommendations based on exactly what you mentioned - you were beaten to the punch on that ;)
p.s I don't work for Redgate, I just love their products :D
Regards
GermanDBA
Regards,
WilliamD
Post #602601
GilaMonster
GilaMonster
Posted Friday, November 14, 2008 8:40 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 10:47 AM
Points: 37,728,
Visits: 29,990
GermanDBA (11/14/2008)
[quote][b]
I'm not sure If I read the details incorrectly, but the new policy manager for SQL 2008 should supply just this. You setup the policies it should check on, and you can get a report over the policies that are not being followed.
The policies work, but only if the admin knows enough to setup and enable policies. If the person titled DBA doesn't know enough to do backups, what's the chance he's going to put policies in place or buy a 3rd party tool?
I'm talking about something for the situation where the person fulfilling the DBA role is completely clueless about what needs doing.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #602836
WilliamD-
WilliamD-
Posted Monday, November 17, 2008 1:05 AM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 12:34 AM
Points: 449,
Visits: 1,772
Hi Gail,
I get what you mean. But then again, where does it stop? At some point the person responsible has to have some knowledge of the system he/she has been burdoned with.
There are plenty of accidental DBAs, but would you want them to act blindly on suggestions from the SQL server? You said yourself that someone you knew brought down a production server by doing something that was "too easy".
Some things should not be dumbed down, otherwise I would be out of a job! ;)
Regards,
WilliamD
Post #603499
Eric M Russell
Eric M Russell
Posted Thursday, February 21, 2013 7:01 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 1:53 PM
Points: 1,164,
Visits: 3,335
But I'm somewhat amazed how many fragmentation questions, posts, articles, and more that I still see on a regular basis. Shouldn't this be a low level feature of SQL Server that just works? In 2008, or I guess SQL 11 now, should there be any reason for a DBA to monitor this and write custom code to ensure that it's fixed on a regular basis? Should this not be something built into the system?
It's sounds like what we need is something like an 'AUTO REORGANIZE INDEXES' database setting, and then something similar to the Lazy Writer process that sits in the background and performs online incremental reorganization of index pages (a handful at a time) during periods of relatively low resource utilization.
"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47
Post #1422563
thisisfutile
thisisfutile
Posted Thursday, February 21, 2013 8:41 AM
Valued Member
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:15 AM
Points: 56,
Visits: 487
Steve, FYI...
Not sure if this is me or the email but I clicked the "Join the discussion" link in the email this morning but was brought to following page:
http://www.sqlservercentral.com/FindForumThread/97198
Link in the email was:
http://www.sqlservercentral.com/links/746380/293894
I had to search the forums for "Fix the little things" to find this thread.
Post #1422637
Gary Varga
Gary Varga
Posted Thursday, February 21, 2013 8:53 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 3,540,
Visits: 1,128
thisisfutile (2/21/2013)
Steve, FYI...
Not sure if this is me or the email but I clicked the "Join the discussion" link in the email this morning but was brought to following page:
http://www.sqlservercentral.com/FindForumThread/97198
Link in the email was:
http://www.sqlservercentral.com/links/746380/293894
I had to search the forums for "Fix the little things" to find this thread.
Me too.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1422651
Gary Varga
Gary Varga
Posted Thursday, February 21, 2013 8:56 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 3,540,
Visits: 1,128
It this not like the backup plan or growth settings that should be configured to a reasonable default out of the box? Of course for large implementations which require careful planning and DBA support these things will be turned off or, at the very least, reconfigured by the expert DBA.
Perhaps this is akin to disk defragging in Windows which, if the grey cells are working, initially was via third party tools then a built in tool and now occurs continually behind the scenes.
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1422652
buddy__a
buddy__a
Posted Thursday, February 21, 2013 9:21 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 1:33 PM
Points: 304,
Visits: 167
Me too and the link to the Finding Fragmentation article results in a FeedBurner 404 Error.
Post #1422671
« Prev Topic
|
Next Topic »
18 posts, Page 2 of 2
««
1
2
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.
