defrag SQLServer

Hi All,
Is it safe to defrag SQL server? What's the best utility for this if any?
thanks,
joel"Joel Gacosta" <joel@.bluemediacomm.com> wrote in message
news:#J#AnMWpDHA.3612@.TK2MSFTNGP11.phx.gbl...
> Is it safe to defrag SQL server? What's the best utility for this if any?
>
If you are running a file level defragmenter, then you should have no
issues. If the disk is severely fragmented then the first time it's run, it
would not be a bad idea to stop the MSSQLServer service as this would close
the open database files and allow them to be de-fragmented. As far as
products, we use Diskkeeper on all of our servers, no issues with this
product...
Steve|||Hi Joel
Take a look at this whitepaper which contains almost everything you'll ever
need to know about SQL Server fragmentation:
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/maintain/optimize/ss2kidbp.asp
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Joel Gacosta" <joel@.bluemediacomm.com> wrote in message
news:#J#AnMWpDHA.3612@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> Is it safe to defrag SQL server? What's the best utility for this if any?
> thanks,
> joel
>|||There is nothing called Defragmenting SQL Server.
I think you are asking about DeFragmenting SQL Server
Database objects. If so,then "YES".
As part of database maintenance to improve performance,
you have to regularly DEFRAGMENT the Fragmented objects.
Table fragmentation occurs through the process of data
modifications (INSERT, UPDATE, and DELETE statements) made
against the table. Because these modifications are not
usually distributed equally among the rows of the table,
the fullness of each page can vary over time.
"DBCC SHOWCONTIG" , Displays fragmentation information for
the data and indexes of the specified table.
When an index is heavily fragmented, there are two choices
for reducing fragmentation:
1. Drop and re-create a clustered index.
2. You can defragment the indexes using "DBCC INDEXDEFRAG"
Also,If you want to shrink the databases, you can do using
SQL Server maintenance plans or in the database options.
Hope this helps.
-SQLVarad(MCDBA-1999,MCSE-1999)
>--Original Message--
>Hi All,
>Is it safe to defrag SQL server? What's the best utility
for this if any?
>thanks,
>joel
>.
>|||Some of what SQLVarad said below is incorrect.
> As part of database maintenance to improve performance,
> you have to regularly DEFRAGMENT the Fragmented objects.
You should only defragment indexes if you have empirical evidence that
increasing fragmentation is causing decreasing performance.
> When an index is heavily fragmented, there are two choices
> for reducing fragmentation:
> 1. Drop and re-create a clustered index.
> 2. You can defragment the indexes using "DBCC INDEXDEFRAG"
To reduce fragmentation in an index (clustered or non-clustered) there are 3
options:
1) run DBCC INDEXDEFRAG
2) run DBCC DBREINDEX
3) manually drop and re-create the index
3) is just a manual version of 2). Read the whitepaper Kalen referenced for
a description of these and when to use them.
Regards,
Paul.
--
Paul Randal
DBCC Technical Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"SQLVarad" <SQLVarad@.hotmail.com> wrote in message
news:040e01c3a568$665b09d0$a101280a@.phx.gbl...
> There is nothing called Defragmenting SQL Server.
> I think you are asking about DeFragmenting SQL Server
> Database objects. If so,then "YES".
> As part of database maintenance to improve performance,
> you have to regularly DEFRAGMENT the Fragmented objects.
> Table fragmentation occurs through the process of data
> modifications (INSERT, UPDATE, and DELETE statements) made
> against the table. Because these modifications are not
> usually distributed equally among the rows of the table,
> the fullness of each page can vary over time.
> "DBCC SHOWCONTIG" , Displays fragmentation information for
> the data and indexes of the specified table.
> When an index is heavily fragmented, there are two choices
> for reducing fragmentation:
> 1. Drop and re-create a clustered index.
> 2. You can defragment the indexes using "DBCC INDEXDEFRAG"
> Also,If you want to shrink the databases, you can do using
> SQL Server maintenance plans or in the database options.
> Hope this helps.
> -SQLVarad(MCDBA-1999,MCSE-1999)
> >--Original Message--
> >Hi All,
> >
> >Is it safe to defrag SQL server? What's the best utility
> for this if any?
> >
> >thanks,
> >joel
> >
> >.
> >

