Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 445
  • Last Modified:

Configuring SQL server

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

0
Petermcg001
Asked:
Petermcg001
  • 2
1 Solution
 
sachitjainCommented:
No you should not enable AWE as it has its performance overheads. You could run sp_configure with show advanced options and there you could find list of various server parameters with their default values. Each server parameter has a significant meaning pertaining to system's performance. You could know more about each of them through different Internet forums and set them based on your requirement. For most of the scenarios, keeping them as default suits well.
0
 
sachitjainCommented:
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.
0
 
Petermcg001Author Commented:
Thanks, I'll take your advice on the AWE
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now