| Author |
Topic |
|
buffetbruddahs
Starting Member
5 Posts |
 Posted - 2010-03-27 : 22:50:58
|
| 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.ck |
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-28 : 12:15:24
|
| We need some more details about the system and how it will be used before we can really offer suggestions:1. How large are the databases?2. How many users?3. Is this system replacing an older system? If so what sort of load does it currently have? What sort of config as far as memory/disks, etc?4. Will any apps other than SQL Server be on it? For example some systems that use SQL Server on the backend require being installed on the SQL server.One thing I do once I get my server configged the way I want is do a stress test using SQLIOSim:http://support.microsoft.com/kb/231619===http://www.ElementalSQL.com/ |
 |
|
|
buffetbruddahs
Starting Member
5 Posts |
Posted - 2010-03-29 : 11:14:33
|
| This will be a migration from a sql 2k cluster. There will be about 200 concurrent users.The databases are from 20-50 GB. There are 5-7 databases.The disks will be configured as follows:lun1 will be 300GB for the databseslun2 will be 100GB for the log filesLun3 will be 500GB for the backupslun4 will be 70GB for the snapshotslun5 will be 2GB for the quorumLun6 will be 2GB for the MSDTCck |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-29 : 11:44:58
|
| Have you used perfmon to do any load analysis on the current system?===http://www.ElementalSQL.com/ |
|
|
|
buffetbruddahs
Starting Member
5 Posts |
Posted - 2010-03-29 : 12:41:27
|
| We have a while back and the performance is pretty good. SQL 2k has some weird stuff where it dosn't use both procs and that was one problem that we encountered but other than that, performance was decent. But we are growing and we will be adding additional functionality and users with the upgrade.ck |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-03-29 : 15:21:09
|
| Will it be single instance cluster or multi-instance cluster? If you are going to install multiple instances you should consider capping the memory on each of the instances.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
buffetbruddahs
Starting Member
5 Posts |
Posted - 2010-03-29 : 16:17:56
|
| The idea is for it to be a single instance cluster with multiple db's. Capping the memory per instance is something that would be done inside of SQL right?ck |
|
|
|
buffetbruddahs
Starting Member
5 Posts |
Posted - 2010-03-30 : 02:38:40
|
| So with these specs in mind, what is the best way from a systems standpoint to optimize the memory settings for these servers. Are there any other Windows 2k8 tweeks that I can do to improve performance?ck |
|
|
|
RobertKaucher
Posting Yak Master
169 Posts |
Posted - 2010-03-30 : 19:57:57
|
| It's been my general experience that SQL Server 2008 is pretty well primed out of the box. It seems like your disk subsystem considerations have already been mapped out... I have seen it hog memory, though, on systems where there had to be other apps running along side it. From a reliability stand point you might want to consider capping the memory if that were your case. But that does not seem to be an issue for you. Do you have any things specific to your environment that you are thinking about?And yes, the memory setting can be managed with sp_configure.===http://www.ElementalSQL.com/ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2010-03-30 : 23:31:45
|
| For a single instance cluster, it is recommended that you still cap the memory to allow the OS and other processes some since SQL Server is a memory hog. A Microsoft engineer (SQL expert) recently said to take away 1-2 gigabytes per CPU from SQL Server, but that's if you have a bunch of memory like we do on our systems. How much memory will you have on each node? And how many CPUs?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
New SQL 2k8 x64 servers