Defrag on SQL Server.....

I am periodically getting the complaints that SQL Server is slow. As a
performance improvements I decided to run the defrag utility. Never run on
this server from years. How to know that defrag need to be run? How to prove
there is an excessive physical file fragmentation on a Windows 2K?
SQL 2K with SP3 and Windows 2K with latest SP.
Thank you,
Larry
Larry,
Check out:
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
HTH
Jerry
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to
> prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>
|||If you refer to the file system, you wouldn't need defrag if you stay away from constantly growing
and shrinking the database files. Keep them at a stable size and increase the size only when needed.
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>
|||I saw your postings about defragging indexes and wondered if anyone
would be willing to help me out. I work for a software house that has
developed database defragmentation software for SQL Server, and we are
looking for beta-testers with DBA knowledge of SQL Server and an
awareness of fragmentation. Our software can defrag selected indexes on
a chosen table, one after the other, and has scheduling facilities
built in.
If anyone is interested in beta-testing it, I would like to hear from
you as it is close to launch. My company is willing to offer a free
copy of the software to anyone who can provide genuine and useful
feedback. Please post back if you are interested!
Regards,
Martin
Larry Smith wrote:
> I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry

Defrag on SQL Server.....

I am periodically getting the complaints that SQL Server is slow. As a
performance improvements I decided to run the defrag utility. Never run on
this server from years. How to know that defrag need to be run? How to prove
there is an excessive physical file fragmentation on a Windows 2K?
SQL 2K with SP3 and Windows 2K with latest SP.
Thank you,
LarryLarry,
Check out:
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
HTH
Jerry
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to
> prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||If you refer to the file system, you wouldn't need defrag if you stay away f
rom constantly growing
and shrinking the database files. Keep them at a stable size and increase th
e size only when needed.
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to pro
ve
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||I saw your postings about defragging indexes and wondered if anyone
would be willing to help me out. I work for a software house that has
developed database defragmentation software for SQL Server, and we are
looking for beta-testers with DBA knowledge of SQL Server and an
awareness of fragmentation. Our software can defrag selected indexes on
a chosen table, one after the other, and has scheduling facilities
built in.
If anyone is interested in beta-testing it, I would like to hear from
you as it is close to launch. My company is willing to offer a free
copy of the software to anyone who can provide genuine and useful
feedback. Please post back if you are interested!
Regards,
Martin
Larry Smith wrote:
> I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to pro
ve
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry

Defrag on SQL Server.....

I am periodically getting the complaints that SQL Server is slow. As a
performance improvements I decided to run the defrag utility. Never run on
this server from years. How to know that defrag need to be run? How to prove
there is an excessive physical file fragmentation on a Windows 2K?
SQL 2K with SP3 and Windows 2K with latest SP.
Thank you,
LarryLarry,
Check out:
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
HTH
Jerry
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to
> prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||If you refer to the file system, you wouldn't need defrag if you stay away from constantly growing
and shrinking the database files. Keep them at a stable size and increase the size only when needed.
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||I saw your postings about defragging indexes and wondered if anyone
would be willing to help me out. I work for a software house that has
developed database defragmentation software for SQL Server, and we are
looking for beta-testers with DBA knowledge of SQL Server and an
awareness of fragmentation. Our software can defrag selected indexes on
a chosen table, one after the other, and has scheduling facilities
built in.
If anyone is interested in beta-testing it, I would like to hear from
you as it is close to launch. My company is willing to offer a free
copy of the software to anyone who can provide genuine and useful
feedback. Please post back if you are interested!
Regards,
Martin
Larry Smith wrote:
> I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry