Browse by Tags

SQL Server High Number of User Connections found on PERFMON, how to resolve it?

Published 3 June 8 3:7 AM | SSQA.net

I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as...

Filed under: sql server, performance, sysmon, 2000, 2005, high cpu, perflib, activity, user connections, mars

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