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 20...

One of the best Performance tools that I use is the PERFMON. PERFMON is a tool that exists out of the box on every windows machine and has lots of counters for almost every application. Perfmon provides current, accurate information on thousands of different attributes of your system. If you open...

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

Installing SQL Server 2008, 2008R2 and 2012 on failover cluster has been significantly changed from SQL Server 2000 and 2005. Installation is performed separately on each node in order to avoid failures and downtime and much more. One of improvements is more "in-depth" pre-installation checks. One of...

See below SQL Server Service Packs and Cumulative Updates List. It will be updated monthly.

Service SID and Or ice age Sid Lately I was asked about service SID during the installation of SQL 2008 Cluster. So I thought about it and wrote this blog post: During the times of SQL 2005, while installing SQL in a cluster configuration we needed to assign elevated permission to a domain group...