Re: Hardward Recomendations Please?

Tech-Archive recommends: Fix windows errors by optimizing your registry

In article <eeSfVguFJHA.4864@xxxxxxxxxxxxxxxxxxxx>, steveb@xxxxxxxxxxxx
says...
Thanks everyone for the tips. For a hundred bucks, I can max out the memory
and see if that works. Also, by turning off some of the not needed services
in SEPP has helped. I have the SQL Mgmt Studio but have never used it to
manage memory. I'll begin to look into this. If this works and gets us along
for another year or two, you guys have saved me hours of migration time.
Thanks.


I normally force SQL to use a max of 1.5GB, and I limit CPU selection to
alternate CPU cores, so on a Dual Quad, it would use Cores 1,3,5,7 and
leave 0,2,4,6 for other services and the OS.

On SQL, one thing to be aware of is that on a Dual Quad Core box, not
that you have one, you need to limit parallelism or you can get some
really bad locking on databases and tables.

--
- Igitur qui desiderat pacem, praeparet bellum.
- Calling an illegal alien an "undocumented worker" is like calling a
drug dealer an "unlicensed pharmacist"
spam999free@xxxxxxxxxx (remove 999 for proper email address)
.

Relevant Pages

  • Re: SQL 2008 Ent on Windows 2008 Datacenter SP2 w/6/6core CPU
    ... Bottom line is that SQL 2008 RTM does not have support for more than 64 procs. ... Don't get me wrong I am not saying you don't need that many but I deal with some of the largest sql server installations in the world and you would be surprised at how many run extremely well with just 32 cores. ... Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.setup)
  • Re: Disabling processors
    ... I am pretty sure what Aaron stated was correct in that you need to physically remove the cores otherwise you are liable for them in SQL Server. ... If the vendor is charging you per core for ArcSde that is a different story but if they are trying to get you to pay for more SQL licenses you should look for a more reputable vendor because they are trying to rip you off. ...
    (microsoft.public.sqlserver.setup)
  • Re: SBS 2008 - To Hyper-V or not to Hyper-V
    ... I have a brand new physical server box with 16gb RAM and 2x750GB drives ... ready for a Raid 1 environment ready to go for SBS 2008 premium. ... I would use Hyper-V if you have Dual CPU's with Quad Cores, ... Child SQL server install. ...
    (microsoft.public.windows.server.sbs)
  • Re: Hardward Recomendations Please?
    ... by turning off some of the not needed services ... I normally force SQL to use a max of 1.5GB, and I limit CPU selection to ... On SQL, one thing to be aware of is that on a Dual Quad Core box, not ... How much memory is in use? ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL 2008 Ent on Windows 2008 Datacenter SP2 w/6/6core CPU
    ... The OS has to support it first but since the OS didn't support more than 64 before SQL Server 2008 was released it wasn't 100% ready yet either. ... Don't get me wrong I am not saying you don't need that many but I deal with some of the largest sql server installations in the world and you would be surprised at how many run extremely well with just 32 cores. ...
    (microsoft.public.sqlserver.setup)