Return
-
Title
ChangeAuditor requires dedicated SQL server instance -
Description
The "ChangeAuditor Install Guide.pdf" states that, "The ChangeAuditor database be configured on a separate, dedicated SQL server instance."
Is this required for proper functionality? -
Cause
This may not be possible to procure or undesired configuration.
-
Resolution
The ChangeAuditor database should be configured on a SQL server meeting the performance requirements defined in the ChangeAuditor Release Notes. Provided the server hardware handles the extra load from ChangeAuditor this configuration is acceptable.
-
Defect ID
TF00157668 -
Additional Information
SQL Server Top 10 Performance recommendations:http://technet.microsoft.com/en-us/library/cc966534.aspx
Troubleshooting Performance Problems in SQL Server 2005:
http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx