I am new to sql server. I want to tune some databases.
Can anyone please give me the easiest thing to do manually
to tune databases? I know to create indexes on the most
searched columns. I understand the fill factor need and
difference between a clustered and non-clustered index.
1) Can you tell me anything else I need to do to tune the
databases?
2) Can you tell me how to test the indexed tables before
or after indexing to see performance in order to contrast?
3) When looking at performance monitor, what counters
should you set for tuning databases?
Thank you
FrancisYou should probably get a good book on the subject... I personally have read
and enjoyed:
_Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook_ by
Ken England... But search Amazon and you'll find lots of titles to choose
from.
"Francis Molango" <anonymous@.discussions.microsoft.com> wrote in message
news:191c001c42168$c97749d0$a601280a@.phx
.gbl...
> I am new to sql server. I want to tune some databases.
> Can anyone please give me the easiest thing to do manually
> to tune databases? I know to create indexes on the most
> searched columns. I understand the fill factor need and
> difference between a clustered and non-clustered index.
> 1) Can you tell me anything else I need to do to tune the
> databases?
> 2) Can you tell me how to test the indexed tables before
> or after indexing to see performance in order to contrast?
> 3) When looking at performance monitor, what counters
> should you set for tuning databases?
> Thank you
> Francis|||www.Sql-Server-Performance.com
you can spend all day on this site and not read it all.
cheers,
Greg Jackson
PDX, Oregon|||Thank you both.
>--Original Message--
>You should probably get a good book on the subject... I
personally have read
>and enjoyed:
>_Microsoft SQL Server 2000 Performance Optimization and
Tuning Handbook_ by
>Ken England... But search Amazon and you'll find lots of
titles to choose
>from.
>
>"Francis Molango" <anonymous@.discussions.microsoft.com>
wrote in message
> news:191c001c42168$c97749d0$a601280a@.phx
.gbl...
manually[vbcol=seagreen]
the[vbcol=seagreen]
before[vbcol=seagreen]
contrast?[vbcol=seagreen]
>
>.
>
