Hello, I am new to all of this and I am wondering what everyone else monitors their SQL Server 2008 with?
Hi Dguerry,
APM has SQL User Experience monitors that are ideal for this sort of monitoring. Using these monitors you can create a SQL query that runs against your server on a scheduled basis and returns results as stats and response times. You could then set threshold and alerts on this monitor to flag this issue.
APM also has a few out of the box SQL monitors that monitor quite a vast array of components on a SQL Server, such as User Connections, transactions per second, deadlocks per second, blocked queries, etc.
What does User Connections, transactions per second, deadlocks per second, blocked queries actually do and where should the results of those be?
We use SQL Stipres (www.sqlstripes.com) which answers most of our monitoring/server access needs.