Browse by Tags

• activity
• cache
• cpu
• databases
• performance
• sql server
• statistics
• tsql

How to monitor transaction activity between the databases?
10 January 08 03:23 AM | SQL Master | 2 Comments   

Recently I have been through interesting forum post on SQL Server performance website that a user asking how to monitor transaction activity between the databases without using a third party tool. Until SQL 2000 version it is not that easy to get more Read More...

Filed under: sql server, dmv, databases, tsql, statistics, i/o, activity

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