I am using your SS 2027R-N3RF4+ and 2027R-N3RFT+ server.
I have a question:
I need to boost up performance on my SQL 2005 SP4 Standard x64, with Windows 2008 R2 server.
I was looking into the CMOS setting to improve performance but still not seeing much improvements after making the following changes:
? I set the power settings to "Performance", disabled virtualization support, and disabled hyper threading.
My question is that are there any additional settings I can change to improve overall SQL performance and reduce system latencies?
For applications like SQL server, no BIOS setting targeted to improve its performance, you may want to check below:
http://msdn.microsoft.com/en-us/library/ms188284(v=sql.105).aspx
and
http://msdn.microsoft.com/en-us/library/ff647793.aspx
for some suggestions or work around.
Print
Share