October 2, 2007 at 12:18 am
Hi,
we have a few SQL server machines running on Windows 2003 server. However they have different Windows server role configuration, file server or application server or none.
I am going to migrate SQL databases to a new machine. What kind server role should I configure for a SQL server host to have optimal performance?
Thanks,
Sherry
October 2, 2007 at 12:52 am
I usually don't use any of these preconfigured roles. If you choose application server it will install IIS and ASP.net. If you want to use Reporting Services you will need these, but otherwise I would say do not install them. I cant remember what the fileserver option does, but SQL Server should run fine without it.
Markus
[font="Verdana"]Markus Bohse[/font]
October 2, 2007 at 12:54 am
I got this from last years SQLPass conference:;)
Potential for enormous filesystem cache on 64-bit can create external memory pressure !
Configure OS to favor memory for programs, not filesystem.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 2, 2007 at 4:03 pm
Thanks Markus and ALZDB.
We are running OS (32-bit). I will try not configuring any role. on windows 2003 server there are performance advance options:
1. choose how to allocate processor resources.
adjust for best performance of:
a. programs
b. background services
2. choose how to allocate system memory.
adjust for best performance of:
a. Programs
b. system cache
should I choose b for 1 and a for 2 OR a for both?
SQL components (SQL server and Agent etc) are also running as services.
Thanks for your help,
Sherry
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply