SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Exploring SQL Server 2000 Configuration Properties


Exploring SQL Server 2000 Configuration Properties

Author
Message
Dale Corey
Dale Corey
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1959 Visits: 4
Comments posted to this topic are about the content posted at http://www.sqlservercentral.co


All the best,

Dale

Author:
An Introduction to SQL Server 2005 Management Studio
Mithrandir
Mithrandir
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1062 Visits: 184

Hi.

Just to point something:

"Key points (Figure 6):

SQL Server Standard Edition supports up to 4 processors. Advanced Server supports 8 processors. Data Center Server supports 32 processors."

I think you're really meaning MS Windows


Dale Corey
Dale Corey
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1959 Visits: 4

Mithrandir,

From the mouth of Microsoft:

"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)."

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.




All the best,

Dale

Author: An Introduction to SQL Server 2005 Management Studio
jeffrey yao
jeffrey yao
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1281 Visits: 899
A really nice reference resource, good work, man !



Stathis Stathas
Stathis Stathas
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 3
An excellent reference resource
Ravi Prashanth Lobo-275382
Ravi Prashanth Lobo-275382
SSC-Enthusiastic
SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)SSC-Enthusiastic (190 reputation)

Group: General Forum Members
Points: 190 Visits: 1

This article is more like a reference material or white paper. I feel it is bit dry..


colin.Leversuch-Roberts
colin.Leversuch-Roberts
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15687 Visits: 715

There are some serious errors and misconceptions and this is only going to add to more users messing with options they don't understand!.

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.

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 )

fibre mode is relevent only on large multiproc boxes where cpu is almost maxed out and you have very high levels of context switches.

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?

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.



The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Rudyx - the Doctor
Rudyx - the Doctor
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13594 Visits: 2503
This 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 !

Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
debrucer1
debrucer1
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1732 Visits: 136
woman!

Thanks,

David Russell
Oracle Since 1982
SQL Server Since 1998
colin.Leversuch-Roberts
colin.Leversuch-Roberts
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15687 Visits: 715
Rudy - 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 < grin >

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search