configuring sql server (best practice)

Hello,
I was wondering how i could optimize sql server for best practices.
I have looked at the parameters, but what can i do with the memory resources
for example.
Zeke
It depends on what version of SQL Server and what specific
issues you are seeing or are trying to address. For the most
part, you'd want to leave the server configuration settings
alone on SQL Server 7 and above. There are some situations
where modifying the default settings can help but these are
generally implemented to address specific issues and should
be thoroughly tested before implementing on a production
server. You can find some information on the server
configuration settings in the following articles:
HOW TO: Determine Proper SQL Server Configuration Settings
http://support.microsoft.com/?id=319942
Tips for Performance Tuning
SQL Server's Configuration Settings
http://www.sql-server-performance.co...n_settings.asp
-Sue
On Tue, 1 Jun 2004 13:59:53 +0200, "Ezekil"
<ezekiel@.lycos.nl> wrote:

>Hello,
>I was wondering how i could optimize sql server for best practices.
>I have looked at the parameters, but what can i do with the memory resources
>for example.
>Zeke
>
|||Hi Sue,
I'm working with sql server 2000 and it runs with other large dbms's like
oracle. What i would like to achieve is finetune the server so that both
databases runs fully optimized.
Greetings,
Zeke
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:4osob0t3i2t96uguuv72feb95e2l1n7k29@.4ax.com...
> It depends on what version of SQL Server and what specific
> issues you are seeing or are trying to address. For the most
> part, you'd want to leave the server configuration settings
> alone on SQL Server 7 and above. There are some situations
> where modifying the default settings can help but these are
> generally implemented to address specific issues and should
> be thoroughly tested before implementing on a production
> server. You can find some information on the server
> configuration settings in the following articles:
> HOW TO: Determine Proper SQL Server Configuration Settings
> http://support.microsoft.com/?id=319942
> Tips for Performance Tuning
> SQL Server's Configuration Settings
>
http://www.sql-server-performance.co...n_settings.asp[vbcol=seagreen]
> -Sue
> On Tue, 1 Jun 2004 13:59:53 +0200, "Ezekil"
> <ezekiel@.lycos.nl> wrote:
resources
>
|||You wouldn't necessarily use the server configurations to
fine tune things. The default settings work fine in most
cases, changing the settings just to try tweaking things
generally causes more problems. Server settings generally
isn't the first place to go in trying to tuning things up.
You'd want to look at the applications using the databases,
run profiler, pay to indexing/index usage, do overall
monitoring to check for potential server bottlenecks using
PerfMon, etc.
You may want to go through some of the articles at:
www.sql-server-performance.com
-Sue
On Tue, 1 Jun 2004 14:27:12 +0200, "Ezekil"
<ezekiel@.lycos.nl> wrote:

>Hi Sue,
>I'm working with sql server 2000 and it runs with other large dbms's like
>oracle. What i would like to achieve is finetune the server so that both
>databases runs fully optimized.
>Greetings,
>Zeke
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
>news:4osob0t3i2t96uguuv72feb95e2l1n7k29@.4ax.com.. .
>http://www.sql-server-performance.co...n_settings.asp
>resources
>
|||Ezekil,
Have you looked into Best Practices Analyzer? It has just been released:
http://www.microsoft.com/downloads/d...displaylang=en
Tinyurl:
http://tinyurl.com/35cb4
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Ezekil wrote:

> Hello,
> I was wondering how i could optimize sql server for best practices.
> I have looked at the parameters, but what can i do with the memory resources
> for example.
> Zeke
>