InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 08:56:11 GMT20http://www.sqlservercentral.com/Forums/Topic134398-122-1.aspx<P>Colin,</P><P>"Cheers to 'the mess'" </P><P>... excuse the citation ... </P><P>I mean our livelyhood !</P>Mon, 02 Oct 2006 10:23:00 GMTrudy - Doctor "X"http://www.sqlservercentral.com/Forums/Topic134398-122-1.aspxRudy - I totally agree! I normally work within controlled production environments where the use of the GUI is an absolute no-no. You'll never get SOX using the GUI !!! I still worry about some of the content, still it's these changes which keep me employed when i go in and fix the mess &lt; grin &gt;Sun, 01 Oct 2006 11:48:00 GMTcolin.Leversuch-Robertshttp://www.sqlservercentral.com/Forums/Topic134398-122-1.aspxwoman!Fri, 29 Sep 2006 13:39:00 GMTdebrucer1http://www.sqlservercentral.com/Forums/Topic134398-122-1.aspxThis is an excellent article for the GUI DBA ... There is also enough information to get the inexperienced DBA in real trouble as well. However the one piece of information that is missing (as in many SQL things these days) is the command line equivalents for everything there. After all most DBAs rarely do things just once, it's usually many times. The only way tio be truly efficient is to 'automate' it - i.e. script it and become a COMMANDLINE DBA !Fri, 29 Sep 2006 09:52:00 GMTrudy - Doctor "X"http://www.sqlservercentral.com/Forums/Topic134398-122-1.aspx<P>There are some serious errors and misconceptions and this is only going to add to more users messing with options they don't understand!.</P><P>Procs, the number are doubled under w2k3 and procs are also depenedant upon the underlying o/s. You should never check the reserve physical memory unless you are using a fixed memory ( with min and max the same ) Note that once you use awe or instances you MUST fix memory sizes otherwise you will have problems.</P><P>Boost priority should ONLY ONLY ONLY ever be used if ms support tell you, this setting causes major problems. ( it was I understand added for SBS where multiple apps run on a server - the guys I've spoken to at microsoft wish this option was removed as it causes so many support calls )</P><P>fibre mode is relevent only on large multiproc boxes where cpu is almost maxed out and you have very high levels of context switches.</P><P>I could go on -- I fail to see how you can quote the admin guide - did you really read it properly? and how on earth did you come to some of your calculations?</P><P>My advice ( and that of microsoft ) is that unless you really know what you're doing and then really only if microsoft support tell you all config settings should remain "out of the box" Changing settings on a production server could easily bring the system down.</P><P> </P>Fri, 29 Sep 2006 06:09:00 GMTcolin.Leversuch-Robertshttp://www.sqlservercentral.com/Forums/Topic134398-122-1.aspx<P class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN class=postbody1><SPAN style="FONT-SIZE: 9pt"><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p></SPAN></SPAN><SPAN class=postbody1><SPAN style="FONT-SIZE: 9pt">This article is more like a reference material or white paper. I feel it is bit dry..<o:p></o:p></SPAN></SPAN></P>Fri, 29 Sep 2006 01:05:00 GMTRavi Prashanth Lobo-275382http://www.sqlservercentral.com/Forums/Topic134398-122-1.aspx<SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA">An excellent reference resource</SPAN>Tue, 27 Sep 2005 23:51:00 GMTStathis Stathashttp://www.sqlservercentral.com/Forums/Topic134398-122-1.aspxA really nice reference resource, good work, man !Tue, 28 Sep 2004 14:15:00 GMTjeffrey yaohttp://www.sqlservercentral.com/Forums/Topic134398-122-1.aspx<P>Mithrandir,</P><P>From the mouth of Microsoft:</P><P>"On Windows 2000, standard editions of SQL Server support up to four processors. Enterprise Editions support up to 32 processors (8 with Advanced Server and 32 on Data Center Server)." </P><P>I suppose I should have clarified the part about SQL Standard Edition which supports up to 4 processors on Windows 2000 vs. SQL Server 2000 Enterprise Edition (which supports 8 processors on Advanced Server and 32 processors on Data Center Server). Sorry about that. The wording was unclear. Please see the reference link at the bottom of the article to go to Microsoft's Pocket Consultant for SQL Server 2000 for further details.</P>Tue, 28 Sep 2004 08:55:00 GMTDale Coreyhttp://www.sqlservercentral.com/Forums/Topic134398-122-1.aspx<P>Hi.</P><P>Just to point something:</P><P><EM>"Key points (Figure 6):</EM></P><DIV><DIV><EM><STRONG>SQL Server</STRONG> Standard Edition supports up to 4 processors. Advanced Server supports 8 processors. Data Center Server supports 32 processors."</EM></DIV></DIV><P>I think you're really meaning <STRONG>MS Windows</STRONG></P>Tue, 28 Sep 2004 07:48:00 GMTMithrandirhttp://www.sqlservercentral.com/Forums/Topic134398-122-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/dcorey/exploringsqlserver2000configurationproperties.asp>http://www.sqlservercentral.coSun, 29 Aug 2004 20:01:00 GMTDale Corey