Solved

Windows Server performance tuning for SQL Server database ?

Posted on 2011-03-13
4
306 Views
Last Modified: 2012-05-11
Hi,

Can anyone share your tips and guidance in configuring Windows Server for SQL Server 2008 Enterprise running on 64 GB  RAM with dual quad core Xeon 5670 ?

in the Windows Performance option should I select "programs" of "background services" ?
0
Comment
Question by:jjoz
[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
4 Comments
 
LVL 29

Accepted Solution

by:
mass2612 earned 250 total points
ID: 35125172
Hi,

Performance tuning is a real mix of art and science so doing so over a medium like this can be difficult. Can you provide some details about your expected database sizes, iops, workload - updates, deletes, reads, etc?

You want to leave Windows set to background processes. Is this a dedicated SQL server? Most often a bottleneck in a large database is going to be disk or memory. Therefore you need to think about the setup of your disks depending on the disk infrastructure i.e. on SAN it may not matter but not always.

Performance Tuning - with Brent
http://www.brentozar.com/sql/sql-server-performance-tuning/

Performance Tuning - SQL ServerPedia
http://sqlserverpedia.com/wiki/Performance_Tuning

Five Classic Videos Every DBA Should Watch
http://www.brentozar.com/archive/2011/03/five-videos-every-dba-should-watch/
0
 
LVL 11

Assisted Solution

by:JoeNuvo
JoeNuvo earned 250 total points
ID: 35125189
some tips to share from my workaround
1. if this server is dedicated as server, the background service should be choosen
2. set limit of your SQL memory, on 64 GB, you should give to SQL upto 60G, leave some for OS and other program to uses
3. take out 1 or 2 of logical processor from SQL, this to allow other process still able to work if by any chance SQL consume full CPU utilize
0
 
LVL 1

Author Comment

by:jjoz
ID: 35125506
thanksforyour reply mate,

'Is this a dedicated SQL server?" yes it is.

I have made;

C:\ Local (RAID 1)
D:\ Log (RAID 1)
E:\ DB (RAID 10)
0
 
LVL 1

Author Closing Comment

by:jjoz
ID: 35144270
many thanks for your reply.
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Suggested Solutions

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.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

738 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