Browse by Tags

TSQL to get current executing statements - SQL Server 2005

Published 12 February 8 2:27 PM | SSQA.net

Using SP_WHO or SP_WHO2 is a common way to get list of executing processes currently on the server, within SQL Server 2005 you could take advantage of DMV that lists currently-executing statements. select r.session_id ,status ,substring(qt.text,r.statement_start_offset...

Filed under: sql server, dmv, cache, sp_who, cpu, tsql, queue, execution, runnable

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!

Published 17 August 7 8:4 AM | SSQA.net

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

Filed under: sql server, performance, memory, analysis, ssms, dmv, cpu, disks

List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis

Published 5 August 7 2:32 PM | SSQA.net

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

Filed under: sql server, performance, dmv, cache, i/o, cpu