jknj72
asked on
SQL Server - Windows server specs
My network guy is about to set up a Windows/SQL server for me and wants to know what I need. I have SQL Server 2008 R2 and am asking the best version of Windows to install (2008Rs or 2012). I will be using this server for Business Intelligence apps. We will be running SSIS packages, processing cubes and will also be using it as a Reporting Server with SSRS and more. With all this running on the server what would be the best configuration as far as hardware, versions, service packs, processors, etc...He said I can have whatever I need so Id like to run the most optimal setup. I have my SQL Server info below so if you guys/gals could point me to the best route for installing my Windows/SQL Server, Id really appreciate it.
Thanks
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5446
Operating System 6.1.7601
Thanks
Microsoft SQL Server Management Studio 10.50.1600.1
Microsoft Analysis Services Client Tools 10.50.1600.1
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5446
Operating System 6.1.7601
ASKER
I cant read the article without being a member. I remember reading that SQL Server can use up to 4 processors? I just need to know what versions I should be using and hw to run it optimally.
I don't understand "what versions I should be using"? You said 2008R2, so that's the version.
And as I said, it depends on how many users, what load it will be under, etc. Is it just one user?
And as I said, it depends on how many users, what load it will be under, etc. Is it just one user?
The recommended specs are here: https://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx
Basically, as fast a processor and as much memory as you can. If you want it very fast for a 1 user system, add an SSD hard drive.
Basically, as fast a processor and as much memory as you can. If you want it very fast for a 1 user system, add an SSD hard drive.
ASKER
Windows version is what I meant. I would say 20 users. I may be running replication as well too. I will check out the article
What will be the purpose of the server? Support a production environment? If so, I highly recommend you to separate the SQL Server engine from the rest of BI tools (SSAS, SSIS and SSRS).
Which Edition of SQL Server are you going to install? Only Express Edition requires .NET framework 2.0 SP2. All the rest requires .NET framework 3.5 SP1.
Which Edition of SQL Server are you going to install? Only Express Edition requires .NET framework 2.0 SP2. All the rest requires .NET framework 3.5 SP1.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thats what I was looking for. Thanks Dirk
It depends on how many users, what load it will be under, etc.
If it is just for a developer license, then a standard desktop will be sufficient - that's what I use at home.
If not, then I suggest this guide could help: http://searchsqlserver.techtarget.com/tutorial/Step-by-Step-Guide-How-to-spec-your-SQL-Server-hardware-needs