<div>
FYI<br />
many DBAs I trust highly recommend Ola's scripts (nb: I am not a DBA)<br />
<br />
here is some additional information you may find helpful<br />
<br />
This conference video is a useful introduction as Ola explains his approach and answers questions: <a href="http://sqlbits.com/Sessions/Event9/Inside_Ola_Hallengrens_Maintenance_Solution" rel="ugc">recommended video</a><br />
<br />
An alternative that many others recommend is:<br />
<a href="http://www.brentozar.com/blitzindex/" rel="ugc">http://www.brentozar.com/blitzindex/</a>
</div>


FYI
many DBAs I trust highly recommend Ola's scripts (nb: I am not a DBA)

here is some additional information you may find helpful

This conference video is a useful introduction as Ola explains his approach and answers questions: recommended video [http://sqlbits.com/Sessions/Event9/Inside_Ola_Hallengrens_Maintenance_Solution]

An alternative that many others recommend is:
http://www.brentozar.com/blitzindex/ [http://www.brentozar.com/blitzindex/]

<div>
<div class="content wysiwyg-content">
After a year or so our programs that rely on MSSQL get slow and sluggish and the CPU stays fairly busy, most of the time around 100%. About once a year our SQL databases get re-indexed by an outside company. Whatever it is they do it does reduce CPU load significantly. They call it re-indexing but we assume what they are doing is defragging the tables. We would like to do this internally so we are not relying on a third party anymore. Would anyone be willing to educate me on what is being done basically and how you can tell if it needs it?<br />
<br />
Windows 2008/SQL 2008
</div>
</div>


After a year or so our programs that rely on MSSQL get slow and sluggish and the CPU stays fairly busy, most of the time around 100%. About once a year our SQL databases get re-indexed by an outside company. Whatever it is they do it does reduce CPU load significantly. They call it re-indexing but we assume what they are doing is defragging the tables. We would like to do this internally so we are not relying on a third party anymore. Would anyone be willing to educate me on what is being done basically and how you can tell if it needs it?

Windows 2008/SQL 2008

MSSQL defrag/re-index.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.