Appricated.

If any one can give me the best recommandation of optimization of my SQL
Server machine wise or database wise or just let me know what are the
parameters I have to follow to make sure my sql server is perfact running on
the production machine or what sort of things I have to consider for
optimization.
Thanks in advance.
Hi
Start at http://www.sql-server-performance.com/
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:8EB7BFC3-1588-487D-95BA-8DED737343A2@.microsoft.com...
> If any one can give me the best recommandation of optimization of my SQL
> Server machine wise or database wise or just let me know what are the
> parameters I have to follow to make sure my sql server is perfact running
> on
> the production machine or what sort of things I have to consider for
> optimization.
> Thanks in advance.
|||Those links I listed in your last are a good place to start. The default
settings for SQL Server are good in most cases. If you are having
performance issues it is most like due to poor coding or poor db design and
not a setting in SQL Server. Those links will help you to narrow down any
issues you may have.
Andrew J. Kelly SQL MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:8EB7BFC3-1588-487D-95BA-8DED737343A2@.microsoft.com...
> If any one can give me the best recommandation of optimization of my SQL
> Server machine wise or database wise or just let me know what are the
> parameters I have to follow to make sure my sql server is perfact running
> on
> the production machine or what sort of things I have to consider for
> optimization.
> Thanks in advance.