<div>
<div class="content wysiwyg-content">
Currently Running SQL Server 2008R2 <br />
I have a few production Databases <br />
I need to set up auditing to track all changes to these servers and all databases on these servers. <br />
For Example Altered Procedures or dropped indexes or changed passwords plus all other major changes <br />
I need to make sure that it is lightweight since I do not want our production environment to suffer. What type of audit can I set up which is not too taxing on the system? <br />
Or will auditing always have a negative impact on the production environment?
</div>
</div>


Currently Running SQL Server 2008R2 
I have a few production Databases 
I need to set up auditing to track all changes to these servers and all databases on these servers. 
For Example Altered Procedures or dropped indexes or changed passwords plus all other major changes 
I need to make sure that it is lightweight since I do not want our production environment to suffer. What type of audit can I set up which is not too taxing on the system? 
Or will auditing always have a negative impact on the production environment?

SQL Server Auditing

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.