Defrag a partition with a SQL database

Is it problematic at all to defrag a partition conaining a SQL database?You will have to shut down the SQL instance first, otherwise the
defrag software won't touch it.
On Wed, 1 Nov 2006 14:26:03 -0800, CK <CK@.discussions.microsoft.com>
wrote:
>Is it problematic at all to defrag a partition conaining a SQL database?|||"bradsbulkmail@.comcast.net" wrote:
> You will have to shut down the SQL instance first, otherwise the
> defrag software won't touch it.
> On Wed, 1 Nov 2006 14:26:03 -0800, CK <CK@.discussions.microsoft.com>
> wrote:
> >Is it problematic at all to defrag a partition conaining a SQL database?
>
There's a third-party tool, Diskeeper, that allows you to defrag while the
files are online.|||Contig from sysinternals does the trick.
F_clef wrote:
> "bradsbulkmail@.comcast.net" wrote:
>> You will have to shut down the SQL instance first, otherwise the
>> defrag software won't touch it.
>> On Wed, 1 Nov 2006 14:26:03 -0800, CK <CK@.discussions.microsoft.com>
>> wrote:
>> Is it problematic at all to defrag a partition conaining a SQL database?
> There's a third-party tool, Diskeeper, that allows you to defrag while the
> files are online.|||F_clef wrote:
> "bradsbulkmail@.comcast.net" wrote:
>> You will have to shut down the SQL instance first, otherwise the
>> defrag software won't touch it.
>> On Wed, 1 Nov 2006 14:26:03 -0800, CK <CK@.discussions.microsoft.com>
>> wrote:
>> Is it problematic at all to defrag a partition conaining a SQL database?
> There's a third-party tool, Diskeeper, that allows you to defrag while the
> files are online.
The very thought scares the bejeezus out of me. The notion that
something is moving chunks of my database file around WHILE SQL Server
is moving data pages around just seems EXTREMELY risky to me...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||> The very thought scares the bejeezus out of me. The notion that something is moving chunks of my
> database file around WHILE SQL Server is moving data pages around just seems EXTREMELY risky to
> me...
I agree. The defrag tool vendors can claim as much as they want that this is OK. I just wouldn't do
it. Defragging file system should very rarely be necessary unless one misuse autogrow and shrink, so
for these rare occasions, I'd definitely would stop SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:454A30E0.3020609@.realsqlguy.com...
> F_clef wrote:
>> "bradsbulkmail@.comcast.net" wrote:
>> You will have to shut down the SQL instance first, otherwise the
>> defrag software won't touch it.
>> On Wed, 1 Nov 2006 14:26:03 -0800, CK <CK@.discussions.microsoft.com>
>> wrote:
>> Is it problematic at all to defrag a partition conaining a SQL database?
>> There's a third-party tool, Diskeeper, that allows you to defrag while the files are online.
> The very thought scares the bejeezus out of me. The notion that something is moving chunks of my
> database file around WHILE SQL Server is moving data pages around just seems EXTREMELY risky to
> me...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||What is Microsoft's official support position on the use of 'on-line'
defrag tools (specifically diskeeper). If the database corrupts and this
tool is running, Would microsoft invalidate the support agreement?
thanks
Andrew
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uPMRA3q$GHA.4604@.TK2MSFTNGP02.phx.gbl...
>> The very thought scares the bejeezus out of me. The notion that something
>> is moving chunks of my database file around WHILE SQL Server is moving
>> data pages around just seems EXTREMELY risky to me...
>
> I agree. The defrag tool vendors can claim as much as they want that this
> is OK. I just wouldn't do it. Defragging file system should very rarely be
> necessary unless one misuse autogrow and shrink, so for these rare
> occasions, I'd definitely would stop SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:454A30E0.3020609@.realsqlguy.com...
>> F_clef wrote:
>> "bradsbulkmail@.comcast.net" wrote:
>> You will have to shut down the SQL instance first, otherwise the
>> defrag software won't touch it.
>> On Wed, 1 Nov 2006 14:26:03 -0800, CK <CK@.discussions.microsoft.com>
>> wrote:
>> Is it problematic at all to defrag a partition conaining a SQL
>> database?
>> There's a third-party tool, Diskeeper, that allows you to defrag while
>> the files are online.
>> The very thought scares the bejeezus out of me. The notion that
>> something is moving chunks of my database file around WHILE SQL Server is
>> moving data pages around just seems EXTREMELY risky to me...
>>
>> --
>> Tracy McKibben
>> MCDBA
>> http://www.realsqlguy.com
>|||U guys are too paranoid. Live a little... that's why we have backups!
"Tibor Karaszi" wrote:
> > The very thought scares the bejeezus out of me. The notion that something is moving chunks of my
> > database file around WHILE SQL Server is moving data pages around just seems EXTREMELY risky to
> > me...
>
> I agree. The defrag tool vendors can claim as much as they want that this is OK. I just wouldn't do
> it. Defragging file system should very rarely be necessary unless one misuse autogrow and shrink, so
> for these rare occasions, I'd definitely would stop SQL Server.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message news:454A30E0.3020609@.realsqlguy.com...
> > F_clef wrote:
> >>
> >> "bradsbulkmail@.comcast.net" wrote:
> >>
> >> You will have to shut down the SQL instance first, otherwise the
> >> defrag software won't touch it.
> >>
> >> On Wed, 1 Nov 2006 14:26:03 -0800, CK <CK@.discussions.microsoft.com>
> >> wrote:
> >>
> >> Is it problematic at all to defrag a partition conaining a SQL database?
> >>
> >> There's a third-party tool, Diskeeper, that allows you to defrag while the files are online.
> >
> > The very thought scares the bejeezus out of me. The notion that something is moving chunks of my
> > database file around WHILE SQL Server is moving data pages around just seems EXTREMELY risky to
> > me...
> >
> >
> >
> > --
> > Tracy McKibben
> > MCDBA
> > http://www.realsqlguy.com
>|||F_clef wrote:
> U guys are too paranoid. Live a little... that's why we have backups!
>
Explain that to our thousands of users around the world, when our 240GB
database gets eaten by DisKeeper and we're down for 4 hours...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:455B5770.5060504@.realsqlguy.com...
> F_clef wrote:
>> U guys are too paranoid. Live a little... that's why we have backups!
> Explain that to our thousands of users around the world, when our 240GB
> database gets eaten by DisKeeper and we're down for 4 hours...
I was going to say. Backups are great... but we're a 24x7 shop.
Experimentation is discouraged. :-)
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||The defrag vendors will say they use Microsoft APIs and there can't be
corruption. Personally, I use PerfectDisk from Raxco Software and have
never had a problem with SQL servers...who knows, maybe I'm just lucky,
but I know MS engineers also use the product. But I can certainly
understand the hesitancy...:)
Greg D. Moore (Strider) wrote:
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:455B5770.5060504@.realsqlguy.com...
> > F_clef wrote:
> >> U guys are too paranoid. Live a little... that's why we have backups!
> >>
> >
> > Explain that to our thousands of users around the world, when our 240GB
> > database gets eaten by DisKeeper and we're down for 4 hours...
> I was going to say. Backups are great... but we're a 24x7 shop.
> Experimentation is discouraged. :-)
>
> >
> >
> > --
> > Tracy McKibben
> > MCDBA
> > http://www.realsqlguy.com|||The defrag vendors will say they use Microsoft APIs and there can't be
corruption. Personally, I use PerfectDisk from Raxco Software and have
never had a problem with SQL servers...who knows, maybe I'm just lucky,
but I know MS engineers also use the product. But I can certainly
understand the hesitancy...:)
Greg D. Moore (Strider) wrote:
> "Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
> news:455B5770.5060504@.realsqlguy.com...
> > F_clef wrote:
> >> U guys are too paranoid. Live a little... that's why we have backups!
> >>
> >
> > Explain that to our thousands of users around the world, when our 240GB
> > database gets eaten by DisKeeper and we're down for 4 hours...
> I was going to say. Backups are great... but we're a 24x7 shop.
> Experimentation is discouraged. :-)
>
> >
> >
> > --
> > Tracy McKibben
> > MCDBA
> > http://www.realsqlguy.com