<div>
Your system's performance majorly depends on how your create databases on them. Basically your database design strategy has to be full proof. You need know ur tables, their relationship with other tables, index requirements of those tables, physical organization of table data and indexes and database growth estimation. These parameters would be decided during your designing. After that you need to have a fullproof backup and maintenance checks planning for consistent performance of your overall system.
</div>


Your system's performance majorly depends on how your create databases on them. Basically your database design strategy has to be full proof. You need know ur tables, their relationship with other tables, index requirements of those tables, physical organization of table data and indexes and database growth estimation. These parameters would be decided during your designing. After that you need to have a fullproof backup and maintenance checks planning for consistent performance of your overall system.

<div>
Thanks, I'll take your advice on the AWE
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
We've just installed a new SQL server. &nbsp;It's running 64bit Windows 2008 Server Std and SQL 2008. &nbsp;It will be used exclusively for our SQL application. &nbsp;It has 12gb ram and the database is around 5gb.<br />
<br />
What configuration changes would you advise to SQL to get the best out of the system, or should I leave the defaults. &nbsp;In particular should I enable the AWE?<br />
<br />
Thanks<br />
<br />

</div>
</div>


Hello,

We've just installed a new SQL server.  It's running 64bit Windows 2008 Server Std and SQL 2008.  It will be used exclusively for our SQL application.  It has 12gb ram and the database is around 5gb.

What configuration changes would you advise to SQL to get the best out of the system, or should I leave the defaults.  In particular should I enable the AWE?

Thanks



Configuring SQL server

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

Microsoft Server OS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.