<div>
@ashilo, thanks but looking at that doc you provided its really more of a &quot;salesy&quot; very high overview of things to check.<br />
<br />
I'm looking for more specific settings, areas to look at in SQL 2008 server, like memory settings, archive log settings, etc.<br />
<br />
That is the type of specifics I&quot;m looking for and need.<br />
<br />
thanks.
</div>


<div>
<div class="content wysiwyg-content">
I have a client that is on SQL 2008 Server for there database for the ERP software they use (JD Edwards).<br />
<br />
I have been tasked with doing an audit on there system, including there SQL 2008 Server.<br />
<br />
I have worked with SQL 2000 &amp;&nbsp;2005 but not much with 2008.<br />
<br />
I wanted to see if I could get some of the SQL 2008 experts to give me a list of areas to check on the SQL 2008 server that would be important to check for audit purposes and what your recommendations might be.<br />
<br />
For example, what memory requirements should be, etc.<br />
<br />
Just something that will help get me on the right track. If you have any documentation on SQL 2008 performance that would be great as well!<br />
<br />
This is a high priority as this audit will begin Monday Feb 18th. <br />
<br />
Thanks!
</div>
</div>


I have a client that is on SQL 2008 Server for there database for the ERP software they use (JD Edwards).

I have been tasked with doing an audit on there system, including there SQL 2008 Server.

I have worked with SQL 2000 & 2005 but not much with 2008.

I wanted to see if I could get some of the SQL 2008 experts to give me a list of areas to check on the SQL 2008 server that would be important to check for audit purposes and what your recommendations might be.

For example, what memory requirements should be, etc.

Just something that will help get me on the right track. If you have any documentation on SQL 2008 performance that would be great as well!

This is a high priority as this audit will begin Monday Feb 18th. 

Thanks!

@ashilo, thanks but looking at that doc you provided its really more of a &quot;salesy&quot; very high overview of things to check.

I&#39;m looking for more specific settings, areas to look at in SQL 2008 server, like memory settings, archive log settings, etc.

That is the type of specifics I&quot;m looking for and need.

thanks.

Can You provide Things I should Check on SQL 2008 Server for Audit Purposes?

I have a client that is on SQL 2008 Server for there database for the ERP software they use (JD Edwards).

I have been tasked with doing an audit on there system, including there SQL 2008 Server.

I have worked with SQL 2000 &amp; 2005 but not much with 2008.

I wanted to see if I could get some of the SQL 2008 experts to give me a list of areas to check on the SQL 2008 server that would be important to check for audit purposes and what your recommendations might be.

For example, what memory requirements should be, etc.

Just something that will help get me on the right track. If you have any documentation on SQL 2008 performance that would be great as well!

This is a high priority as this audit will begin Monday Feb 18th. 

Thanks!

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Enterprise software, also known as enterprise application software (EAS), is computer software used to satisfy the needs of an organization, including businesses, schools, interest-based user groups, clubs, charities, or governments. Services provided by enterprise software are typically business-oriented tools such as online shopping and online payment processing, interactive product catalogue, automated billing systems, security, enterprise content management, IT service management, customer relationship management (CRM), enterprise resource planning (ERP), business intelligence (BI), project management, human resource management (HR), manufacturing and supply chain management, enterprise application integration (EAI), and enterprise forms automation. Enterprise software is often available as a suite of customizable programs that require specialist capabilities.