| Author |
Defrag a partition with a SQL database
|
|
|
| Is it problematic at all to defrag a partition conaining a SQL database?
| |
| bradsbulkmail@comcast.net 2006-11-02, 12:12 am |
| 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?
| |
| F_clef 2006-11-02, 7:12 pm |
|
" bradsbulkmail@comcas
t.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:
>
>
There's a third-party tool, Diskeeper, that allows you to defrag while the
files are online.
| |
| Theo Verweij 2006-11-02, 7:12 pm |
| Contig from sysinternals does the trick.
F_clef wrote:
>
> " bradsbulkmail@comcas
t.net" wrote:
>
>
> There's a third-party tool, Diskeeper, that allows you to defrag while the
> files are online.
| |
| Tracy McKibben 2006-11-02, 7:12 pm |
| F_clef wrote:
>
> " bradsbulkmail@comcas
t.net" wrote:
>
>
> 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
| |
| Tibor Karaszi 2006-11-02, 7:12 pm |
| > 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:
>
> 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
| |
| Andrew Brooks 2006-11-07, 7:12 pm |
| 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@hotmai
l.nomail.com> wrote in
message news:uPMRA3q$GHA.4604@TK2MSFTNGP02.phx.gbl...
>
>
> 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 2006-11-15, 7:14 pm |
| U guys are too paranoid. Live a little... that's why we have backups!
"Tibor Karaszi" wrote:
>
>
> 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...
>
>
| |
| Tracy McKibben 2006-11-15, 7:14 pm |
| 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
| |
| Greg D. Moore \(Strider\) 2006-11-16, 12:16 am |
|
"Tracy McKibben" <tracy@realsqlguy.com> wrote in message
news:455B5770.5060504@realsqlguy.com...
> F_clef wrote:
>
> 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
| |
| jsnapper2@gmail.com 2006-11-16, 7:12 pm |
| 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:[color=darkred
]
> "Tracy McKibben" <tracy@realsqlguy.com> wrote in message
> news:455B5770.5060504@realsqlguy.com...
>
> I was going to say. Backups are great... but we're a 24x7 shop.
> Experimentation is discouraged. :-)
>
>
| |
| jsnapper2@gmail.com 2006-11-16, 7:12 pm |
| 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:[color=darkred
]
> "Tracy McKibben" <tracy@realsqlguy.com> wrote in message
> news:455B5770.5060504@realsqlguy.com...
>
> I was going to say. Backups are great... but we're a 24x7 shop.
> Experimentation is discouraged. :-)
>
>
|
|
|
|