Re: Multiple Instances - Properties tuning
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/05/04
- Next message: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Previous message: Ashish Kanoongo: "Diff between xxx_data.mdf and xxx.mdf files"
- In reply to: Citizen: "Multiple Instances - Properties tuning"
- Next in thread: Hari Prasad: "RE: Multiple Instances - Properties tuning"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 5 Jul 2004 17:16:23 +0530
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" <citizen_NOSPAM@hotmail.com> wrote in message news:ogaie0tdj18cb194ubpp7vm971obqsva1j@4ax.com... > 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: David Portas: "Re: Diff between xxx_data.mdf and xxx.mdf files"
- Previous message: Ashish Kanoongo: "Diff between xxx_data.mdf and xxx.mdf files"
- In reply to: Citizen: "Multiple Instances - Properties tuning"
- Next in thread: Hari Prasad: "RE: Multiple Instances - Properties tuning"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
