Sys.Configuration

A while ago, I was asked by customer how to tell if an instance parameter is dynamic or rather static (which requires me to restart the instance service). Parameters like fill factor (%) or max degree of parallelism. Does this parameter exist in the short list or do I need the show advance option? So…

0

Check your SQL – default Trace

Every installation of SQL has a default trace. The default trace was introduced in SQL 2005, It is the same trace that we know from the profiler or server but it is a preconfigured trace that is enabled as default. The default trace create five *.TRC file that are been recycle when they arrive to…

5

Four Tips for SQL Tuning for SharePoint Part 3 TEMPDB

    One of the focal points in SQL Server Tuning for SharePoint is around the TEMPDB. A lot of performance issues are caused by the performance of the TEMPDB. TEMPDB is one of the four system databases. Master is the database that contains all the information about the configuration of the SQL Instance. MSDB…

2

Four Tips for SQL tuning for SharePoint Part 2 - Shrink DB

SharePoint DB’s – To shrink or not to shrink the data file,this is the question: SQL Server provides you the ability to shrink the DB orshrink the files [MDF, NDF & LDF]. Shrinking the log file/LDF is quite different from shrinkingthe data file/MDF, NDF. Usually we do not have to shrink the log file (as…

5

Four Tips for SQL tuning for SharePoint Part 1 - MAX DOP

Lately I have been thinking about some of my latest work;mainly I have focused on an one day work shop with one of my colleagues, Amir, who is a SharePoint PFE. Now I’d like to share with you some of the SQL Best Practices for SharePoint. In this post, we will talk about MAXDOP and why MAXDOP…

2