Multiple Instances - Properties tuning

From: Citizen (citizen_NOSPAM_at_hotmail.com)
Date: 07/05/04 

Date: Mon, 05 Jul 2004 12:49:48 +0200

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 ?

Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... In the profiler, in the Events tab, click on Security Audit. ... Columnist, SQL Server Professional ... And then I start getting the database closed errors on subsequent calls. ... >>> thing to look at is the permissions for that user in EM. ...
    (microsoft.public.sqlserver.security)
  • Re: file backup component
    ... Otherwise you can try to use audit techniques to find out who's trying to access the LDF file. ... file backup app or any other app that need LDF file a while. ... he meant something that belongs to the SQL server itself. ... Delay the start of the SQL server service until manual start. ...
    (microsoft.public.windowsxp.embedded)
  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Multiple Instances - Properties tuning
    ... Why do you want to install mutiple instances of SQL Server since you have ... memory usage for each instance of SQL Server. ... would you yourself choose to audit All or None? ... > If I were to audit, would I benefit from only auditing failure, or ...
    (microsoft.public.sqlserver.server)
  • RE: Multiple Instances - Properties tuning
    ... Why do you want to install mutiple instances of SQL Server since you have only 1 GB of physical ... memory usage for each instance of SQL Server. ... would you yourself choose to audit All or None? ... > If I were to audit, would I benefit from only auditing failure, or ...
    (microsoft.public.sqlserver.server)