Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Fix the Little Things


Fix the Little Things

Author
Message
w.durkin@online.de
w.durkin@online.de
SSC-Addicted
SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)

Group: General Forum Members
Points: 463 Visits: 1879
[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 Wink

p.s I don't work for Redgate, I just love their products BigGrin

Regards

GermanDBA

Regards,

WilliamD
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47388 Visits: 44399
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, MVP, M.Sc (Comp Sci)
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


w.durkin@online.de
w.durkin@online.de
SSC-Addicted
SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)SSC-Addicted (463 reputation)

Group: General Forum Members
Points: 463 Visits: 1879
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! Wink

Regards,

WilliamD
Eric M Russell
Eric M Russell
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4647 Visits: 9579
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.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
thisisfutile
thisisfutile
SSC Veteran
SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)SSC Veteran (207 reputation)

Group: General Forum Members
Points: 207 Visits: 973
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.
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8391 Visits: 6166
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!!!
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)SSCrazy Eights (8.4K reputation)

Group: General Forum Members
Points: 8391 Visits: 6166
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!!!
buddy__a
buddy__a
Old Hand
Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)Old Hand (330 reputation)

Group: General Forum Members
Points: 330 Visits: 257
Me too and the link to the Finding Fragmentation article results in a FeedBurner 404 Error.



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