Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
idforstuff
Starting Member
6 Posts |
 Posted - 2008-10-13 : 14:08:43
|
| For all the knowledgeable DBAs out there: please consider the following configuraiton:8 core x64 CPU8 - 16 GB RAMSQL Server 2005 Standard Edition with all latest patches applied.4 CPUs dedicated to SQL Server4 CPUs dedicated to client application. Client application is NOT AWE aware.Is there something inherent in the above configuration due to which you would ward people (me) away from the above configuration? Maybe there are some known SQL Server bugs/issues that would cause problems with the above? Any constructive feedback you can give will be appreciated.Many thanks in advance,idforstuff |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-13 : 14:22:29
|
| The only issue I have seen in SQL 2005 64-bit standard/edition is that you can't enable "Lock pages in Memory' like in enterprise edition due to which you will see ' Memory paging out ' even though you have sufficient memory. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-10-13 : 15:19:10
|
| It is always better to install the client application on a different server.CODO ERGO SUM |
|
|
|
|
|
|
Opinion needed about hardware/software config