Browse by Tags

How to monitor transaction activity between the databases?

Published 10 January 8 4:23 AM | SSQA.net

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

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

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