Solved

Windows Server performance tuning for SQL Server database ?

Posted on 2011-03-13
4
305 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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Windows Task Scheduler: Access to an Executable File 5 38
SpaceMonger Issue 4 33
2008 R2 export VM includes VHD 1 21
Can I skip a node in XML? 9 32
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

756 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