Monthly Archives: March 2006

When SQL server 2005 is installed, it starts a default trace. Run the following query: SELECT * FROM ::fn_trace_getinfo (0) If you donot have any server side or sql profiler trace is ruuning, it still shows a trace. … Continue reading →

SQL server 2005 exposes server states information by dynamic management views (DMV). In SQL 2000, it’s not easy to get server information. This can be easily done in SQL 2005 by means of an os DMV view: sys.dm_os_sys_info The following query … Continue reading →