The system DMV sys.dm_os_schedulers is an useful DMV to find such as running tasks & active workers threads etc. This is required to monitor the system state is heavily loaded or not, in particular this view will help you identify if there is any CPU bottleneck in the SQL Server machine. SELECT ...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies http://support.microsoft.com/kb/931279/en-US...(read more)

Dynamic Management Views (DMV) are very useful to get server state information to monitor the status, but not always you have to still continue in monitoring using SYSMON & PROFILER that are available by default with SQL installation. The engine within SQL Server 2005 improves accuracy by using the high-resolution counters that are capable to ...

Yes it does! Until yesterday even I was under impression that it will not use or cause any issues to the server. But think about performing the SHRINK operation of transaction log & database files on regular basis, say within a scheduled job or ongoing process. Further to my tests refer to this SSPFAQ post for further information in performing ...