Performance Tuning Windows 2008 x64
in [Windows Servers]
|
Prev: Two Servers Simultaneous Write Access to Fibre Channel
Next: OMG D00DZ!1!! 3ViL CORPORAT1ON5 KILLED USERNET &ND ATE ALL OFTHE K1TT3NZ!!!1!!1!!! !
From: CK on 30 Mar 2010 15:10 What can I do prior to installing SQL to performance tune my new SQL 2008 x64 server? Any recommendation re: page file, memory settings, network settings? The servers will be running windows 2008 x64. Any help would be appreciated, thanks.
From: RCan on 31 Mar 2010 15:19
Hi CK, there are really many recommendations or best practices for SQL tuning available..... :-) this is a huge and well documented area which can really help to maximize your system's performance. I personally would recommend to you that you read in deep the following documents around this topic : Performance Tuning Guidelines for Windows Server 2008 R2 http://www.microsoft.com/whdc/system/sysperf/Perf_tun_srv-R2.mspx + Storage Best Practices for SQL http://msdn.microsoft.com/en-us/library/cc966534.aspx http://msdn.microsoft.com/en-us/library/cc966412.aspx + SQL CAT Blog (especially performance area) http://blogs.msdn.com/sqlcat/ In addition you should also check your hardware vendors recommendations for special workloads like SQL. generally SQL and it's database/application performance relies strongly on the I/O performance of the underlying storage subsystem. Hope that helps Regards Ramazan "CK" <CK(a)discussions.microsoft.com> wrote in message news:BA60D329-B642-49E6-BDFF-0B64DEADFC51(a)microsoft.com... > What can I do prior to installing SQL to performance tune my new SQL 2008 > x64 > server? Any recommendation re: page file, memory settings, network > settings? > The servers will be running windows 2008 x64. Any help would be > appreciated, > thanks. |