SQL Clone
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
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1073 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 Guru
SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)

Group: General Forum Members
Points: 222149 Visits: 46285
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
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1073 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
One Orange Chip
One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)One Orange Chip (28K reputation)

Group: General Forum Members
Points: 28776 Visits: 11495
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
Say Hey Kid
Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)Say Hey Kid (705 reputation)

Group: General Forum Members
Points: 705 Visits: 1005
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
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27091 Visits: 6544
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
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27091 Visits: 6544
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
Right there with Babe
Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)Right there with Babe (722 reputation)

Group: General Forum Members
Points: 722 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