Configurations – Management Studio and sp_configure

ByDr. SubraMANI Paramasivam

Configurations – Management Studio and sp_configure

Comparing these two there are far more configuration options available using sp_configure. sp_configure is nothing but a query run in a query window in a Management studio. But the server properties can be changed using this query and here are some of the examples.


Once sp_configure query is executed the following 16 options are displayed with its default values. By changing these values the advanced configurations can be set up here.

sp_configure

I will show the detailed options in my next post for most of them. Till then good luck on your search on my blog.

About the Author

Dr. SubraMANI Paramasivam administrator

Dr.SubraMANI Paramasivam is a Data Platform MVP, Power BI Group Leader, International Speaker, Microsoft Certified Trainer and Principal Solutions Architect at DAGEOP Ltd, having 20+ years of DB, BI & Analytics experience. Dr.SubraMANI Paramasivam is a frequent speaker in SQLBITS, PASS Summit, PASS SQL Saturdays, SQLRelay, Data Platform Summit, MCT Summit, SQLServerGeeks Summit, INSIDESQL UK, Data Awareness Programmes, Data Day Events. He likes to enlighten the education & data and started his own journey with FREE Data Awareness Programme (www.dataap.org), in remote areas who are in need. Mani speaks a lot about Visualization, Data Science, R Analytics, Azure concepts, Performance Tuning, DB & SQL Server Architecture, DBA, Partitioning, Resource Governor, Disaster Recovery, High Availability, Development, T-SQL Programming and Microsoft certifications.

Comments Are Closed!!!