Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Configuring SQL server

Posted on 2011-02-22
3
Medium Priority
?
440 Views
Last Modified: 2012-05-11
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
Comment
Question by:Petermcg001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
sachitjain earned 2000 total points
ID: 34950852
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
 
LVL 12

Expert Comment

by:sachitjain
ID: 34950874
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
 
LVL 1

Author Comment

by:Petermcg001
ID: 34951865
Thanks, I'll take your advice on the AWE
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question