SQL SERVER – Check Advanced Server Configuration

I was recently asked following question:

“How I check all the advanced configuration of the SQL Server?”

EXEC sp_configure 'Show Advanced Options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure;

Running above script will return all the advanced server configurations.

Reference: Pinal Dave (http://blog.sqlauthority.com)

About these ads

5 thoughts on “SQL SERVER – Check Advanced Server Configuration

  1. Pingback: SQLAuthority News – A Monthly Round Up of SQLAuthority Blog Posts Journey to SQL Authority with Pinal Dave

    • We need RECONFIGURE as it updates running value (run_value) also, without which it will not change run_value.
      The other option to get updated run_value apart from RECONFIGURE is to stop and start the Server, which is not advisable.
      Also some of the options will not update the run_value even after using RECONFIGURE

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