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