Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665

    Unanswered: New SQL Server.....

    I have just goten in my gruby little hands a brand spanking new server to run SQL on. Im talking about a beast of a box with 8 processers and 16 gig of ram. Im loading SQL server enterprise on it and have been raised with a question. The server peps here, "it profesionals" seem to think that i need to keep 2 processors free for the os. from everything that i have read threw my studies of SQL i have seen that that is crap, that SQL will give the os its resources as it needs them. Any thoughts on this and or any Microsoft articles that prove your positions? Any help would be great here thanx
    Jim

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    First have some respect and wash your hands!

    Now... If this server is ONLY used for MSSQL server then reserving 2 processers for the OS is stupid. If you run allot of jobs or have software, other than MSQL stuff, running then reserve 1 processer AFTER seeing the remaining 7 running at 100% utilization 100% of the time. You can alter the cpu affinity at any time.

    If you follow the recommendations I would be you would see the 2 OS cpus peg 100% about 0.000001% of the time and idle the remaining 99.999999% of the time!

    I would ask the "professionals" to defend their point.
    Last edited by Paul Young; 05-07-03 at 15:21.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Originally posted by Paul Young
    First have some respect and wash your hands!

    Now... If this server is ONLY used for MSSQL server then reserving 2 processers for the OS is stupid. If you run allot of jobs or have software, other than MSQL stuff, running then reserve 1 processer AFTER seeing the remaining 7 running at 100% utilization 100% of the time. You can alter the cpu affinity at any time.

    If you follow the recommendations I would be you would see the 2 OS cpus peg 100% about 0.000001% of the time and idle the remaining 99.999999% of the time!

    I would ask the "professionals" to defend their point.
    Im with u on this one. When i set this thing up its gona go full throtel
    thanx
    any more feed back would also be nice
    Regards Jim

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •