Browse by Tags

• analysis
• cache
• databases
• disks
• i/o
• memory
• performance
• server
• sql server
• ssms
• windows

sys.dm_os_schedulers - useful to find on whether your SQL Server engine is weakening!
17 August 07 06:04 AM | SQL Master | 3 Comments   

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

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

List of CPU based DMVs in SQL Server 2005 - best used for hardware analysis
05 August 07 12:32 PM | SQL Master | 5 Comments   

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

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

Using DMVs is it possible to identify whether CPU is hyper-threaded?
29 May 07 06:12 AM | SQL Master | (Comments Off)   

SYS.dm_os_sys_info DMV delivers most important information such as Operating System CPU tick count, hyperthread ratio, physical and virtual memory, as well as the worker and scheduler counts. From the derived values of this DMV if you observe hyperthread_ratio Read More...

Filed under: server, dmv, databases, windows, cpu