Personal Notes of Edwin Eu

Server Configuration

In Microsoft SQL Server on 06/29/2012 at 2:26 PM

I’m very impressed with an article that I found on SQL Server Pro.

http://www.sql-server-pro.com/sql-server-configuration.html

The article discussed how to installing and configuring Microsoft SQL Server  after completed  the software installation.

In addition, the article discussed and explained detail on each SQL Server Configuration components.

  • Affinity Mask
  • Affinity IO Mask
  • Cost Threshold for Parallelism
  • Fill Factor
  • Index Create Memory
  • Locks
  • Max Degree Of Parallelism
  • Max Worker Threads
  • Min and Max Server Memory
  • Min Memory Per Query
  • Piority Boost
  • Recover Invertal
  • Disk Configuration
  • Startup Options

To view SQL Server Configuration:

Method 1:

EXEC SP_CONFIGURE ‘Show Advanced Options’, 1

GO

RECONFIGURE

GO

EXEC SP_CONFIGURE

GO

Method 2:

SELECT * FROM  SYS.CONFIGURATIONS

GO

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: