RE: Multiple Instances - Properties tuning
From: Hari Prasad (HariPrasad_at_discussions.microsoft.com)
Date: 07/05/04
- Next message: Jacco Schalkwijk: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Previous message: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- In reply to: Citizen: "Multiple Instances - Properties tuning"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Jul 2004 05:07:02 -0700
Hi,
Why do you want to install mutiple instances of SQL Server since you have only 1 GB of physical
memory in machine.
Better option will be create 2 databases and allocate 1 db for each application.
If you need to install multiple instances of SQL Server always it is recommended to fix the
memory usage for each instance of SQL Server. If you do not have any other application other than
SQL Server in your machine then you can go for even 400 MB for each instamce. THis memory parameter
should be changed based on usage of each instance. You can use Performance monitor to identify the usage.
If I were to audit, would I benefit from only auditing failure, or
would you yourself choose to audit All or None ? Do I audit only when
necessary or all the time ?
I recommend you to audit only the failure, Otherwise you need to enable the c2 Audit mode
which will audit all the activity. SO it uses more resources. During the requirement stages
you can use Profiler to trace the activity.
Do I need to use profiler to set auditing on and off ?
No need, From Query Analyser execute
sp_configure 'c2 audit mode',1
To diable to audit
sp_configure 'c2 audit mode',0
(restart SQL Server service)
I can't see where I should enter this new directory.Is this the SQL server error log ?
As far as i know,You have to change the default data directory
Thanks
Hari
MCDBA
"Citizen" wrote:
> Hope you don't mind another few questions about tuning this multiple
> instances server.
>
> When installing 2 separate instances on MS SQL server 2000 Sp3a, would
> I best leave the configurationof server Memory to SQL server
> (dynamically), or should I allocate manually say 300 MB for each
> instance (Total MB RAM = 1 GB). The applications will not be heavily
> used.
>
> If I were to audit, would I benefit from only auditing failure, or
> would you yourself choose to audit All or None ? Do I audit only when
> necessary or all the time ?
> The BOL say that this file will grow max to 200 MB and that I should
> specify immediately during setup a new directory for these audit
> files. I can't see where I should enter this new directory.
> Is this the SQL server error log ? BOL suggests making a directory
> like MSSQL$instance\audit. That would be in the data directory right ?
> Where do I register this directory in SQL server as the audit
> directory? Do I need to use profiler to set auditing on and off ?
>
> In the Remote Server connections, would you deny remote RPC
> connections to your SQL server or not? Why ?
>
>
>
- Next message: Jacco Schalkwijk: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Previous message: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- In reply to: Citizen: "Multiple Instances - Properties tuning"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
